暂无图片
oracle ADG 级联备库 Error 12154 received logging on to the standby 这个现象正常吗?
我来答
分享
吾喾
2022-06-28
oracle ADG 级联备库 Error 12154 received logging on to the standby 这个现象正常吗?

数据库版本 oracle 11.2.0.4

操作系统Redhat 7.6

主库rac两节点,备库rac两节点,级联备库单机(级联备库需要主库切归档级才能同步数据)

从备库rac搭建级联备库单机,启动mrp进程会报

Error 12154 received logging on to the standby

具体报错如下:这个现象正常吗?


Tue Jun 28 15:10:07 2022
alter database recover managed standby database using current logfile disconnect from session
Attempt to start background Managed Standby Recovery process (adg)
Tue Jun 28 15:10:07 2022
MRP0 started with pid=20, OS id=84545
MRP0: Background Managed Standby Recovery process started (adg)
Serial Media Recovery started
Managed Standby Recovery starting Real Time Apply
Waiting for all non-current ORLs to be archived...
All non-current ORLs have been archived.
Media Recovery Waiting for thread 2 sequence 19
Error 12154 received logging on to the standby
FAL[client, MRP0]: Error 12154 connecting to orcl,orcldg for fetching gap sequence
Completed: alter database recover managed standby database using current logfile disconnect from session


级联备库相关参数(log_archive_dest_2未设置):

*.fal_server='orcl,orcldg'
*.fal_client='adg'
*.log_archive_config='DG_CONFIG= (orcl,orcldg,adg)'
*.log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=adg'

我来答
添加附件
收藏
分享
问题补充
2条回答
默认
最新
刘贵宾

看看tnsnames.ora配置是否正确,主备能否连接成功

暂无图片 评论
暂无图片 有用 0
吾喾

配置都没问题,就是主库的tnsnames.ora没配级联备库的信息。

暂无图片 评论
暂无图片 有用 0
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏