Re: [Q] procedures to recovery database to certain time?

As you'll be doing an Incomplete Recovery , it doesn't really matter which controlfiles you use. However, if you use the 03-Jan controlfiles, be aware if there have been database structural changes (tablespaces/datafiles added/dropped) between then and 20-Feb.

Hemant K Chitale

At 02:55 AM Wednesday, dba1 mcc wrote:
>I need recover database to Jan 20, 2008. My ORACLE version is
>9.2.0.8. I have following files:
>
>1. full cold backup on Jan. 3, 2008
>2. full cold backup on Feb 20, 2008
>3. all Archive logs file on January and February
>
>My plan are:
>
>1. copy "jan 3, 2008" database back except control files.
>2. copy "feb 20, 2008" control files back.
>3. startup mount
>4. recovery to jan 20.
>
>
>Does anyone know this procedures work or NOT?
>
>Thanks.

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