ORACLE 恢复中SCN的应用

检查数据库的备份
RMAN>LIST BACKUP OF DATABASE;
FULL  SCN=26905728480

检查归档日志的备份
RMAN>LIST BACKUP OF ARCHIVELOG ALL;
635(26905725274)-->638(26928633424)

本地的归档日志文件列表为: 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:\oracle\product\10.2.0\flash_recovery_area\ORCL\AUTOBACKUP\2006_09_08\O1_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';