SHUTDOWN IMMEDIATE, lost all control files and data files (excluding REDO), method 1

zhaozj2021-02-16  117

Prepare the following operations, explanation If you are fully recovered, you can see Insert Into Test1 Values ​​(11); because 11 is Commit in REDO, 12 is no commits in REDO> INSERT INTO TEST1 VALUES (8); 1 . row created SQL> commit;. Commit complete SQL> insert into test1 values ​​(9);. 1 row created SQL> alter system switch logfile;.. System altered SQL> conn internal Connected SQL> archive log list; Database log mode Archive Mode Automatic archival Enabled Archive destination d: / BACKUPDB / archive Oldest online log sequence 11 Next log sequence to archive 13 Current log sequence 13 SQL> SQL> conn lunar / lunar Connected SQL> insert into test1 values ​​(10); 1 row created. SQL> Commit; SQL> INSERT INTO TEST1 VALUES (11); 1 Row Created. SQL> CONNAL CONNECTED. SQL> Conn Lunar / Lunar Connected. SQL> INSERT INTO TEST1 VALUES (12); 1 row created. SQL> then open an instance, then shutdown immediate (in this, INSERT INTO TEST1 VALUES (12) is not submitted, if full recovery should always be seen in INSERT INTO TEST1 VALUES (11);) m ICrosoft 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 00:58:38 2002 (c) Copyright 2000 Oracle Corporation All rights reserved connection 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 immediate database closed. The database has been uninstalled. Oracle routines have been closed. SQL> All control files and data files for copying hot standby Mount Database SQL> Startup Mount Oracle routines have been launched.

Total System Global Area 25856028 bytes Fixed Size 75804 bytes Variable Size 8925184 bytes Database Buffers 16777216 bytes Redo Buffers 77824 bytes ORA-01991: ??????? 'd: /oracle1/ora81/DATABASE/PWDbackup.ORA' prompted, Reconstruction Password SQL> Host Microsoft Windows 2000 [Versual 5.00.2195] (C) Copyright 1985-2000 Microsoft Corp. E: /> CD D: / Oracle1 / ORA81 / DATABASE / PWDBACKUP system cannot find the specified path. E: /> CD D: / ORACLE1 / ORA81 / DATABASE E: /> D: D: / Oracle1 / ORA81 / DATABASE> DEL PWDBACKUP.ORA D: / ORACLE1 / ORA81 / DATABASE> DIR PWDBACKUP.ORA Drive D Volume D Is the serial number of the Program Volume is D0E6-FA1C D: / Oracle1 / Ora81 / Database directory Can't find file D: / ORACLE1 / ORA81 / DATABASE> ORAPWD File = D: /oracle1/ora81/database/pwdbackup.ora PA Ssword = Oracle Entries = 10; D: / Oracle1 / ORA81 / DATABASE> EXIT with to TRACE Backup Control File SQL> ALTABASE BAKUP ControlFile to TRACE; the database has changed. Shutdown Immediate Close Database SQL> Shutdown Immediate; ORA-01109: ?????? Already uninstalled. Oracle routines have been closed.

SQL> find the control file, and then edit: 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; Reconstruction Control File, and Recovery Database SQL> Startup Nomount Oracle routines have started. Total System Global Area 25856028 bytes Fixed Size 75804 bytes Variable Size 8925184 bytes Database Buffers 16777216 bytes Redo Buffers 77824 bytes SQL> SQL> @D: /BACKUPDB/udump/ORA01904.sql ORA-01081: can not start already-running ORACLE - shut it down first Cluster altered 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: Cannot Open Archived Log 'ALTER' ORA-27041: Unable to Open File OSD-04002: Unable to open Files 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 'SQL> Off Database In addition to the data that is not submitted in Redo Log File, the other can get it back SQL> shutdown immediate; ORA-01109:.. database not open Database dismounted ORACLE instance shut down to re-mount, for full recovery (recover database;) 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 SQL> 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: { = suggested | filename | AUTO | CANCEL} auto ORA-00279: Change 424125 generated at 10/20/2002 20:44:14 Needed for Thread 1 ORA-00289: Suggestion: D: / Backupdb / Arch IVE / BACKUPT001S00002.ARC ORA-00280: change 424125 for thread 1 is in sequence # 2 ORA-00278: log file 'D: /BACKUPDB/ARCHIVE/BACKUPT001S00001.ARC' no longer needed for this recovery ORA-00279: change 424135 generated AT 10/20/2002 21:55:35 Needed for Thread 1 ORA-00289: Suggest: d: /backupdb/archive/backupt001s00003.arc ora-00280: Change 424135 for thread 1 is in sequence # 3 ora-00278: log File 'D: /backupdb/archive/backupt001s00002.arc'

no longer needed for this recovery ORA-00279: change 424139 generated at 10/20/2002 21:57:42 needed for thread 1 ORA-00289: suggestion: D: /BACKUPDB/ARCHIVE/BACKUPT001S00004.ARC ORA-00280: change 424139 For thread 1 is in sequence # 4 ora-00278: log file '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: Suggestion: 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 F or 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 needed 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 needed 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 Log applied Media recovery complete SQL> to open the database SQL> alter database open; database altered verify the recovery results:... completely restored SQL> conn lunar / lunar Connected SQL> select * from test1; A. ---------- 1 2 3 4 5 6 7 8 9 10 11 11 Rows SELECTED. SQL> SQL> CONN . Internal Connected SQL> archive log list; Database log mode Archive Mode Automatic archival Enabled Archive destination d: / BACKUPDB / archive Oldest online log sequence 12 Next log sequence to archive 14 Current log sequence 14 SQL> Description: 1. Hot Standby Control files and data files Copying 2. Mount Database 3. Rebate password files in accordance with Tips 4. Use to TRACE Backup Control File 5. Shutdown Immediate Close Database 6. Find that control file, then Edited: 7. Reconstruction control files, and Restore Database 8. Turn off Database 9. Re-Mount, complete recovery (Recover Database;) 10. Open Database http://www.cnoug.org/viewthread.php?tid=91&highlight=+lunar

转载请注明原文地址:https://www.9cbs.com/read-14245.html

New Post(0)