RE: Basic Recovery Qs ?
- From: "Taylor, Chris David" <Chris.Taylor@xxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 19 Oct 2007 08:21:17 -0500
Why an existing backup contolfile to trace? Why are the datafiles
'missing'? Is this from a production db that is functioning correctly?
(I assume the answer is no)
Maybe this is an archived db that you're restoring from tape or
something to get some old data out of?
Chris Taylor
Sr. Oracle DBA
Ingram Barge Company
Nashville, TN 37205
Office: 615-517-3355
Cell: 615-354-4799
Email: chris.taylor@xxxxxxxxxxxxxxx
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of VIVEK_SHARMA
Sent: Friday, October 19, 2007 8:17 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Basic Recovery Qs ?
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:
