RE: URGENT 8.1.7 recovery question
- From: <krish.hariharan@xxxxxxxxxxxx>
- To: <Chris.Taylor@xxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 14 Jan 2008 12:36:31 -0700
Come to think of it I have gotten rusty with it using SQL plus as well since
I am so use to executing this using RMAN which you may be able to use even
in this case. If it is SQL plus and you have restored the control file you
would have to say "using backup controlfile" since it wouldn't be the
current controlfile. I am not sure, one way or the other, about the until
clause of the SQL plus recover command.
Regards,
-Krish
Krish Hariharan
President/Executive Architect, Quasar Database Technologies, LLC
http://www.linkedin.com/in/quasardb
_____
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Taylor, Chris David
Sent: Monday, January 14, 2008 12:21 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: URGENT 8.1.7 recovery question
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:
