Home » RDBMS Server » Backup & Recovery » backup of RMAN database by using RMAN it self
backup of RMAN database by using RMAN it self [message #152715] Mon, 26 December 2005 18:21 Go to next message
skodman
Messages: 10
Registered: March 2005
Location: Auckland
Junior Member
Hi

i am new here and i have one maybe silly question. I have to schedule backup of rman catalogue and i saw that previous dba has made backup of rman catalogue with rman extension. So, my question is how can i make backup of RMAN database by using RMAN it self? Sounds to me like there will be endless loop involved or am i wrong?

cheers
Re: backup of RMAN database by using RMAN it self [message #152723 is a reply to message #152715] Mon, 26 December 2005 19:36 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Just an exported dump of RMAN database would do.
Take an export after every backup.
Re: backup of RMAN database by using RMAN it self [message #152765 is a reply to message #152723] Mon, 26 December 2005 23:52 Go to previous messageGo to next message
skodman
Messages: 10
Registered: March 2005
Location: Auckland
Junior Member
export to a flat file so i can later import it with sql*loader?

regards
Re: backup of RMAN database by using RMAN it self [message #152772 is a reply to message #152765] Tue, 27 December 2005 00:13 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member
export means using EXP utility provided by oracle.
Re: backup of RMAN database by using RMAN it self [message #153007 is a reply to message #152715] Wed, 28 December 2005 06:18 Go to previous messageGo to next message
surroad
Messages: 3
Registered: December 2005
Junior Member
how to exp the catalog database?
Re: backup of RMAN database by using RMAN it self [message #153010 is a reply to message #153007] Wed, 28 December 2005 06:25 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Same method you export any other regular database.
Use exp commands.
Look into utilities manual or search the forum.
Re: backup of RMAN database by using RMAN it self [message #155150 is a reply to message #152723] Thu, 12 January 2006 10:32 Go to previous messageGo to next message
fnguy
Messages: 39
Registered: January 2006
Member
Exporting after every backup is impractical. If you're backing up many databases like I do you can end up with several hundred backups in a day.
Re: backup of RMAN database by using RMAN it self [message #155151 is a reply to message #155150] Thu, 12 January 2006 10:44 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
do a full database export.
>> If you're backing up many databases like I do you can end up with several hundred backups in a day
It is a different case. ( above assumed case is a fairly static RMANDB.).
Here, the RMANDB / Catalog database is almost like a transactional database ( say 100 backups spanning through 24 hours).
Then i would consider RMAN backup on RMANDB.
Previous Topic: how to know SID of database
Next Topic: Can / Should rollback segments be backed up?
Goto Forum:
  


Current Time: Mon Dec 23 03:43:51 CST 2024