Re: Basic Recovery Qs ?

Vivek,

The datafile rename commands Asif is talking about can be found further down in the tracefile containing the "create controlfile" statement. Obviously you need to copy these datafiles from your production system to the test system first.

Finn

On 10/21/07, Asif Momen <asif_oracle_at_yahoo.com> wrote:
>
> 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_at_infosys.com>* 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***
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>

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