Cold backup is consistent if done right. Why do you want to do a recovery ? Missing datafiles should be dropped with offline option and online redolog files for all threads renamed to existing location. After that you should be able to open database with resetlogs. --romas On 10/24/07, VIVEK_SHARMA <VIVEK_SHARMA@xxxxxxxxxxx> wrote: > > Folks > > > > Qs For Bring up of Cold Backup of RAC Database as a NON-RAC Database (with > a Few Missing Datafiles) is RE-Creation of Control file mandatory? > > > > CASE DETAILS - Cold backup was taken from a Testing RAC (NOT production) > Database (version 10.2.0.2) into Tapes & Database Deleted from respective > machine. > > The Tapes were extracted into a machine having only a NON-RAC ORACLE_HOME > (Same version 10.2.0.2) but into a Different Directory Structure (versus > that from which backup was taken). 25 datafiles were to be found missing in > the Backup Tapes > > > > AIM To Bring UP the Database in its present Condition. > > > > *Approach 1 * > > > > Qs – Is Controlfile RE-Creation Mandatory? If NOT so, Will the following > Steps Work? > > 1 – Using NON-RAC ORACLE_HOME (Same Version) > > 2 - Set cluster_database=FALSE, _no_recovery_through_resetlogs=TRUE in > NON-RAC init.ora > > 3 – Using extracted RAC Controlfile, STARTUP MOUNT > > 4 – Update the same controlfile by issuing "ALTER DATABASE RENAME FILE > 'Old Path' TO 'New Path'; > > 5 – To RE-Create Online Redo Logs issue "RECOVER DATABASE USING BACKUP > CONTROLFILE" followed by "ALTER DATABASE OPEN RESETLOGS". Will this Step 5 > succeed or FAIL ? > > > > *Approach 2* - If Controlfile RE-Creation is Mandatory, Will the following > Steps Work? > > 1 – Using NON-RAC ORACLE_HOME (Same Version) > > 2 - Set cluster_database=FALSE, _no_recovery_through_resetlogs=TRUE in > NON-RAC init.ora > > 3 – Edit the Control file to Trace SQL Script to Remove the Missing > Datafile names & RE-Create the Controlfile after STARTUP NOMOUNT > > 4 – To RE-Create Online Redo Logs issue "ALTER DATABASE OPEN RESETLOGS" > > 5 – Datafiles whose names were purposely Removed from the Controlfile > Trace will appear as "MISSINGnnnnnn" > > 6 – Is Dropping of these ""MISSINGnnnnnn" datafiles possible? > > > > Cheers & thanks > > > > Vivek > > > **************** CAUTION - Disclaimer ***************** > This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended > solely for the use of the addressee(s). If you are not the intended > recipient, please notify the sender by e-mail and delete the original > message. Further, you are not to copy, disclose, or distribute this e-mail > or its contents to any other person and any such actions are unlawful. This > e-mail may contain viruses. Infosys has taken every reasonable precaution to > minimize this risk, but is not liable for any damage you may sustain as a > result of any virus in this e-mail. You should carry out your own virus > checks before opening the e-mail or attachment. Infosys reserves the right > to monitor and review the content of all messages sent to or from this > e-mail address. Messages sent to or from this e-mail address may be stored > on the Infosys e-mail system. > ***INFOSYS******** End of Disclaimer ********INFOSYS*** >