Oracle Alter Database Activate Standby Database失败显示ORA-01196: 文件 由于介质恢复会话失败而不一致

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线 ： 13764045638 QQ号:47079569 邮箱：service@parnassusdata.com

ORA-01196: 文件  由于介质恢复会话失败而不一致

 oerr ora 1196

01196, 00000, "file %s is inconsistent due to a failed media recovery session"

// *Cause:  The file was being recovered but the recovery did not terminate

//          normally. This left the file in an inconsistent state. No more

//          recovery was successfully completed on this file.

// *Action:Either apply more logs until the file is consistent or restore

//          the backup again and repeat recovery.

适用于：

Oracle Database – Enterprise Edition – 版本9.2.0.1 到11.2.0.3 [Release 9.2 到 11.2]
本文信息适用于任何平台。

目的

你想要激活你的物理备用数据库并在读/写模式下打开它，且不论在激活前备用数据库是否与主数据库同步。

如果你想要在激活前备用数据库与主数据库同步，请不要按照本文的步骤。请执行以下文档的故障切换步骤Failover Steps。

Oracle – Data Guard Concepts and Administration

Role Transitions

Failovers Involving a Physical Standby Database

故障排除步骤

— 症状 —

你想要激活你的物理备用数据库并在读/写模式下打开它，且不论在激活前备用数据库是否与主数据库同步。
你取消了Managed Recovery 且‘alter database activate standby database’命令失败显示以下错误：

SQL> ALTER DATABASE ACTIVATE STANDBY DATABASE;
ALTER DATABASE ACTIVATE STANDBY DATABASE
*
ERROR at line 1:
ORA-01196: file 1 is inconsistent due to a failed media recovery session
ORA-01110: data file 1: ‘+DRDAPSFTB/hrprddr/datafile/system.256.713982363’

— 原因 —

当Managed Recovery在恢复一个归档日志的过程中被取消。

— 解决方案 —

– 取消Managed Recovery

SQL>recover managed standby database cancel;

– 开始手动恢复

SQL> recover standby database;

 提供恢复在提示中请求的归档日志，
然后当提示再次出现时输入CANCEL。
例如，

ORA-00279: change 3066976646 generated at 07/08/2010 09:24:39 needed for thread
1
ORA-00289: suggestion : +DATA
ORA-00280: change 3066976646 for thread 1 is in sequence #48149
ORA-00278: log file ‘+DATA’ no longer needed for this recovery
ORA-00308: cannot open archived log ‘+DATA’
ORA-17503: ksfdopn:2 Failed to open file +DATA
ORA-15045: ASM file name ‘+DATA’ is not in reference form

Specify log: {=suggested | filename | AUTO | CANCEL}
CANCEL
Media recovery cancelled.

– 激活备用数据库

SQL> alter database activate standby database;

Database altered.

 – 关闭并启动数据库。

SQL>shutdown immediate;
SQL>startup;