Shutdown Immedate, recover all data files (excluding Control and Redo)

zhaozj2021-02-16  112

(Copy the hot data file back, excluding Control and Redo) SQL> Conn Internal Connected. SQL> Shutdown Immediate; Database CLOSED. Database DISMOUNTED. ORACLETANCE 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 SQL> full recovery database SQL> recover database;. ORA -00279: Change 424112 20:40:52 needed for thread 1 ora-00289: suggestion: d: /backupdb/archive/backupt001s00001.arc ora-00280: Change 424112 for thread 1 is in sequern 1 specify log: { = suggested | filename | auto | ca ZEN} 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 / ar CHIVE / 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 SQL> to open the database SQL> alter database open; Database altered Verify recovery: Fully restored SQL> conn lunar / lunar Connected SQL> select * from test1; A -.. -------- 1 2 SQL> Fully recovery 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=87&highlight=+lunar

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

New Post(0)