Home » RDBMS Server » Backup & Recovery » RMAN recovery using a new database (oracle 10G)
RMAN recovery using a new database [message #348514] Wed, 17 September 2008 01:44 Go to next message
bad kuk
Messages: 6
Registered: December 2002
Junior Member
Hello All,


i've just recently discovered RMAN, and would like to ask the resident gurus for some clarification B)


Let's say i want to back up ORCL using RMAN, using ORCL itself for the RMAN catalog. If something happens to the db, then i wouldn't be able to use the RMAN catalog for restore/recovery, right?




Would this setup work:


1.) Set ORCL as the target db *and* catalog
2.) Set up regular RMAN backups
3.) Export the RMAN user schema along with the RMAN db backup


Then, for restore, i would

1.) set up a new db
2.) restore the RMAN backup files to the proper location(i.e. same setting as the original db)
3.) Create rman_bkp along with the required roles/grants
4.) Recreate tablespace for catalog
4.) Run CREATE CATALOG ...
5.) import using userid=rman_bkp fromuser=rman_bkp touser=rman_bkp
6.) Run RMAN, perform RMAN recovery



(i guess i'm too stingy to set up a separate db for the RMAN catalog B)


tia



Re: RMAN recovery using a new database [message #348524 is a reply to message #348514] Wed, 17 September 2008 02:07 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Don't use the database you backup as the catalog database, it is a non-sense.

Regards
Michel
Re: RMAN recovery using a new database [message #349095 is a reply to message #348514] Thu, 18 September 2008 20:14 Go to previous message
bad kuk
Messages: 6
Registered: December 2002
Junior Member
believe me, i learned that the hard way; i guess it's the price you pay for not reading the manual thoroughly B). good thing it was on a test db.

right now i just set up a very small db on my pc as catalog backend.

Previous Topic: Cloning a database - running into problems
Next Topic: Backup current controlfile
Goto Forum:
  


Current Time: Fri Dec 09 23:18:28 CST 2016

Total time taken to generate the page: 0.24374 seconds