RE: [Q] procedures to recovery database to certain time?
- From: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
- To: <mccdba1@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 8 Apr 2008 15:17:22 -0400
You don't need the Feb. 20 control files. Your current control files
will work fine.
The rest of your plan sounds fine.
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of dba1 mcc
Sent: Tuesday, April 08, 2008 2:56 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: [Q] procedures to recovery database to certain time?
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/blockbus
ter/text5.com> , No Cost.
Other related posts:
