oracle数据库无法查询,【案例】Oracle报错ORA-01194 ORA-01110 由于数据库SCN不一致导致无法启动...

天萃荷净

使用_allow_resetlogs_corruption打开无归档日志rman备份库，运维DBA反映服务器宕机后，开启数据库报错ORA-01194 ORA-01110，分析原因为Oracle SCN不一致导致数据库无法启动，使用_allow_resetlogs_corruption打开数据库

1.rman还原恢复操作

--还原数据库

RMAN> restore database;

--恢复数据库

RMAN> recover database;

Starting recover at 2012-03-08 21:20:45

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=65 device type=DISK

starting media recovery

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of recover command at 03/08/2012 21:20:47

RMAN-06053: unable to perform media recovery because of missing log

RMAN-06025: no backup of archived log for thread 1 with sequence 2936 and starting SCN of 25991695 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 2935 and starting SCN of 25