Oracle Alter Database Activate Standby Database失败显示Ora-01196

 

 

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

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

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

 

适用于:

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;

Comment

*

沪ICP备14014813号-2

沪公网安备 31010802001379号