[toc]
ORACLE RAC 到单机 DG Broker 配置与切换
环境信息
| IP 地址 | hostname | db_name | db_unique_name | 备注 | tnsnames.ora |
|---|---|---|---|---|---|
| 172.8.8.82 | 11g-node1 | rac11g | rac11g | RAC node1 | rac11g_RAC11GDG |
| 172.8.8.83 | 11g-node2 | rac11g | rac11g | RAC node2 | rac11g_RAC11GDG |
| 172.8.8.86 | rac11g-cluster | rac11g | \ | RAC scan IP | |
| 172.8.8…201 | dgbrok | rac11g | RAC11GDG | 单机IP | RAC11GDG_rac11g |
DG Broker 基础知识
ORACLE DG Broker 的前提
0、数据库版本10gr1 以上
1、Data Guard 搭建完成，数据在应用同步
2、_DGMGRL和_DGB监听服务
-
其中
_DGMGRL完整名称为：<db_unique_name>_DGMGRL.<db_domain>,需要静态注册。Note: Static “_DGMGRL” entries are no longer needed as of Oracle Database 12.1.0.2 in Oracle Data Guard Broker configurations that are managed by Oracle Restart, RAC On Node or RAC as the Broker will use the clusterware to restart an instance.
需要注意的是 _DGMGRL 在12.1.0.2 之后不是必须的。
-
其中
_DGB完整名称为：<db_unique_name>_DGB.<db_domain>，官方介绍 _DGB 会在DMON进程启动时候自动注册，也就是 dg_broker_start 设置为 true 时会自动启动并动态注册 _DGB 服务。When you start the Data Guard Broker (DMON)-Process on your Primary and Standby Database, it will start and register Services on the Local Listener:
<db_unique_name>_DGB.<db_domain>: This Service is used by the DMON-Processes to communicate between each other
3、DG_BROKER_START参数设置为TRUE，会启动 DMON进程
4、需要 spfile 启动数据库（基本可以忽略，生产库通常都是spfile启动
5、dg_broker_config_file1[2] 参数在 RAC 环境需要配置在共享文件系统比如 ASM
RAC 环境监听新增 _DGMGRL 静态注册
1.1 RAC node 1监听配置前的状态
[grid@11g-node1 ~]$ lsnrctl status LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 08-FEB-2023 06:07:17 Copyright (c) 1991, 2013, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production Start Date 06-DEC-2022 09:01:23 Uptime 63 days 21 hr. 5 min. 54 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/11.2.0.4/grid/network/admin/listener.ora Listener Log File /u01/app/11.2.0.4/grid/network/log/listener.log Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.8.8.84)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.8.8.82)(PORT=1521))) Services Summary... Service "+ASM" has 1 instance(s). Instance "+ASM1", status READY, has 1 handler(s) for this service... Service "rac11g" has 1 instance(s). Instance "rac11g1", status READY, has 1 handler(s) for this service... The command completed successfully复制
1.2 listener.ora 监听文件新增静态注册
[grid@11g-node1 ~]$ vi /u01/app/11.2.0.4/grid/network/admin/listener.ora复制
SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = rac11g_DGMGRL) (ORACLE_HOME = /u01/app/oracle/product/11.2.0.4/dbhome_1) (SID_NAME = rac11g1) ) )复制
注意：这里的 ORACLE_HOME 就是$ORACLE_HOME ，不是 GRID_HOME ，写$GRID_HOME 在切换的时候会报： ORA-01017: invalid username/password; logon denied
1.3 listener.ora监听文件完整信息
[grid@11g-node1 ~]$cat /u01/app/11.2.0.4/grid/network/admin/listener.ora LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))) # line added by Agent LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))) # line added by Agent ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON # line added by Agent ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent INBOUND_CONNECT_TIMEOUT_LISTENER=0 DIAG_ADR_ENABLED_LISTENER=OFF INBOUND_CONNECT_TIMEOUT_LISTENER_SCAN1=0 DIAG_ADR_ENABLED_LISTENER_SCAN1=OFF SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = rac11g_DGMGRL) (ORACLE_HOME = /u01/app/oracle/product/11.2.0.4/dbhome_1) (SID_NAME = rac11g1) ) )复制
1.4 reload 监听
[grid@11g-node2 ~]$ lsnrctl reload LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 08-FEB-2023 06:12:53 Copyright (c) 1991, 2013, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))) The command completed successfully [grid@11g-node2 ~]$ lsnrctl status wait a limite [grid@11g-node1 ~]$ lsnrctl status LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 08-FEB-2023 06:14:14 Copyright (c) 1991, 2013, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production Start Date 06-DEC-2022 09:01:23 Uptime 63 days 21 hr. 12 min. 50 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/11.2.0.4/grid/network/admin/listener.ora Listener Log File /u01/app/11.2.0.4/grid/network/log/listener.log Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.8.8.82)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.8.8.84)(PORT=1521))) Services Summary... Service "+ASM" has 1 instance(s). Instance "+ASM1", status READY, has 1 handler(s) for this service... Service "rac11g" has 1 instance(s). Instance "rac11g1", status READY, has 1 handler(s) for this service... Service "rac11g_DGMGRL" has 1 instance(s). Instance "rac11g1", status UNKNOWN, has 1 handler(s) for this service... The command completed successfully复制
1.5 _DGMGRL 服务确认
可以看到监听新增了 rac11g_DGMGRL 的 Service ，其status 为静态注册 （UNKNOWN），对应的Instance 是 rac11g1
1.6 RAC node 2监听配置
同样主库 RAC 的节点2也是如上操作，将 instance 修改为rac11g2
[grid@11g-node2 ~]$ lsnrctl status LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 08-FEB-2023 06:12:11 Copyright (c) 1991, 2013, Oracle. All rights reserved. LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))) # line added by Agent Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production Start Date 04-DEC-2022 19:28:20 Uptime 65 days 10 hr. 43 min. 51 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/11.2.0.4/grid/network/admin/listener.ora Listener Log File /u01/app/11.2.0.4/grid/network/log/listener.log Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.8.8.85)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.8.8.83)(PORT=1521))) Services Summary... Service "+ASM" has 1 instance(s). Instance "+ASM2", status READY, has 1 handler(s) for this service... Service "rac11g" has 1 instance(s). Instance "rac11g2", status READY, has 1 handler(s) for this service... The command completed successfully [grid@11g-node2 ~]$ vi /u01/app/11.2.0.4/grid/network/admin/listener.ora 新增如下内容 ------ SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = rac11g_DGMGRL) (ORACLE_HOME = /u01/app/oracle/product/11.2.0.4/dbhome_1) (SID_NAME = rac11g2) ) ) ------ reload 监听 [grid@11g-node2 ~]$ lsnrctl reload LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 08-FEB-2023 06:12:53 Copyright (c) 1991, 2013, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))) The command completed successfully [grid@11g-node2 ~]$ lsnrctl status Listener Parameter File /u01/app/11.2.0.4/grid/network/admin/listener.ora Listener Log File /u01/app/11.2.0.4/grid/network/log/listener.log Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.8.8.83)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.8.8.85)(PORT=1521))) Services Summary... Service "rac11g" has 1 instance(s). Instance "rac11g2", status READY, has 1 handler(s) for this service... Service "rac11g_DGMGRL" has 1 instance(s). Instance "rac11g2", status UNKNOWN, has 1 handler(s) for this service... The command completed successfully复制
1.7 RAC node 2监听确认
可以看到主库RAC的节点2 也是新增了rac11g_DGMGRL 的静态监听，对应的Instance是 rac11g2
注意：RAC的 静态监听每个节点写各自的实例名称即可，不需要写全部节点的 SID。
单机环境监听新增 _DGMGRL 静态注册
2.1 单机环境 listener.ora 修改前的状态
oracle@dgbrok:/home/oracle $lsnrctl status LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 08-FEB-2023 06:18:45 Copyright (c) 1991, 2013, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.8.8..201)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production Start Date 13-JAN-2023 21:33:47 Uptime 25 days 8 hr. 44 min. 58 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/oracle/product/11.2.0.4/dbhome_1/network/admin/listener.ora Listener Log File /u01/app/oracle/diag/tnslsnr/dgbrok/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.8.8..201)(PORT=1521))) Services Summary... Service "RAC11G" has 1 instance(s). Instance "RAC11GDG", status READY, has 1 handler(s) for this service... Service "RAC11GDG" has 2 instance(s). Instance "RAC11GDG", status UNKNOWN, has 1 handler(s) for this service... Instance "RAC11GDG", status READY, has 1 handler(s) for this service... The command completed successfully oracle@dgbrok:/home/oracle $vi /u01/app/oracle/product/11.2.0.4/dbhome_1/network/admin/listener.ora ---- old LISTENER= (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.8.8..201)(PORT = 1521)) ) ) SID_LIST_LISTENER= (SID_LIST = (SID_DESC = (SID_NAME = RAC11GDG) (ORACLE_HOME = /u01/app/oracle/product/11.2.0.4/dbhome_1) (GLOBAL_DBNAME = RAC11GDG) ) ) ---- LISTENER= (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = dgbrok)(PORT = 1521)) ) ) SID_LIST_LISTENER= (SID_LIST = (SID_DESC = (SID_NAME = RAC11GDG) (ORACLE_HOME = /u01/app/oracle/product/11.2.0.4/dbhome_1) (GLOBAL_DBNAME = RAC11GDG) ) (SID_DESC = (GLOBAL_DBNAME = RAC11GDG_DGMGRL) (ORACLE_HOME = /u01/app/oracle/product/11.2.0.4/dbhome_1) (SID_NAME = RAC11GDG) ) )复制
此处有了 RAC11GDG 静态注册了，是搭建DG 进行dup 的时候使用的，DG 搭建好之后，可以去掉，也可以新增一个 _DGMGRL的静态注册，本次操作是新增。
2.2reload 监听之后的信息确认
oracle@dgbrok:/home/oracle $lsnrctl status LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 08-FEB-2023 06:26:25 Copyright (c) 1991, 2013, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dgbrok)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production Start Date 08-FEB-2023 06:25:47 Uptime 0 days 0 hr. 0 min. 37 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/oracle/product/11.2.0.4/dbhome_1/network/admin/listener.ora Listener Log File /u01/app/oracle/diag/tnslsnr/dgbrok/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dgbrok)(PORT=1521))) Services Summary... Service "RAC11G" has 1 instance(s). Instance "RAC11GDG", status READY, has 1 handler(s) for this service... Service "RAC11GDG" has 2 instance(s). Instance "RAC11GDG", status UNKNOWN, has 1 handler(s) for this service... Instance "RAC11GDG", status READY, has 1 handler(s) for this service... Service "RAC11GDG_DGMGRL" has 1 instance(s). Instance "RAC11GDG", status UNKNOWN, has 1 handler(s) for this service... The command completed successfully复制
可以看到监听新增了RAC11GDG_DGMGRL 的 Service ，其 status 为静态注册 （UNKNOWN），对应的Instance 是 RAC11GDG
2.3 tnsnames.ora信息确认
三台主机的 tnsnames.ora信息都相同，具体如下：
[grid@11g-node2 admin]$ cat tnsnames.ora rac11g_RAC11GDG = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.8.8.84 )(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 172.8.8.85 )(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = rac11g) ) ) RAC11GDG_rac11g = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.8.8..201 )(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = RAC11GDG) ) )复制
配置 DG Broker
3.1 创建 ASM 文件夹
su - grid
[grid@11g-node1 ~]$ asmcmd
ASMCMD> mkdir +data/RAC11G/dgbroker
复制3.2 RAC 环境 修改 dg_broker_config_file1[2]
RAC 环境 修改 dg_broker_config_file1[2] 到 ASM
SQL> show parameter broker
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
dg_broker_config_file1 string /u01/app/oracle/product/11.2.0
.4/dbhome_1/dbs/dr1rac11g.dat
dg_broker_config_file2 string /u01/app/oracle/product/11.2.0
.4/dbhome_1/dbs/dr2rac11g.dat
dg_broker_start boolean TRUE
SQL> alter system set dg_broker_start=false scope=both sid='*';
SQL> System altered.
ALTER SYSTEM SET DG_BROKER_CONFIG_FILE1='+data/RAC11G/dgbroker/dgb_config1.ora' SCOPE=BOTH sid='*';
SQL> System altered.
ALTER SYSTEM SET DG_BROKER_CONFIG_FILE2='+data/RAC11G/dgbroker/dgb_config2.ora' SCOPE=BOTH sid='*';
SQL> System altered.
alter system set dg_broker_start=true scope=both sid='*';
SQL> System altered.
SQL> show parameter dg_broker
SQL>
NAME TYPE VALUE
------------------------------------ ------- ------------------------------
dg_broker_config_file1 string +data/RAC11G/dgbroker/dgb_config1.ora
dg_broker_config_file2 string +data/RAC11G/dgbroker/dgb_config2.ora
dg_broker_start boolean TRUE
复制注意：RAC环境 dg_broker_config_file1|[2] 参数必须放到共享文件系统里。否则会报ORA-16532
oracle@11g-node1:/home/oracle $oerr ORA 16532 16532, 00000, "Data Guard broker configuration does not exist" // *Cause: A broker operation was requested that required a broker // configuration to already be created. // *Action: Create a Data Guard broker configuration prior to performing // other broker operations. If only one instance of a RAC // database is reporting this error, ensure that the // DG_BROKER_CONFIG_FILE[1|2] initialization parameters are // set to file locations that are shared by all instances of // the RAC database.复制
3.3 配置 DG Broker
-
登录
dgmgrloracle@11g-node1:/home/oracle $ dgmgrl sys/password@rac11g_RAC11GDG DGMGRL for Linux: Version 11.2.0.4.0 - 64bit Production Copyright (c) 2000, 2009, Oracle. All rights reserved. Welcome to DGMGRL, type "help" for information. Connected.复制 -
配置 DG Broker
DGMGRL> CREATE CONFIGURATION dgbrok AS PRIMARY DATABASE IS rac11g CONNECT IDENTIFIER IS rac11g_RAC11GDG;
Configuration "dgbrok" created with primary database "rac11g"
DGMGRL> ADD DATABASE RAC11GDG AS CONNECT IDENTIFIER IS RAC11GDG_rac11g MAINTAINED AS PHYSICAL;
Database "rac11gdg" added
DGMGRL> show configuration;
Configuration - dgbrok
Protection Mode: MaxPerformance
Databases:
rac11g - Primary database
rac11gdg - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
DISABLED
复制DGMGRL> enable configuration
Enabled.
DGMGRL> show configuration;
Configuration - dgbrok
Protection Mode: MaxPerformance
Databases:
rac11g - Primary database
rac11gdg - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
复制3.4 DG Broker 常用命令
show configuration;
show database rac11g;
show database rac11gdg;
show database verbose rac11g;
show database verbose rac11gdg;
DGMGRL> show database verbose rac11g;
Database - rac11g
Role: PRIMARY
Intended State: OFFLINE
Instance(s):
rac11g1
rac11g2
Properties:
DGConnectIdentifier = 'rac11g_rac11gdg'
ObserverConnectIdentifier = ''
LogXptMode = 'ASYNC'
DelayMins = '0'
Binding = 'optional'
MaxFailure = '0'
MaxConnections = '1'
ReopenSecs = '300'
NetTimeout = '30'
RedoCompression = 'DISABLE'
LogShipping = 'ON'
PreferredApplyInstance = ''
ApplyInstanceTimeout = '0'
ApplyParallel = 'AUTO'
StandbyFileManagement = 'AUTO'
ArchiveLagTarget = '600'
LogArchiveMaxProcesses = '4'
LogArchiveMinSucceedDest = '1'
DbFileNameConvert = '+DATA/rac11g/, /oradg/RAC11GDG/'
LogFileNameConvert = '+DATA/rac11g/, /oradg/RAC11GDG/'
FastStartFailoverTarget = ''
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
SendQEntries = '(monitor)'
LogXptStatus = '(monitor)'
RecvQEntries = '(monitor)'
ApplyLagThreshold = '0'
TransportLagThreshold = '0'
TransportDisconnectedThreshold = '30'
SidName(*)
StaticConnectIdentifier(*)
StandbyArchiveLocation(*)
AlternateLocation(*)
LogArchiveTrace(*)
LogArchiveFormat(*)
TopWaitEvents(*)
(*) - Please check specific instance for the property value
Database Status:
DISABLED
DGMGRL> show database verbose rac11gdg
Database - rac11gdg
Role: PHYSICAL STANDBY
Intended State: OFFLINE
Transport Lag: (unknown)
Apply Lag: (unknown)
Apply Rate: (unknown)
Real Time Query: OFF
Instance(s):
RAC11GDG
Properties:
DGConnectIdentifier = 'rac11gdg_rac11g'
ObserverConnectIdentifier = ''
LogXptMode = 'ASYNC'
DelayMins = '0'
Binding = 'OPTIONAL'
MaxFailure = '0'
MaxConnections = '1'
ReopenSecs = '300'
NetTimeout = '30'
RedoCompression = 'DISABLE'
LogShipping = 'ON'
PreferredApplyInstance = ''
ApplyInstanceTimeout = '0'
ApplyParallel = 'AUTO'
StandbyFileManagement = 'AUTO'
ArchiveLagTarget = '600'
LogArchiveMaxProcesses = '4'
LogArchiveMinSucceedDest = '1'
DbFileNameConvert = ''
LogFileNameConvert = ''
FastStartFailoverTarget = ''
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
SendQEntries = '(monitor)'
LogXptStatus = '(monitor)'
RecvQEntries = '(monitor)'
ApplyLagThreshold = '0'
TransportLagThreshold = '0'
TransportDisconnectedThreshold = '30'
SidName = 'RAC11GDG'
StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dgbrok)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=RAC11GDG_DGMGRL)(INSTANCE_NAME=RAC11GDG)(SERVER=DEDICATED)))'
StandbyArchiveLocation = '/oradg'
AlternateLocation = ''
LogArchiveTrace = '0'
LogArchiveFormat = '%t_%s_%r.dbf'
TopWaitEvents = '(monitor)'
Database Status:
DISABLED
复制3.5 DG Broker 切换与回切
switchover to rac11gdg; switchover to rac11g;复制
- DG Broker 切换
DGMGRL> switchover to rac11gdg; Performing switchover NOW, please wait... Operation requires a connection to instance "RAC11GDG" on database "rac11gdg" Connecting to instance "RAC11GDG"... Connected. New primary database "rac11gdg" is opening... Operation requires startup of instance "rac11g1" on database "rac11g" Starting instance "rac11g1"... ORACLE instance started. Database mounted. Database opened. Switchover succeeded, new primary is "rac11gdg"复制
- DG Broker 回切
DGMGRL> switchover to rac11g; Performing switchover NOW, please wait... Operation requires a connection to instance "rac11g1" on database "rac11g" Connecting to instance "rac11g1"... Connected. New primary database "rac11g" is opening... Operation requires startup of instance "RAC11GDG" on database "rac11gdg" Starting instance "RAC11GDG"... ORACLE instance started. Database mounted. Database opened. Switchover succeeded, new primary is "rac11g"复制
在本次回切的过程中遇到了 ORA-12545: Connect failed because target host or object does not exist 详见下一篇水文。
DGMGRL> switchover to rac11g;
Performing switchover NOW, please wait...
Operation requires a connection to instance "rac11g1" on database "rac11g"
Connecting to instance "rac11g1"...
Connected.
New primary database "rac11g" is opening...
Operation requires startup of instance "RAC11GDG" on database "rac11gdg"
Starting instance "RAC11GDG"...
Unable to connect to database
ORA-12545: Connect failed because target host or object does not exist
Failed.
Warning: You are no longer connected to ORACLE.
Please complete the following steps to finish switchover:
start up instance "RAC11GDG" of database "rac11gdg"
复制最后修改时间：2023-02-09 17:46:04
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
评论
小蛋蛋
2年前
评论
0辛苦刘老师
2年前
点赞 评论
TA的专栏
ORACLE、MySQL、PostgreSQL对比
收录3篇内容
TDE
收录4篇内容
热门文章
DG Broker 遇到 ORA-12545: Connect failed because target host or object does not exist
2023-02-09 3022浏览
MySQL ERROR 1045 (28000): Access denied for user <user>@<hostname> 问题汇总
2024-03-21 2808浏览
MySQL 登录报 ERROR 1045 (28000) 错误的问题汇总
2023-04-10 2441浏览
ORACLE 12c 手动安装 Spatial 选件
2023-01-15 2312浏览
ORACLE 恢复 rm 的数据文件
2022-12-23 1793浏览
最新文章
ORACLE lsnrctl reload 1521 会发生什么
2024-11-08 54浏览
Centos 6 单机 ORACLE 11g 修改 hostname OEM 无法正常运行问题处理
2024-09-15 55浏览
ORACLE 19c using dbca to duplicate a Physical Standby database
2024-09-15 188浏览
ORACLE、MySQL、PostgreSQL 客户端 sqlplus,mysql,psql 常用命令对比（三）
2024-08-01 678浏览
MySQL ERROR 1045 (28000): Access denied for user <user>@<hostname> 问题汇总
2024-03-21 2808浏览
目录
