Re: Bring up of Cold Backup of RAC Database as NON-RAC Database, with a Few Missing Datafiles ?
- From: "Roman Podshivalov" <roman.podshivalov@xxxxxxxxx>
- To: VIVEK_SHARMA <VIVEK_SHARMA@xxxxxxxxxxx>
- Date: Wed, 24 Oct 2007 16:40:30 -0400
Control file from the backup should be perfectly fine - granted that backup
you have was done correctly.
--romas
On 10/24/07, VIVEK_SHARMA <VIVEK_SHARMA@xxxxxxxxxxx> wrote:
>
> Thanks Romas, folks for responding
>
>
>
> My Qs is embedded below into your e-mail, preceded by =>
>
>
>
> Do feel free to correct my following 2 stated Approaches, as needed.
>
>
>
> Cheers
>
>
> ------------------------------
>
> *From:* Roman Podshivalov [mailto:roman.podshivalov@xxxxxxxxx]
> *Sent:* Wednesday, October 24, 2007 11:00 PM
>
> Cold backup is consistent if done right. Why do you want to do a recovery
> ? Missing datafiles should be dropped with offline option
>
>
>
> => Qs – Since Missing Datafiles can only be Dropped in the MOUNT Stage,
> which Control file is being used to Mount the Database? Is it the existing
> RAC Controlfile extracted from Cold Backup Tape (*Approach 1*) OR the
> NEWLY Created Controlfile (*Approach 2*)
>
>
>
> and online redolog files for all threads renamed to existing location.
> After that you should be able to open database with resetlogs.
>
>
>
> --romas
>
>
> ------------------------------
>
> *From:* … *On Behalf Of *VIVEK_SHARMA
>
> 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?
>
>
> **************** 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***
>
Other related posts:
