ORACLE
-
编辑 删除
ORACLE 恢复中SCN的应用
检查数据库的备份RMAN>LIST BACKUP OF DATABASE;FULL SCN=26905728480检查归档日志的备份RMAN>LIST BACKUP OF ARCHIVELOG ALL;635(26905725274)-->638(26928633424)[@more@]本地的归档日志文件列表为: 639---763 ,出问题后765--770当前数据库的SCN=35441074539CONTROL的备份RMAN>LIST BACKUP OF CONTROLFILE2006-09-08 的备份 SCN=26928866676开始恢复:1.恢复归档日志文件RMAN>RUN{ALLOCATE CHANNEL D1 TYPE DISK;SET ARCHIVELOG DESTINATION TO '/ORACLE/ORADATA/ARCHIVELOG';RESTORE ARCHIVELOG SEQUENCE BETWEEN 635 AN
