Broker切换过程中原主库不能自启动
来源:互联网 发布:bf是什么软件 编辑:程序博客网 时间:2024/06/06 20:53
Oracle 11G 在配置好Data Guard使用Broker进行切换的过程中,出现报错,虽然不影响正常使用,但还是探其究竟,找到问题所在。
在Broker中进行一次切换后
DGMGRL> switchover to primary;
Performing switchover NOW, please wait...
New primary database "primary" is opening...
Operation requires shutdown of instance "king" on database "paris"
Shutting down instance "king"...
ORACLE instance shut down.
Operation requires startup of instance "king" on database "paris"
Starting instance "king"...
Unable to connect to database
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
Failed.
Warning: You are no longer connected to ORACLE.
Please complete the following steps to finish switchover:
start up instance "king" of database "paris"
切换完成之后,原主库需要手动startup,这种情况应该是可以自动启动的,并且自动应用日志,因为当前Broker Configuraion已经配好并且已经enable;
查询相关文档发现是因为GLOBAL_DBNAME=db_unique_name_DGMGRL.db_domain的格式,官方文档也有说明:
如果要启用DGMGRL在切换过程中可以重启实例,必须静态注册到本地监听文件中,格式如下:
To enable DGMGRL to restart instances during the course of broker operations, a service with a specific name must be statically registered with the local listener of each instance. The value for the GLOBAL_DBNAME attribute must be set to a concatenation of db_unique_name_DGMGRL. db_domain. For example, in the
LISTENER.ORA file:
LISTENER = (DESCRIPTION =
(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=host_name)
(PORT=port_num))))
SID_LIST_LISTENER=(SID_LIST=(SID_DESC=(SID_NAME=sid_name)
(GLOBAL_DBNAME=db_unique_name_DGMGRL. db_domain)
(ORACLE_HOME=oracle_home)))
重新静态注册过后,再次切换OK
DGMGRL> switchover to standby
Performing switchover NOW, please wait...
New primary database "standby" is opening...
Operation requires shutdown of instance "king" on database "primary"
Shutting down instance "king"...
ORACLE instance shut down.
Operation requires startup of instance "king" on database "primary"
Starting instance "king"...
ORACLE instance started.
Database mounted.
Database opened.
Switchover succeeded, new primary is "standby"
*****如果文件修改之后发现仍不能启动,检查/etc/hosts文件,observer,primary,standby的ip是否都被写进文件中*****
- Broker切换过程中原主库不能自启动
- 使用MHA发生切换后,将原主库加入集群并切换回最初状态
- Android中APP的自启动过程
- 利用RMAN备份standby还原主库
- Fedora9网卡不能自启动
- 解决使用Tornado过程中不能启动simulator的问题
- 解决使用Tornado过程中不能启动simulator的问题
- 解决使用Tornado过程中不能启动simulator的问题
- android应用开机自启动过程研究(迷惑中)
- redis自启动过程中出现的系统警告处理
- ActiveMQ 启动Broker
- apollo broker 启动流程
- usb_serial之repllog.exe不能自启动
- RAC集群数据库不能自启动问题
- 【翻译自mos文章】在db 12c 单机中不能注册ACFS为自动启动
- Activity manager service :activity 启动流程中process的切换过程
- ActiveMQ内置Broker启动方式
- springboot实现mqtt broker启动
- linux 用通配符排除指定字符结尾文件的一种方法
- array地址问题(为何指向赋值,仍然地址不同)
- 修改Bundle identify引起的问题
- spring事务管理
- Android APK反编译之apktool
- Broker切换过程中原主库不能自启动
- MFC对话框美化
- MAC电脑(os x)访问公司局域网里windows下的打印机(惠普打印机为例)
- webview
- Objective-C 类的扩展
- Ubuntu 安装SVN
- Qt Xml 添加节点
- cmd命令行修改c盘的安全级别
- iOS获取当前时间日期