重庆思庄Oracle、Redhat认证学习论坛

 找回密码
 注册

QQ登录

只需一步,快速开始

搜索
查看: 3400|回复: 0
打印 上一主题 下一主题

[Oracle] DG备库复制完成后,open时提示ORA-10458,ORA-01196,ORA-01110的解决方式

[复制链接]
跳转到指定楼层
楼主
发表于 2021-1-24 16:53:16 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式

DG备库启动数据库到open状态报错:
ORA-10458: standby database requires recovery
ORA-01196: file 1 is inconsistent due to a failed media recovery session
ORA-01110: data file 1: '/u01/app/oracle/oradata/rong/system01.dbf'



原因:日志的scn跟控制文件不一致导致


处理步骤:
1、主库可以正常启动,备库启动到mount状态,启动监听,tnsping测试互通
2、备库启用日志应用
alter database recover managed standby database disconnect from session;

3、检查备库alert日志是否有如下应用日志的提示
Attempt to start background Managed Standby Recovery process (rong)
Tue Nov 18 15:33:13 2020
MRP0 started with pid=26, OS id=3933
MRP0: Background Managed Standby Recovery process started (rong)
started logmerger process
Tue Nov 18 15:33:13 2020
Managed Standby Recovery not using Real Time Apply
Parallel Media Recovery started with 24 slaves
Waiting for all non-current ORLs to be archived...
All non-current ORLs have been archived.
Media Recovery Log /u01/app/arch/1_137_899302231.dbf
Media Recovery Waiting for thread 1 sequence 138
Completed: alter database recover managed standby database disconnect from session
并会根据gap里差的日志一致应用到最新的归档

当看到 in transit字样说明已经到最新日志了
Media Recovery Log /u01/app/arch/1_142_899302231.dbf
Media Recovery Waiting for thread 1 sequence 143 (in transit)

4:停止应用日志
alter database recover managed standby database cancel

5:启动到open并再次应用日志
alter database open
alter database recover managed standby database using current logfile disconnect from session;

Mos上的参考文档
Open Standby Database Fails due to ORA-1110/ORA-1196/ORA-10458 (文档 ID 2047793.1)


分享到:  QQ好友和群QQ好友和群 QQ空间QQ空间 腾讯微博腾讯微博 腾讯朋友腾讯朋友
收藏收藏 支持支持 反对反对
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

本版积分规则

QQ|手机版|小黑屋|重庆思庄Oracle、Redhat认证学习论坛 ( 渝ICP备12004239号-4 )

GMT+8, 2024-11-27 04:21 , Processed in 0.090657 second(s), 21 queries .

重庆思庄学习中心论坛-重庆思庄科技有限公司论坛

© 2001-2020

快速回复 返回顶部 返回列表