SHUTDOWN ABORT restores all data files (excluding Control and Redo)

zhaozj2021-02-16  90

Recovery with hot-standby data file (copy the hot-standing data file back, excluding Control and Redo) SQL> CONNNAL Connected. SQL> Shutdown Abort Oracle Instance Shut Down. SQL> Copy all hot-standing data files (complete !. successful recovery) mount the 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 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 1 Specify sequence # 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 / Archive / 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: suggestion: 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 Log applied Media recovery complete open the database SQL> alter database open; Database altered the results of verification recovery: complete recovery SQL> conn lunar / lunar Connected SQL> select * from test1; A ----. ------ 1 2 SQL> Completely recover successfully! Description: 1. Copy all hot-standing data files over 2. Mount database 3. Fully recover database 4. Open the database http://www.cnoug.org/viewthread.php?tid=88&highlight=+lunar

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

New Post(0)