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

Other related posts: