RE: Basic Recovery Qs ?

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_at_ingrambarge.com

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of VIVEK_SHARMA Sent: Friday, October 19, 2007 8:17 AM
To: oracle-l_at_freelists.org
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***

--
http://www.freelists.org/webpage/oracle-l