Hi, We are using Oracle 8i and have successfully recovered the control file from the a backup piece. Like you, we have been testing this for disaster recovery purposes and it works well. There is one tip that I can suggest though.
In the Oracle manuals all the suggested scripts seem to following these steps: backup database including control file archive the current log file backup all archive log files. In a disaster scenario when you are relying on your last backup and may not have access to the most recent redo information or backup catalogue, the above backup steps would only allow you to recovery up to the point of the control file backup - the archive redo logs are essentially useless. The simple tip is to ensure that the control file backup is performed after the archive log backup - that is make it the LAST backup to be done. This way you will be storing ALL information about the latest archive logs and their most recent backups. You know that the last backup piece contains the control file so you can use this to manually recover it. Once you have the control file is it a simple matter to use RMAN to recover the rest of the backup from the control file in the normal way. There is a stored procedure in the Backup and Recovery/RMAN manuals for Oracle 8i. In Oracle 9i this is better supported. Let me know if you cannot find it and I'll send it along. Cheers, Craig. -----Original Message----- Sent: Tuesday, 11 February 2003 4:34 AM To: Multiple recipients of list ORACLE-L 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. [EMAIL PROTECTED] -----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:[EMAIL PROTECTED] __________________________________________________ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Alex Andriyashchenko INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Craig Munday INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
