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: {
ORA-00279: Change 424123 Generated AT 10/20/2002 20:44:12 Needed for Thread 1 Specify 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