RE: Basic Recovery Qs ?
- From: VIVEK_SHARMA <VIVEK_SHARMA@xxxxxxxxxxx>
- To: Asif Momen <asif_oracle@xxxxxxxxx>, "finn.oracledba@xxxxxxxxx" <finn.oracledba@xxxxxxxxx>
- Date: Thu, 25 Oct 2007 02:11:00 +0530
Thanks Folks for responding.
To clarify:-
Qs 1 - Should the "backup control file to Trace SQL Script" be Edited & the
Missing Datafile NAMES be Removed to enable re-creation of the Controlfile?
Qs 2 - If the Above Missing Datafile Names are NOT Removed from the "backup
control file to Trace SQL Script", will the Control file Creation Fail?
NOTE - The Missing Datafiles had got missed out in the previous Cold Back up to
Tape by oversight & are thus Lost forever.
NOTE - The respective "backup control file to Trace SQL Script" is also
extracted from the Tape along with the Cold Backup.
NOTE - After taking of Previous Cold Backup to Tape, the Database had been
removed from the Machine.
Oracle 10gR2
Cheers
Vivek
________________________________
From: Asif Momen [mailto:asif_oracle@xxxxxxxxx]
Sent: Monday, October 22, 2007 4:32 AM
Hi Vivek,
Datafiles are marked MISSING when they are offline/read-only. Do you have
datafiles in offline/read-only state in your production database?
You can identify which MISSING file is associated with which actual data file.
MISSINGnnnn is the normal file naming convention, where "nnnn" is the file
number in decimal.
After creating the controlfile, you may rename all MISSING files with their
respective datafile's instead of dropping them.
Regards
VIVEK_SHARMA <VIVEK_SHARMA@xxxxxxxxxxx> wrote:
Folks
For a Test Database the Controlfile needs to be CREATED from an existing
"backup control file to Trace SQL Script" but a few Datafiles are MISSING.
How is the Controlfile to be created in such a case?
I am assuming the following Steps:-
1)Missing datafile names should NOT be Removed from the Controlfile Trace SQL
Script
2)Control file should be created.
3)Thereafter Missing datafiles should be Dropped.
Cheers & Thanks
Vivek
Oracle 10gR2
Solaris 10
**************** 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:
