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

zhaozj2021-02-16  95

Preparation If the data is not lost, it should be restored to INSERT INTO TEST1 VALUES (14); because 14 is Commit in REDO, 15 is the SQL> Conn Lunar / Lunar Connected. SQL> Select * from test1 ; A ---------- 1 2 3 4 5 6 7 8 9 10 11 A ---------- 12 13 13 Rows SELECTED. SQL> INSERT INTO TEST1 VALUES (14); 1 row created; commit completed; SQL> INSERT INTO TEST1 VALUES (15); 1 row created. Copy the hot standby control file and data files Copy Mount 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 ORA-01991: invalid password file 'd: /oracle1/ora81/DATABASE/PWDbackup.ORA' When prompted to rebuild the password file SQL> host Microsoft Windows 2000 [Version 5.00.2195] (C) Copyright 1985-2000 Microsoft Corp. E: /> DEL D: / ORACLE1 / ORA8 1 / Database / PWDBACKUP.ORA E: /> ORACLE1/ora81/Database/pwdbackup.ora password = Oracle Entries = 10 E: /> EXIT Attempts to recover the database (now the restore is not possible) SQL> recover database; ORA-00283: recovery session canceled due to errors ORA-01610: recovery using the BACKUP CONTROLFILE option must be done SQL> recover database using BACKUP CONTROLFILE; ORA-00279: change 424123 generated at 10/20/2002 20:44 : 12 Needed for Thread 1 Specify Log: { = SUGGESTED | FileName | Auto | Cancel} Auto ORA-00266: Name of Archived Log File Needed SQL> Recover Database Until Cancel Using Backup ControlFile;

ORA-00279: Change 424123 Generated AT 10/20/2002 20:44:12 Needed for Thread 1 Specify Log: { = SuggeSted ​​| FileName | Auto | Cancel} Auto ORA-00266: Name of ArchiveD log file needed ORA -01547: warning: rECOVER succeeded but OPEN RESETLOGS would get error below ORA-01152: file 1 was not restored from a sufficiently old backup ORA-01110: data file 1: 'D: /BACKUPDB/SYSTEM01.DBF' such recovery is visible Can't try to open the database (now open is not possible) SQL> ALTABASE OPEN; ALTER DATABASE OPEN * ERROR AT LINE 1: ORA-01589: Must Use ResetLogs or NoresetLogs Option for Database Open SQL> ALTER DATABASE OPEN RESETLOGS; ALTER DATABASE Open resetlogs * error at line 1: ORA-01152: FILE 1 WAS NOT RESTORED FROM A SUFFICIENTLY OLD BACKOP ORA-01110: Data file 1: D: /backupdb/system01.dbf 'It is now open Now is a re-Mount database SQL > Shutdown Immediate; ORA-01109: Database NOT OPEN DATABASE DISMOUNTED. 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 backup control file SQL> alter database backup controlfile to trace; Database altered SQL> shutdown immediate ORA-01109:... Database not open Database dismounted ORACLE instance shut down found that the control file and edit it 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 : / Onupupdb/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 files, and automatically fully recover the database 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 / ORA02020. sql ORA-01081: can not start already-running ORACLE - shut it down first Control file created ORA-00283:... recovery session canceled due to errors ORA-00264: no recovery required System altered Database altered SQL> verify recovery: fully Restore SQL> Conn Lunar / Lunar ConnECTED. SQL> SELECT * from test1 2 Where a> 10; A ---------- 11 12 13 14 SQL> Description: 1. Copy the hot standby control file and data file 2. Mount Database 3. According to the prompt, rebuild the password file 4. Try to recover the database (now the recovery is not possible), these three You cannot recover the database: Recover Database; Recover Database Unsing Backup ControlFile; Recover Database Until Cancel Using Backup ControlFile; 5. Try to open the database (now open is not possible), such as, these two, you can't open the database ALTER DATABASE OPEN ALTER DATABASE OPEN RESETLOGS; 6. Re-Mount Database 7. Backup Control File 8. Find that control file, and edit it 9. Reconstruction control files, and automatically recover the database at http://www.cnoug.org/viewthread.php? TID = 92 & highlight =% 2blunar

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

New Post(0)