URGENT 8.1.7 recovery question
- From: "Taylor, Chris David" <Chris.Taylor@xxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 14 Jan 2008 13:21:13 -0600
Ok, guys and gals. I just lost an 8.1.7.4 db that doesn't use RMAN.
I have totally forgotten how to recover {until time} a db that doesn't
use RMAN.
I'm restoring the DB files and the archivelog files and want to recover
until 12:30 PM CST.
Help me remember the recovery process if you will.
I think its:
SQL> Startup mount;
SQL> recover database until time to_date('01/14/2008
12:31:00','MM/DD/YYYY HH24:MI:SS');
SQL> alter database open resetlogs;
Is that right??
Chris Taylor
Sr. Oracle DBA
Ingram Barge Company
Nashville, TN 37205
Office: 615-517-3355
Cell: 615-354-4799
Email: chris.taylor@xxxxxxxxxxxxxxx
Other related posts:
