ORA-10458 ORA-01196
机房搬迁,测试环境直接关机,再次开机导致standby库报错如下:
操作系统均为centos6.5,是基于11.2.0.4的RAC TO DG
官方文档给出的解释:
ORA-10458: standby database requires recovery
Cause: A standby database was in a state requiring media recovery when an attempt was made to open the standby database.
Action: Perform the necessary recovery and open the standby database.
原因:强制关机导致日志记录的SCN与控制文件不符,不能完成checkpoint事件,需要进行介质恢复。
- 处理步骤:
–启动到mount状态
startup mount
–进行日志恢复
alter database recover managed standby database disconnect from session
–查看alert日志
当看到 in transit字样说明已经到最新日志了
Media Recovery Log /u01/app/arch/1_142_899302231.dbf
Media Recovery Waiting for thread 1 sequence 143 (in transit)
–取消日志恢复
alter database recover managed standby database cancel;
–打开数据库,并开启实时应用
alter database open;
alter database recover managed standby database using current logfile disconnect from session;
–查看是否实时应用,查看已经应用
set line 199
col dest_name for a50
select DEST_NAME , STATUS , RECOVERY_MODE from v$archive_dest_status;