檢查資料庫的備份
RMAN>LIST BACKUP OF DATABASE;
FULL SCN=26905728480

檢查歸檔日誌的備份
RMAN>LIST BACKUP OF ARCHIVELOG ALL;
635(26905725274)--&gt638(26928633424)

[@more@]

本地的歸檔日誌檔案列表為: 639---763 ,出問題後765--770

當前資料庫的SCN=35441074539

CONTROL的備份
RMAN>LIST BACKUP OF CONTROLFILE
2006-09-08 的備份 SCN=26928866676

開始恢復:

1.恢復歸檔日誌檔案
RMAN>RUN{
ALLOCATE CHANNEL D1 TYPE DISK;
SET ARCHIVELOG DESTINATION TO '/ORACLE/ORADATA/ARCHIVELOG';
RESTORE ARCHIVELOG SEQUENCE BETWEEN 635 AND 638;
RELEASE CHANNEL D1;}

2.恢復舊的控制檔案
SQL>STARTUP NOMOUNT;
RMAN> restore controlfile from 'Z:oracleproduct10.2.0flash_recovery_areaORCLAUTOBACKUP2006_09_08O1_MF_S_600573612_2J0QKFTK_.BKP';

3.恢復資料庫檔案
run{
allocate channel d1 type disk;
restore database;
release channel d1;} 15:00 開始的.

4.資料恢復
SQL>RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL
AUTO

SQL>ALTER DATABASE OPEN RESETLOGS;

5. 備份資料庫
RMAN>BACKUP FULL DAETABASE FORMAT 'E:/RMAN/DB_%U.BAK'

ORACLE 恢復中SCN的應用

相關文章