1. 首页
  2. IT资讯

DG broker的配置和使用

配置方法 1、主备都在静态监听里新增DG broker的配置 主库为 (SID_DESC= (GLOBAL_DBNAME=PROD_DGMGRL) (ORACLE_HOME=/db/oracle/product/11.2.0/db_1/) (SID_NAME=PROD) ) 备库为 (SID_DESC= (GLOBAL_DBNAME=PROD_STD_DGMGRL) (ORACLE_HOME=/mnt/sdb1/u01/app/oracle/product/11.2.0.4/db) (SID_NAME=PROD_STD) ) 2、主备都设置参数 SQL> alter system set dg_broker_start=true; 使用方法 主备都可以执行 dgmgrl DGMGRL> connect sys/123456 DGMGRL> connect sys/123456@tnsname DGMGRL> help DGMGRL> help show Displays information about a configuration, database, or instance Syntax: SHOW CONFIGURATION [VERBOSE]; SHOW DATABASE [VERBOSE] <database name> [<property name>]; SHOW INSTANCE [VERBOSE] <instance name> [<property name>] [ON DATABASE <database name>]; SHOW FAST_START FAILOVER; DGMGRL> help create Creates a broker configuration Syntax: CREATE CONFIGURATION <configuration name> AS PRIMARY DATABASE IS <database name> CONNECT IDENTIFIER IS <connect identifier>; DGMGRL> help add Adds a standby database to the broker configuration Syntax: ADD DATABASE <database name> [AS CONNECT IDENTIFIER IS <connect identifier>] [MAINTAINED AS {PHYSICAL|LOGICAL}]; DGMGRL> help switchover Switches roles between a primary and standby database Syntax: SWITCHOVER TO <standby database name>; 以上database name其实为db_unique_name,connect identifier表示tnsname DGMGRL> SHOW CONFIGURATION; ORA-16532: Data Guard broker configuration does not exist Configuration details cannot be determined by DGMGRL DGMGRL> CREATE CONFIGURATION DG1 AS PRIMARY DATABASE IS PROD2 CONNECT IDENTIFIER IS PROD2; Configuration “dg1” created with primary database “prod2” DGMGRL> ADD DATABASE PROD2_STD AS CONNECT IDENTIFIER IS PROD2_STD MAINTAINED AS PHYSICAL; Database “prod2_std” added DGMGRL> SHOW CONFIGURATION; Configuration – dg1 Protection Mode: MaxPerformance Databases: prod2 – Primary database prod2_std – Physical standby database Fast-Start Failover: DISABLED Configuration Status: DISABLED DGMGRL> enable CONFIGURATION; Enabled. 一旦enable configuration,那么主库的log_archive_dest_2就有值了 DGMGRL> show CONFIGURATION VERBOSE; Configuration – dg1 Protection Mode: MaxPerformance Databases: prod2 – Primary database prod2_std – Physical standby database Properties: FastStartFailoverThreshold = ’30’ OperationTimeout = ’30’ FastStartFailoverLagLimit = ’30’ CommunicationTimeout = ‘180’ ObserverReconnect = ‘0’ FastStartFailoverAutoReinstate = ‘TRUE’ FastStartFailoverPmyShutdown = ‘TRUE’ BystandersFollowRoleChange = ‘ALL’ ObserverOverride = ‘FALSE’ ExternalDestination1 = ” ExternalDestination2 = ” PrimaryLostWriteAction = ‘CONTINUE’ Fast-Start Failover: DISABLED Configuration Status: SUCCESS

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29578568/viewspace-2147360/,如需转载,请注明出处,否则将追究法律责任。

主题测试文章,只做测试使用。发布者:布吉卡,转转请注明出处:http://www.cxybcw.com/195031.html

联系我们

13687733322

在线咨询:点击这里给我发消息

邮件:1877088071@qq.com

工作时间:周一至周五,9:30-18:30,节假日休息

QR code