Re: Bring up of Cold Backup of RAC Database as NON-RAC Database, with a Few Missing Datafile ?

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_at_infosys.com> 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***
>

--
http://www.freelists.org/webpage/oracle-l