DG db_unique_name不唯一导致错误
1、最后一套DG 搭建 手快一个参数复制时没有认真仔细检查导致错误
错误类型:DG 里面备库db_unique_name 和主库的db_unique_name 一样是dg1
错误表现： 主库发送不了日志到备库
主库错误日志：
ORA-16047: DGID mismatch between destination setting and target database
PING[ARC2]: Heartbeat failed to connect to standby 'dg2'. Error is 16047.
备库错误日志：
Errors in file /u01/diag/rdbms/dg1/dg2/trace/dg2_lgwr_9412.trc:
ORA-00313: open failed for members of log group 4 of thread 0
ORA-00312: online log 4 thread 0: '/u01/oradata/dg2/standby_redo04.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
解决办法:
修改备库的db_unique_name 为dg2
alter system set db_unique_name =dg2 scope=spfile;
重启DG
错误类型:DG 里面备库db_unique_name 和主库的db_unique_name 一样是dg1
错误表现： 主库发送不了日志到备库
主库错误日志：
ORA-16047: DGID mismatch between destination setting and target database
PING[ARC2]: Heartbeat failed to connect to standby 'dg2'. Error is 16047.
备库错误日志：
Errors in file /u01/diag/rdbms/dg1/dg2/trace/dg2_lgwr_9412.trc:
ORA-00313: open failed for members of log group 4 of thread 0
ORA-00312: online log 4 thread 0: '/u01/oradata/dg2/standby_redo04.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
解决办法:
修改备库的db_unique_name 为dg2
alter system set db_unique_name =dg2 scope=spfile;
重启DG
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/26764973/viewspace-1472503/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
ORACLE DG 11G 搭建
请登录后发表评论
登录
全部评论
最新文章
- mysql 5.7 新特性中在线in-place 修改字段的大小
- ORACLE 11G 静默安装soft db listener
- vsphere 虚拟机在线添加磁盘linux
- linux 缩减LV大小
- ORA-600:[kcbzwfcro_2] Reported in Alert.log (文档 ID 2085507.1)
- WRH$_ACTIVE_SESSION_HISTORY
- 索引重建的必要性与影响 (Doc ID 1525787.1)
- ORACLE 11g R2 RAC 11.2.0.2.12 PSU 安装升级
- List of Oracle Database Patch Set Updates (PSU)
- ORA-00245: control file backup operation failed
