RE: Bring up of Cold Backup of RAC Database as NON-RAC Database, with a Few Missing Datafiles ?
- From: VIVEK_SHARMA <VIVEK_SHARMA@xxxxxxxxxxx>
- To: Roman Podshivalov <roman.podshivalov@xxxxxxxxx>
- Date: Thu, 25 Oct 2007 02:04:26 +0530
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:
