您可以還原整個資料庫 (所有表格區和控制檔)。還原之前,您必須先找到檔案。找到檔案時,請確定資料庫處於已開啟狀態。如果資料庫處於已開啟狀態,請使用 ALTER TABLESPACE. OFFLINE 陳述式可先將表格區或資料檔案設為離線狀態,再開始還原程序。
請採取以下步驟:
SQL> SELECT TABLESPACE_NAME, FILE_NAME from DBA_DATA_FILES;
SQL> SHOW PARAMETER CONTROL FILES;
SQL> STARTUP NOMOUNT;
SQL>shutdown immediate;
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;
SQL> ALTER PLUGGABLE DATABASE <PDB_NAME> OPEN;
整個資料庫已還原。
Copyright © 2014-2021, Arcserve. |
|