| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Question about RMAN and recovery scenario.
Alex
Someone may reply with better information, but we have been doing disaster recoveries with RMAN, using just the control file. In our case, we are just trying to recover the level 0 backup, but I can't see a reason you couldn't incorporate the level 1 backup as well. If you are just getting started, I would recommend that you purchase Robert Freeman's book Oracle9i RMAN Backup & Recovery. If you are on Oracle8i, Robert provides plenty of details to allow you to use his book against Oracle8i.
I don't see a problem doing what you are proposing. I have just been recovering the Level 0 backup, but going forward to the level 1 should not be a problem. Some people report that in Oracle8i they have been able to extract the control file from the backup, but I gave up and just back it up separately after the RMAN backup. You also need any archive logs created during the RMAN backup.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
Sent: Monday, February 10, 2003 9:14 AM
To: Multiple recipients of list ORACLE-L
Hello Folks,
I am just working with recovery scenarios and have question about
rman.
Consider following situation:
1. Use recovery manager without catalog only control file.
2. Have level 0 database backup + level 1 backup.
If we lost all datafiles except datafiles from SYSTEM it is not a problem to recover database. Also if RMAN uses catalog it works good.
But in scenario if we lost all datafiles (including all files from SYSTEN tablespace) how to recover database?
Thank you for your help.
--
Best regards,
Alex mailto:Oleksandr_A_at_yahoo.co.uk __________________________________________________Do You Yahoo!?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Alex Andriyashchenko
INET: Oleksandr_A_at_yahoo.co.uk
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Feb 10 2003 - 11:33:52 CST
 |
 |