| RMAN recovery using a new database [message #348514] |
Wed, 17 September 2008 01:44  |
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 #349095 is a reply to message #348514] |
Thu, 18 September 2008 20:14  |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
