How do you guys backup your RMAN catalog instance? Oracle does not recommend backup catalog using itīs own instance, does that mean I have to create another rman catalog just to backup the other rman catalog?
In 9i you can use RMAN without a catalog database, and it will use the controlfile instead. Providing you backup the controlfile you should be fine. This feature does exist in 8i, but the docs. suggest things can get sticky in a disaster recovery situation. Alternatively, you can create a catalog database on a different machine. If you choose the former read up on the controlfile_record_keep_time init.ora parameter.
IMHO.. if you've got more than one database to back up and/or if you have the space and resources, create an OEM database to store all the goodies in. That way, not only will you have all of your rman info, you'll be able to use the oem tools that require a management server.
The way Oracle is going these days with 10g it almost behooves one to plod along with creating a management server.
Oracle it's not just a database it's a lifestyle!
-------------- BTW....You need to get a girlfriend who's last name isn't .jpg
Hi,
If you use RMAN with catalog, it means you have 2 instances.
Use RMAN on instance B to backup instance A.
Use RMAN on instance A to backup RMAN catalog on instance B.
Cheers.
It is better to ask and appear ignorant, than to remain silent and remain ignorant.
Reply With Quote
Bookmarks