* SHUTDOWN ABORT, restore all control files and data files (excluding REDO) Prepare (in this, INSERT INTO TEST1 VALUES (13); is not submitted, if fully recovered, you should always see Insert Into Test1 VALUES (12);) SQL> Conn Lunar / Lunar Connected. SQL> Select * from test1; A ---------- 1 2 3 4 5 6 7 8 9 10 11 Rows SELECTED. SQL> Insert INTO TEST1 VALUES (12); 1 row created. SQL> commit; commit completion. SQL> INSERT INTO TEST1 VALUES (13); 1 Row Created. SQL> Single session for Shutdow Abort Microsoft Windows 2000 [Version 5.00. 2195] (c) Copyright 1985-2000 Microsoft Corp. E: /> SQLPlus Internal SQL * Plus: Release 8.1.7.0.0 - Production ON Monday October 21 01:53:09 2002 (C) Copyright 2000 Oracle Corporation Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production with The Partitioning Option JServer Release 8.1.7.0.0 - Production SQL> Shutdown Abort Oracle routines have been turned off.
SQL> copy all of the control files and data files (not including redo) mount databases, follow the prompts to rebuild the password file SQL> startup mount ORACLE instance started. Total System Global Area 25856028 bytes Fixed Size 75804 bytes Variable Size 8925184 bytes Database Buffers 16777216 bytes Redo Buffers 77824 BYTES ORA-01991: Invalid Password File 'D: /oracle1/ora81/database/pwdbackup.ora' SQL> Host Microsoft Windows 2000 [Verstent 5.00.2195] (C) Copyright 1985-2000 Microsoft Corp. E: / > CD D: / Oracle1 / ORA81 / DATABASE E: /> D: D: / Oracle1 / ORA81 / DATABASE> DEL PWDBACKUP.ORA D: / ORACLE1 / ORA81 / DATABASE> ORAPWD FILE = D: / Oracle1 / ORA81 / DATABASE / PWDBackup.ora PA Ssword = Oracle Entries = 10 D: / Oracle1 / ORA81 / DATABASE> EXIT At this time, try to completely restore the database is unsuccessful SQL> Recover Database; ora-00283: Recovery Session Canceled Due To Errors ORA-01610: Recovery Using The Backup ControlFile Option Must Be Done SQL> ALTABASE BACKUP ControlFile to Trace; Database Altered. SQL> Shutdown Immediate; ORA-01109: Database Not O .. Pen Database dismounted ORACLE instance shut down to find and edit the control file STARTUP NOMOUNT CREATE CONTROLFILE REUSE DATABASE "BACKUP" NORESETLOGS ARCHIVELOG MAXLOGFILES 32 MAXLOGMEMBERS 2 MAXDATAFILES 254 MAXINSTANCES 1 MAXLOGHISTORY 453 LOGFILE GROUP 1 'D: /BACKUPDB/REDO01.LOG' SIZE 1M Group 2 'D: /backupdb/redo02.log' size 1m, Group 3 'D: /backupdb/redo03.log' size 1M DataFile 'D: /backupdb/system01.dbf', 'D: / Backupdb / RBS01. DBF ',' D: /backupdb/Users01.dbf ',' D: /backupdb/temp01.dbf ',' D: /backupdb/tools01.dbf ',' D: /backupdb/indx01.dbf '
CHARACTER SET ZHS16GBK; RECOVER DATABASE ALTER SYSTEM ARCHIVE LOG ALL; ALTER DATABASE OPEN;. Rebuild control files SQL> startup nomount ORACLE instance started Total System Global Area 25856028 bytes Fixed Size 75804 bytes Variable Size 8925184 bytes Database Buffers 16777216 bytes Redo Buffers 77824 bytes SQL > @D: /backupdb/udump/ora01532.sql ora-01081: Cannot Start Already-Running Oracle - Shut It Down First Control File Created. ORA-00279: Change 424112 Generated AT 10/20/2002 20:40:52 Needed for thread 1 ORA-00289: suggestion: D: /BACKUPDB/ARCHIVE/BACKUPT001S00001.ARC ORA-00280: change 424112 for thread 1 is in sequence # 1 ORA-00308: can not open archived log 'ALTER' ORA-27041: unable to Open file OSD-04002: Unable to open the file O / S-Error: (OS 2) The system cannot find the specified file.
ALTER DATABASE OPEN * ERROR at line 1: ORA-01113: file 1 needs media recovery ORA-01110: data file 1: 'D: /BACKUPDB/SYSTEM01.DBF' shutdown immediate, and then restore the database SQL> shutdown immediate; ORA- 01109: database not open database dismounted ORACLE instance shut down SQL> startup mount ORACLE instance started Total System Global Area 25856028 bytes Fixed Size 75804 bytes Variable Size 8925184 bytes database Buffers 16777216 bytes Redo Buffers 77824 bytes database mounted completely restored database SQL.... > recover database; ORA-00279: change 424112 generated at 10/20/2002 20:40:52 needed for thread 1 ORA-00289: suggestion: D: /BACKUPDB/ARCHIVE/BACKUPT001S00001.ARC ORA-00280: change 424112 for thread 1 IS in sequence # 1 specify log: { D: /backupdb/archive/backupt001s00003.arc 'No longer Needed for this recovery ora-00279: change 424143 generated at 10/20/2002 21:57:54 Needed for thread 1 ORA-00289: Suggestion: D: / backupdb / ARCHIVE / BACKUPT001S00005.ARC ORA-00280: change 424143 for thread 1 is in sequence # 5 ORA-00278: log file 'D: /BACKUPDB/ARCHIVE/BACKUPT001S00004.ARC' no longer needed for this recovery ORA-00279: change 444145 generated AT 10/20/2002 22:01:23 Needed for Thread 1 ORA-00289: Suggest: D: /backupdb/archive/backupt001s00006.arc ora-00280: Change 444145 for thread 1 is in sequence # 6 ora-00278: log File 'd: /backupdb/archive/backupt001s00005.arc' no longer needed for this recovery ora-00279: change 464194 generated at 10/20/2002 22:24:10 Needed for thread 1 ORA-00289: Suggestion: D: / BACKUPDB / ARCHIVE / BACKUPT001S00007.ARC ORA-00280: change 464194 for thread 1 is in sequence # 7 ORA-00278: log file 'D: /BACKUPDB/ARCHIVE/BACKUPT001S00006.ARC' no longer needed for this recovery ORA-00279: change 484347 Generated at 10/21/2002 00:16:14 Needing for Thread 1 ORA-00289: Suggestion: D: /backupdb/archive/backupt001s00008.arc ora-00280: Change 484347 for thread 1 is in sequence # 8 ORA-00278: Log file 'D: /backupdb/archive/backupt001s00007.arc' no longer needed for this recovery ora-00279: change 484401 generated at 10/21/2002 00:30:27 Needing for thread 1 ORA-00289: Suggestion: D: / Backupdb/archive/backupt001s00009.arc ora-00280: change 484401 for thread 1 is in sequence # 9 ora-00278: log file 'd: /backupdb/archive/backupt001s00008.arc' no longer needed for this recovery ORA-00279: change 484453 generated at 10/21/2002 00:33:51 needed for thread 1 ORA-00289: suggestion: D: /BACKUPDB/ARCHIVE/BACKUPT001S00010.ARC ORA-00280: change 484453 For thread 1 is in sequence # 10 ora-00278: log file 'd: /backupdb/archive/backupt001s00009.arc' no longer needed for this recovery ORA-00279: Change 484508 generated at 10/21/2002 00:38:40 needed for thread 1 ORA-00289: suggestion: D: /BACKUPDB/ARCHIVE/BACKUPT001S00011.ARC ORA-00280: change 484508 for thread 1 is in sequence # 11 ORA-00278: log file 'D: / BACKUPDB / ARCHIVE / BACKUPT001S00010. Arc 'No Longer Needed for this Recovery Complete. SQL> Open Database SQL> ALTER DATABASE Open; Database Altered. SQL> Conn Lunar / Lunar Connected. SQL> Select * from test1; a ------ ---- 1 2 3 4 5 6 7 8 9 10 11 A ---------- 12 12 ROWS SEL ECTED. SQL> Description: 1. Copy all control files and data files (excluding REDO) 2. Mount database, follow the prompts to rebuild the password file 3. At this time, trying to fully recover the database is unsuccessful 4. Backup with to TRACE Control file 5. Find and edit the control file 6. Reconstruction Control File 7. Shutdown Immediate, then resume the database 8. Fully recover Database 9. Open the database http://www.cnoug.org/viewthread.php?tid=93&hlight= % 2blunar