RE: URGENT 8.1.7 recovery question

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Taylor, Chris David
Sent: Monday, January 14, 2008 12:21 PM
To: oracle-l_at_freelists.org
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_at_ingrambarge.com  

--

http://www.freelists.org/webpage/oracle-l Received on Mon Jan 14 2008 - 13:36:31 CST