RE: URGENT 8.1.7 recovery question
Date: Mon, 14 Jan 2008 13:27:55 -0600
Message-ID: <17E4CDE8F84DC44A992E8C00767402E0860E8E@spobmexc02.adprod.directory>
I neglected to mention that I will replace the controlfiles (correct?)
With the ones from the backup.
Seems like I have to a 'recover database using backup controlfile until time to_date('01/14/2008 12:31:00','MM/DD/YYYY HH24:MI:SS');
But that seems an abnormally long command.
A little help? :-)
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
From: Taylor, Chris David
Sent: Monday, January 14, 2008 1: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-lReceived on Mon Jan 14 2008 - 13:27:55 CST