ORACLE 恢复中SCN的应用

检查数据库的备份
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'

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/32980/viewspace-1034069/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/32980/viewspace-1034069/