RE: URGENT 8.1.7 recovery question

In my scripts I'm not using to_date() fumnction:  

SQL> recover database until time '2008-01-14:12:31:00';  

And, yes if you are restoring backup control files, then:  

SQL> recover database until time '2008-01-14:12:31:00' using backup control file;  

Also, I'm doing:  

SQL> startup mount exclusive;  

Igor

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 2: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