Re: [Q] procedures to recovery database to certain time?
Date: Wed, 09 Apr 2008 22:48:32 +0800
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
>18.104.22.168. 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?