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

I don't think it will work

if you have all archive logs then do this.

restore full backup as of jan 3
restore database until time jan 20

-- 
Mir M. Mirhashimali
Oracle Systems Manager
Database Architecture, Enterprise Applications
Rice University
(713) 348 6365



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.

>

> ------------------------------------------------------------------------

> You rock. That's why Blockbuster's offering you one month of 

> Blockbuster Total Access 

> <http://us.rd.yahoo.com/evt=47523/*http://tc.deals.yahoo.com/tc/blockbuster/text5.com>, 

> No Cost. !DSPAM:59,47fbc21f42851520614011! 

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