| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Bring up of Cold Backup of RAC Database as NON-RAC Database,with a Few Missing Datafiles ?
Folks
Attempting to Create Controlfile from "backup control file to Trace SQL Script" (Approach 2) is failing with the following Error:-
CREATE CONTROLFILE SET DATABASE "PNBMB" RESETLOGS NOARCHIVELOG
*
ERROR at line 1:
ORA-01967: invalid option for CREATE CONTROLFILE
NOTE - 25 Datafile NAMES are mentioned in the respective "backup control file to Trace SQL Script" which are NOT physically present (i.e. Missing) in the respective Directory. These few datafiles have been permanently Lost. Is this the Cause for the Above Error?
Qs 2 - Should the "backup control file to Trace SQL Script" be Edited to Remove the Lines corresponding to the Lost Datafiles & Control file re-creation attempted? Qs 3 - If re-creation is successful, the Lost Datafiles may appear as "MISSINGnnnnnn" on Opening of the Database. Can such "MISSINGnnnnnn" files be Dropped?
Cheers
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 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?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.
**************** CAUTION - Disclaimer *****************
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Oct 24 2007 - 17:07:39 CDT
 |
 |