RE: URGENT 8.1.7 recovery question

From: Bobak, Mark <>
Date: Mon, 14 Jan 2008 14:30:39 -0500
Message-ID: <>

Hi Chris,

According to this:

you don't need the to_date() function.



Mark J. Bobak
Senior Database Administrator, System & Product Technologies ProQuest
789 E. Eisenhower, Parkway, P.O. Box 1346 Ann Arbor MI 48106-1346
+1.734.997.4059 or +1.800.521.0600 x 4059<><><>

ProQuest...Start here.

From: [] On Behalf Of Taylor, Chris David Sent: Monday, January 14, 2008 2:21 PM
Subject: URGENT 8.1.7 recovery question

Ok, guys and gals. I just lost an 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

-- Received on Mon Jan 14 2008 - 13:30:39 CST

Original text of this message