您可以將可儲存資料庫實體結構的控制檔還原。還原之前,您必須先找到檔案。找到檔案時,請確定資料庫處於已開啟狀態。
請採取以下步驟:
SQL> SHOW PARAMETER CONTROL FILES;
SQL> STARTUP NOMOUNT;
SQL>shutdown immediate;
SQL> STARTUP MOUNT
SQL> RECOVER DATABASE USING BACKUP CONTROLFILE
SQL> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL
SQL>SELECT * FROM V$LOG;
SQL>SELECT * FROM V$LOGFILE;
ORA-00279: change 55636 generated at 24/06/2014 16:59:47 needed for thread 1
ORA-00289: suggestion e:\app\Administrator\flash_recovery_area\orcl\ARCHIVELOG\2014_06_24\ O1_MF_1_2_9TKXGGG2_.ARC
ORA-00280: change 55636 for thread 1 is in sequence #24
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
日誌已套用
媒體復原完成
SQL> ALTER DATABASE OPEN RESETLOGS;
已復原遺失的控制檔。
Copyright © 2014-2021, Arcserve. |
|