Re: [Q] procedures to recovery database to certain time?
- From: Hemant K Chitale <hkchital@xxxxxxxxxxxxxx>
- To: mccdba1@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- 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
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
