RE: URGENT 8.1.7 recovery question

From: M Rafiq <rafiq9857_at_hotmail.com>
Date: Mon, 14 Jan 2008 15:17:55 -0500
Message-ID: <BAY107-W412A8E989390E7A7F7DB49A1460@phx.gbl>

In case if yiu have lost control file you may create it as well. I am enclosing script here for ready reference. You may replace your database and log files info. You may also ignore recovery part to make it time recovery.  

i recently used this script for 8.1.7 database with hotbackup.  

Hope it will help.  

Regards
Rafiq  

STARTUP NOMOUNTCREATE CONTROLFILE REUSE DATABASE "WINS" RESETLOGS NOARCHIVELOG MAXLOGFILES 32 MAXLOGMEMBERS 2 MAXDATAFILES 254 MAXINSTANCES 1 MAXLOGHISTORY 10210LOGFILE GROUP 1 ( 'E:\ORANT\ORADATA\WINS\REDO01.LOG', 'E:\ORANT\ORADATA\WINS\REDO01B.LOG' ) SIZE 1M, GROUP 2 ( 'E:\ORANT\ORADATA\WINS\REDO02.LOG', 'E:\ORANT\ORADATA\WINS\REDO02B.LOG' ) SIZE 1M, GROUP 3 ( 'E:\ORANT\ORADATA\WINS\REDO03.LOG', 'E:\ORANT\ORADATA\WINS\REDO03B.LOG' ) SIZE 1MDATAFILE 'E:\ORANT\ORADATA\WINS\SYSTEM01.DBF', 'E:\ORANT\ORADATA\WINS\RBS01.DBF', 'E:\ORANT\ORADATA\WINS\USERS01.DBF', 'E:\ORANT\ORADATA\WINS\TEMP01.DBF', 'E:\ORANT\ORADATA\WINS\TOOLS01.DBF', 'E:\ORANT\ORADATA\WINS\WINS_INDX01.DBF', 'E:\ORANT\ORADATA\WINS\WINSDATA01.DBF', 'E:\ORANT\ORADATA\WINS\WINSDATA02.DBF', 'E:\ORANT\ORADATA\WINS\WINSDATA03.DBF', 'E:\ORANT\ORADATA\WINS\WINS_INDX02.DBF', 'E:\ORANT\ORADATA\WINS\WINSDATA04.DBF', 'E:\ORANT\ORADATA\WINS\WINS_INDX03.DBF', 'E:\ORANT\ORADATA\WINS\WINS_INDX04.DBF'CHARACTER SET WE8ISO8859P1;RECOVER DATABASE until cancel using backup controlfile;ALTER DATABASE OPEN resetlogs;

Subject: RE: URGENT 8.1.7 recovery questionDate: Mon, 14 Jan 2008 15:05:32 -0500From: ineyman_at_perceptron.comTo: Chris.Taylor_at_ingrambarge.com; oracle-l_at_freelists.org

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 DavidSent: Monday, January 14, 2008 2:21 PMTo: oracle-l_at_freelists.orgSubject: 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  



Get the power of Windows + Web with the new Windows Live. http://www.windowslive.com?ocid=TXT_TAGHM_Wave2_powerofwindows_012008
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jan 14 2008 - 14:17:55 CST

Original text of this message