RE: URGENT 8.1.7 recovery question
Date: Mon, 14 Jan 2008 14:30:39 -0500
Message-ID: <667C10D184B2674A82068E06A78382B5118FDF85@AAPQMAILBX01V.proque.st>
Hi Chris,
According to this:
http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a82950/ch8.htm#1001420
you don't need the to_date() function.
-Mark
--
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
mark.bobak_at_il.proquest.com<mailto:mark.bobak_at_il.proquest.com>
www.proquest.com<http://www.proquest.com>
www.csa.com<http://www.csa.com>
ProQuest...Start here.
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<mailto:chris.taylor_at_ingrambarge.com>
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jan 14 2008 - 13:30:39 CST