Oracle单实例ASM搭建DG_BROKER(Linux7.4_19C)

2024-06-03 22:48

本文主要是介绍Oracle单实例ASM搭建DG_BROKER(Linux7.4_19C),希望对大家解决编程问题提供一定的参考价值,需要的开发者们随着小编来一起学习吧!

1、检测准备库是否能正常切换

主库:
alter database commit to switchover to physical standby with session shutdown;备库:
alter database commit to switchover to primary with session shutdown;
alter database open;主库:
startup;

2、确保主备库都是spfile启动

主库:
SYS@dgpri>show parameter spfile;NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
spfile				     string	 +DATA/ZZZDGPRI/parameterfile/spfile.276.1025373149**备库:**
SYS@dgphy>show parameter spfile;NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
spfile				     string	 +DATADG/ZZZDGPHY/parameterfile/spfile.258.1025389845

3、修改dg_broker_start参数为TRUE

主库:
SYS@dgpri>show parameter dg_broker;NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
dg_broker_config_file1		     string	 /u01/app/oracle/product/19.2.0.0.0/dbhome_1/dbs/dr1ZZZDGPRI.dat
dg_broker_config_file2		     string	 /u01/app/oracle/product/19.2.0.0.0/dbhome_1/dbs/dr2ZZZDGPRI.dat
dg_broker_start 		     boolean	 FALSESYS@dgpri>alter system set dg_broker_start = true;System altered.SYS@dgpri>host ps -ef | grep dmon
oracle   35590     1  0 18:39 ?        00:00:00 ora_dmon_dgpri
oracle   35639  9449  0 18:39 pts/2    00:00:00 /bin/bash -c ps -ef | grep dmon
oracle   35641 35639  0 18:39 pts/2    00:00:00 grep dmon备库:
SYS@dgphy>show parameter dg_broker;NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
dg_broker_config_file1		     string	 /u01/app/oracle/product/19.2.0.0.0/dbhome_1/dbs/dr1ZZZDGPHY.dat
dg_broker_config_file2		     string	 /u01/app/oracle/product/19.2.0.0.0/dbhome_1/dbs/dr2ZZZDGPHY.dat
dg_broker_start 		     boolean	 FALSESYS@dgphy>alter system set dg_broker_start = true;System altered.SYS@dgphy>host ps -ef | grep dmon
oracle   14377     1  0 18:39 ?        00:00:00 ora_dmon_dgphy
oracle   14410  8169  0 18:40 pts/2    00:00:00 /bin/bash -c ps -ef | grep dmon
oracle   14412 14410  0 18:40 pts/2    00:00:00 grep dmon

4、修改dg_broker参数文件位置

主库:
SYS@dgpri>alter system set dg_broker_config_file1 = '+DATA/dr1ZZZDGPRI.dat' scope = spfile;System altered.SYS@dgpri>alter system set dg_broker_config_file2 = '+DATA/dr2ZZZDGPRI.dat' scope = spfile;System altered.备库:
SYS@dgphy>alter system set dg_broker_config_file1 = '+DATADG/dr1ZZZDGPHY.dat' scope = spfile;System altered.SYS@dgphy>alter system set dg_broker_config_file2 = '+DATADG/dr2ZZZDGPHY.dat' scope = spfile;System altered.

重启主备库

5、配置DG_BROKER监听和TNS

可以使用默认监听,也可以创建一个非默认监听,这里使用默认监听。查看domain,如果存在则需要在服务后加上domain后缀
SYS@dgpri>show parameter domainNAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
db_domain			     string**配置LISTENER**主库:
[grid@kkk admin]$ cat listener.ora
#Backup file is  /u01/app/grid/crsdata/kkk/output/listener.ora.bak.kkk.grid line added by Agent
# listener.ora Network Configuration File: /u01/app/19.2.0.0.0/grid/network/admin/listener.ora
# Generated by Oracle configuration tools.LISTENER =(DESCRIPTION_LIST =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.59.16)(PORT = 1521))))SID_LIST_LISTENER=(SID_LIST=(SID_DESC=(ORACLE_HOME=/u01/app/oracle/product/19.2.0.0.0/dbhome_1)(GLOBAL_DBNAME=ZZZDGPRI)(SID_NAME=dgpri))(SID_DESC=(ORACLE_HOME=/u01/app/oracle/product/19.2.0.0.0/dbhome_1)(GLOBAL_DBNAME=ZZZDGPRI_DGMGRL)		#DG_BROKER专用服务名(SID_NAME=dgpri)))ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON		# line added by Agent
VALID_NODE_CHECKING_REGISTRATION_LISTENER=ON		# line added by Agent备库:[grid@hhh admin]$ cat listener.ora 
#Backup file is  /u01/app/grid/crsdata/hhh/output/listener.ora.bak.hhh.grid line added by Agent
# listener.ora Network Configuration File: /u01/app/19.2.0.0.0/grid/network/admin/listener.ora
# Generated by Oracle configuration tools.LISTENER =(DESCRIPTION_LIST =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.59.17)(PORT = 1521))))SID_LIST_LISTENER=(SID_LIST=(SID_DESC=(ORACLE_HOME=/u01/app/oracle/product/19.2.0.0.0/dbhome_1)(GLOBAL_DBNAME=ZZZDGPHY)(SID_NAME=dgphy))(SID_DESC=(ORACLE_HOME=/u01/app/oracle/product/19.2.0.0.0/dbhome_1)(GLOBAL_DBNAME=ZZZDGPHY_DGMGRL)(SID_NAME=dgphy)))ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON		# line added by Agent
VALID_NODE_CHECKING_REGISTRATION_LISTENER=ON		# line added by Agent添加后lsnrctl reload配置TNS主备库tnsnames.ora文件添加如下TNS_ZZZDGPRI_DGMGRL=(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.59.16)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = ZZZDGPRI_DGMGRL)))TNS_ZZZDGPHY_DGMGRL=(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.59.17)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = ZZZDGPHY_DGMGRL)))

6、配置DG_BROKER参数文件

DGMGRL> create configuration c1 as primary database is ZZZDGPRI connect identifier is TNS_ZZZDGPRI_DGMGRL
> ;**12c环境直接添加备库会报错,清空log_archive_dest_n**
DGMGRL> add database ZZZDGPHY as connect identifier is TNS_ZZZDGPHY_DGMGRL maintained as PHYSICAL;
Error: ORA-16698: member has a LOG_ARCHIVE_DEST_n parameter with SERVICE attribute set#清空主备库log_archive_dest_n参数DGMGRL> add database ZZZDGPHY as connect identifier is TNS_ZZZDGPHY_DGMGRL maintained as PHYSICAL;
Database "zzzdgphy" added启用参数文件
DGMGRL> enable configuration;
Enabled.
DGMGRL> show configuration verbose;Configuration - c1Protection Mode: MaxPerformanceMembers:zzzdgpri - Primary databasezzzdgphy - Physical standby database Properties:FastStartFailoverThreshold      = '30'OperationTimeout                = '30'TraceLevel                      = 'USER'FastStartFailoverLagLimit       = '30'CommunicationTimeout            = '180'ObserverReconnect               = '0'FastStartFailoverAutoReinstate  = 'TRUE'FastStartFailoverPmyShutdown    = 'TRUE'BystandersFollowRoleChange      = 'ALL'ObserverOverride                = 'FALSE'ExternalDestination1            = ''ExternalDestination2            = ''PrimaryLostWriteAction          = 'CONTINUE'ConfigurationWideServiceName    = 'ZZZ_CFG'Fast-Start Failover:  DisabledConfiguration Status:
SUCCESSDGMGRL> show database zzzdgpri verbose;
Error: ORA-16606: unable to find property "verbose"DGMGRL> show database verbose zzzdgpriDatabase - zzzdgpriRole:               PRIMARYIntended State:     TRANSPORT-ONInstance(s):dgpriProperties:DGConnectIdentifier             = 'tns_zzzdgpri_dgmgrl'ObserverConnectIdentifier       = ''FastStartFailoverTarget         = ''PreferredObserverHosts          = ''LogShipping                     = 'ON'RedoRoutes                      = ''LogXptMode                      = 'ASYNC'DelayMins                       = '0'Binding                         = 'optional'MaxFailure                      = '0'ReopenSecs                      = '300'NetTimeout                      = '30'RedoCompression                 = 'DISABLE'PreferredApplyInstance          = ''ApplyInstanceTimeout            = '0'ApplyLagThreshold               = '30'TransportLagThreshold           = '30'TransportDisconnectedThreshold  = '30'ApplyParallel                   = 'AUTO'ApplyInstances                  = '0'StandbyFileManagement           = ''ArchiveLagTarget                = '0'LogArchiveMaxProcesses          = '0'LogArchiveMinSucceedDest        = '0'DataGuardSyncLatency            = '0'LogArchiveTrace                 = '0'LogArchiveFormat                = ''DbFileNameConvert               = ''LogFileNameConvert              = ''ArchiveLocation                 = ''AlternateLocation               = ''StandbyArchiveLocation          = ''StandbyAlternateLocation        = ''InconsistentProperties          = '(monitor)'InconsistentLogXptProps         = '(monitor)'LogXptStatus                    = '(monitor)'SendQEntries                    = '(monitor)'RecvQEntries                    = '(monitor)'HostName                        = 'kkk'StaticConnectIdentifier         = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.59.16)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ZZZDGPRI_DGMGRL)(INSTANCE_NAME=dgpri)(SERVER=DEDICATED)))'TopWaitEvents                   = '(monitor)'SidName                         = '(monitor)'Log file locations:Alert log               : /u01/app/oracle/diag/rdbms/zzzdgpri/dgpri/trace/alert_dgpri.logData Guard Broker log   : /u01/app/oracle/diag/rdbms/zzzdgpri/dgpri/trace/drcdgpri.logDatabase Status:
SUCCESSDGMGRL> show database verbose zzzdgphyDatabase - zzzdgphyRole:               PHYSICAL STANDBYIntended State:     APPLY-ONTransport Lag:      0 seconds (computed 0 seconds ago)Apply Lag:          0 seconds (computed 0 seconds ago)Average Apply Rate: 30.00 KByte/sActive Apply Rate:  0 Byte/sMaximum Apply Rate: 0 Byte/sReal Time Query:    ONInstance(s):dgphyProperties:DGConnectIdentifier             = 'tns_zzzdgphy_dgmgrl'ObserverConnectIdentifier       = ''FastStartFailoverTarget         = ''PreferredObserverHosts          = ''LogShipping                     = 'ON'RedoRoutes                      = ''LogXptMode                      = 'ASYNC'DelayMins                       = '0'Binding                         = 'optional'MaxFailure                      = '0'ReopenSecs                      = '300'NetTimeout                      = '30'RedoCompression                 = 'DISABLE'PreferredApplyInstance          = ''ApplyInstanceTimeout            = '0'ApplyLagThreshold               = '30'TransportLagThreshold           = '30'TransportDisconnectedThreshold  = '30'ApplyParallel                   = 'AUTO'ApplyInstances                  = '0'StandbyFileManagement           = ''ArchiveLagTarget                = '0'LogArchiveMaxProcesses          = '0'LogArchiveMinSucceedDest        = '0'DataGuardSyncLatency            = '0'LogArchiveTrace                 = '0'LogArchiveFormat                = ''DbFileNameConvert               = ''LogFileNameConvert              = ''ArchiveLocation                 = ''AlternateLocation               = ''StandbyArchiveLocation          = ''StandbyAlternateLocation        = ''InconsistentProperties          = '(monitor)'InconsistentLogXptProps         = '(monitor)'LogXptStatus                    = '(monitor)'SendQEntries                    = '(monitor)'RecvQEntries                    = '(monitor)'HostName                        = 'hhh'StaticConnectIdentifier         = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.59.17)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ZZZDGPHY_DGMGRL)(INSTANCE_NAME=dgphy)(SERVER=DEDICATED)))'TopWaitEvents                   = '(monitor)'SidName                         = '(monitor)'Log file locations:Alert log               : /u01/app/oracle/diag/rdbms/zzzdgphy/dgphy/trace/alert_dgphy.logData Guard Broker log   : /u01/app/oracle/diag/rdbms/zzzdgphy/dgphy/trace/drcdgphy.logDatabase Status:
SUCCESS

7、switchover测试

DGMGRL> help switchover;Switches roles between a primary and standby databaseSyntax:SWITCHOVER TO <standby database name> [WAIT [<timeout in seconds>]];DGMGRL> switchover to ZZZDGPHY;
Performing switchover NOW, please wait...
Operation requires a connection to database "zzzdgphy"
Connecting ...
Connected to "ZZZDGPHY"
Connected as SYSDBA.
New primary database "zzzdgphy" is opening...
Oracle Clusterware is restarting database "zzzdgpri" ...
Connected to an idle instance.
Connected to an idle instance.
Connected to an idle instance.
Connected to an idle instance.
Connected to an idle instance.
Connected to an idle instance.
Connected to "ZZZDGPRI"
Connected to "ZZZDGPRI"
Switchover succeeded, new primary is "zzzdgphy"DGMGRL> show configuration;Configuration - c1Protection Mode: MaxPerformanceMembers:zzzdgphy - Primary databasezzzdgpri - Physical standby database Fast-Start Failover:  DisabledConfiguration Status:
SUCCESS   (status updated 88 seconds ago)DGMGRL> switchover to zzzdgpri;
Performing switchover NOW, please wait...
Operation requires a connection to database "zzzdgpri"
Connecting ...
Connected to "ZZZDGPRI"
Connected as SYSDBA.
New primary database "zzzdgpri" is opening...
Oracle Clusterware is restarting database "zzzdgphy" ...
Connected to an idle instance.
Connected to an idle instance.
Connected to an idle instance.
Connected to an idle instance.
Connected to an idle instance.
Connected to an idle instance.
Connected to "ZZZDGPHY"
Connected to "ZZZDGPHY"
Switchover succeeded, new primary is "zzzdgpri"
DGMGRL> show configuration;Configuration - c1Protection Mode: MaxPerformanceMembers:zzzdgpri - Primary databasezzzdgphy - Physical standby database Warning: ORA-16854: apply lag could not be determinedFast-Start Failover:  DisabledConfiguration Status:
WARNING   (status updated 8 seconds ago)DGMGRL> show configuration;Configuration - c1Protection Mode: MaxPerformanceMembers:zzzdgpri - Primary databasezzzdgphy - Physical standby database Warning: ORA-16854: apply lag could not be determinedFast-Start Failover:  DisabledConfiguration Status:
WARNING   (status updated 36 seconds ago)DGMGRL> show configuration;Configuration - c1Protection Mode: MaxPerformanceMembers:zzzdgpri - Primary databasezzzdgphy - Physical standby database Warning: ORA-16854: apply lag could not be determinedFast-Start Failover:  DisabledConfiguration Status:
WARNING   (status updated 44 seconds ago)DGMGRL> show configuration;Configuration - c1Protection Mode: MaxPerformanceMembers:zzzdgpri - Primary databasezzzdgphy - Physical standby database Fast-Start Failover:  DisabledConfiguration Status:
SUCCESS   (status updated 39 seconds ago)修改属性EDIT { RECOVERY_APPLIANCE | DATABASE | FAR_SYNC }<object name> SET PROPERTY <property name> = <value>;DGMGRL> edit database zzzdgpri set property StandbyFileManagement = 'AUTO';
Property "standbyfilemanagement" updated
DGMGRL> edit database zzzdgphy set property StandbyFileManagement = 'AUTO';
Connected to "ZZZDGPHY"
Property "standbyfilemanagement" updated主库:
SYS@dgpri>select name,db_unique_name,database_role,open_mode,switchover_status from v$database;NAME		DB_UNIQU DATABASE_ROLE	  OPEN_MODE	       SWITCHOVER_STATUS
--------------- -------- ---------------- -------------------- ------------------
ZZZ		ZZZDGPRI PRIMARY	  READ WRITE	       TO STANDBYSYS@dgpri>archive log list;
Database log mode	       Archive Mode
Automatic archival	       Enabled
Archive destination	       USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     57
Next log sequence to archive   59
Current log sequence	       59备库:
SYS@dgphy>select name,db_unique_name,database_role,open_mode,switchover_status from v$database;NAME		DB_UNIQU DATABASE_ROLE	  OPEN_MODE	       SWITCHOVER_STATUS
--------------- -------- ---------------- -------------------- ------------------
ZZZ		ZZZDGPHY PHYSICAL STANDBY READ ONLY WITH APPLY NOT ALLOWEDSYS@dgphy>select max(sequence#) from v$archived_log where name like '+FRA%' and applied in ('YES','IN-MEMORY');MAX(SEQUENCE#)
--------------58

8、开启FAILOVER


开启主备库闪回
主库:
YS@dgpri>select flashback_on from v$database;FLA
---
NOSYS@dgpri>alter database flashback on;Database altered.SYS@dgpri>select flashback_on from v$database;FLA
---
YES备库:SYS@dgphy>select flashback_on from v$database;FLA
---
NOSYS@dgphy>alter database flashback on;
alter database flashback on
*
ERROR at line 1:
ORA-01153: an incompatible media recovery is activeSYS@dgphy>alter database recover managed standby database cancel;Database altered.SYS@dgphy>alter database flashback on;Database altered.SYS@dgphy>select flashback_on from v$database;FLA
---
YESSYS@dgphy>alter database recover managed standby database using current logfile disconnect;Database altered.DGMGRL> enable fast_start failover;
Enabled in Potential Data Loss Mode.DGMGRL> show configuration verbose;Configuration - c1Protection Mode: MaxPerformanceMembers:zzzdgpri - Primary databasezzzdgphy - (*) Physical standby database (*) Fast-Start Failover targetProperties:FastStartFailoverThreshold      = '30'OperationTimeout                = '30'TraceLevel                      = 'USER'FastStartFailoverLagLimit       = '30'CommunicationTimeout            = '180'ObserverReconnect               = '0'FastStartFailoverAutoReinstate  = 'TRUE'FastStartFailoverPmyShutdown    = 'TRUE'BystandersFollowRoleChange      = 'ALL'ObserverOverride                = 'FALSE'ExternalDestination1            = ''ExternalDestination2            = ''PrimaryLostWriteAction          = 'CONTINUE'ConfigurationWideServiceName    = 'ZZZ_CFG'Fast-Start Failover: Enabled in Potential Data Loss ModeLag Limit:          30 secondsThreshold:          30 secondsActive Target:      zzzdgphyPotential Targets:  "zzzdgphy"zzzdgphy   validObserver:           kkkShutdown Primary:   TRUEAuto-reinstate:     TRUEObserver Reconnect: (none)Observer Override:  FALSEConfiguration Status:
SUCCESS开启observer[oracle@kkk ~]$ dgmgrl
DGMGRL for Linux: Release 19.0.0.0.0 - Production on Mon Jan 13 20:09:11 2020
Version 19.2.0.0.0Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.Welcome to DGMGRL, type "help" for information.
DGMGRL> help start;Starts the fast-start failover observerSyntax:START OBSERVER [FILE=<observer file>]; START OBSERVER [<observer name>] [FILE IS <observer file>] [LOGFILE IS <observer log file>] [TRACE_LEVEL IS { USER | SUPPORT }]; START OBSERVER [<observer name>] IN BACKGROUND [FILE IS <observer file>] [LOGFILE IS <observer log file>] CONNECT IDENTIFIER IS <connect identifier> [TRACE_LEVEL IS { USER | SUPPORT }]; START OBSERVING [<configuration group name>] [TRACE_LEVEL IS { USER | SUPPORT }];DGMGRL> start observer;
not logged on
Failed to start the observer.DGMGRL> conn sys/oracle@TNS_ZZZDGPRI_DGMGRL as sysdba;
Unrecognized command "conn", try "help"DGMGRL> connect sys/oracle@TNS_ZZZDGPRI_DGMGRL as sysdba;
Connected to "ZZZDGPRI"
Connected as SYSDBA.
DGMGRL> start observer;
[W000 2020-01-13T20:09:58.949+08:00] FSFO target standby is zzzdgphy
Observer 'kkk' started
[W000 2020-01-13T20:09:59.321+08:00] Observer trace level is set to USER
[W000 2020-01-13T20:09:59.321+08:00] Try to connect to the primary.
[W000 2020-01-13T20:09:59.321+08:00] Try to connect to the primary tns_zzzdgpri_dgmgrl.
[W000 2020-01-13T20:09:59.451+08:00] The standby zzzdgphy is ready to be a FSFO target
[W000 2020-01-13T20:10:00.451+08:00] Connection to the primary restored![W000 2020-01-13T20:10:02.451+08:00] Disconnecting from database tns_zzzdgpri_dgmgrl.

9、测试FAILOVER

主库:#主库关闭进行FAILOVER测试SYS@dgpri>shutdown abort;
ORACLE instance shut down.[W000 2020-01-13T20:13:17.939+08:00] Primary database cannot be reached.
[W000 2020-01-13T20:13:17.939+08:00] Fast-Start Failover threshold has not exceeded. Retry for the next 30 seconds
[W000 2020-01-13T20:13:18.940+08:00] Try to connect to the primary.
[W000 2020-01-13T20:13:20.116+08:00] Primary database cannot be reached.
[W000 2020-01-13T20:13:21.116+08:00] Try to connect to the primary.
[W000 2020-01-13T20:13:44.030+08:00] Primary database cannot be reached.
[W000 2020-01-13T20:13:44.030+08:00] Fast-Start Failover threshold has not exceeded. Retry for the next 3 seconds
[W000 2020-01-13T20:13:45.030+08:00] Try to connect to the primary.
[W000 2020-01-13T20:13:46.207+08:00] Primary database cannot be reached.
[W000 2020-01-13T20:13:46.207+08:00] Fast-Start Failover threshold has not exceeded. Retry for the next 1 second
[W000 2020-01-13T20:13:47.207+08:00] Try to connect to the primary.
[W000 2020-01-13T20:13:48.385+08:00] Primary database cannot be reached.
[W000 2020-01-13T20:13:48.385+08:00] Fast-Start Failover threshold has expired.
[W000 2020-01-13T20:13:48.385+08:00] Try to connect to the standby.
[W000 2020-01-13T20:13:48.385+08:00] Making a last connection attempt to primary database before proceeding with Fast-Start Failover.
[W000 2020-01-13T20:13:48.385+08:00] Check if the standby is ready for failover.
[S002 2020-01-13T20:13:48.402+08:00] Fast-Start Failover started...2020-01-13T20:13:48.402+08:00
Initiating Fast-Start Failover to database "zzzdgphy"...
[S002 2020-01-13T20:13:48.402+08:00] Initiating Fast-start Failover.
Performing failover NOW, please wait...
Failover succeeded, new primary is "zzzdgphy"
2020-01-13T20:14:36.545+08:00
[S002 2020-01-13T20:14:36.545+08:00] Fast-Start Failover finished...
[W000 2020-01-13T20:14:36.545+08:00] Failover succeeded. Restart pinging.
[W000 2020-01-13T20:14:36.565+08:00] Primary database has changed to zzzdgphy.
[W000 2020-01-13T20:14:36.573+08:00] Try to connect to the primary.
[W000 2020-01-13T20:14:36.573+08:00] Try to connect to the primary tns_zzzdgphy_dgmgrl.
[W000 2020-01-13T20:14:36.747+08:00] The standby zzzdgpri needs to be reinstated
[W000 2020-01-13T20:14:36.747+08:00] Try to connect to the new standby zzzdgpri.
[W000 2020-01-13T20:14:36.747+08:00] Connection to the primary restored!
ri.
[W000 2020-01-13T20:14:48.772+08:00] Connection to the new standby restored!#当主库修复好后,failover会自动就行修复[W000 2020-01-13T20:15:23.855+08:00] Connection to the new standby restored!
[W000 2020-01-13T20:15:56.921+08:00] Try to connect to the primary tns_zzzdgphy_dgmgrl.
[W000 2020-01-13T20:15:57.921+08:00] Connection to the primary restored!
[W000 2020-01-13T20:15:57.921+08:00] Wait for new primary to be ready to reinstate.
[W000 2020-01-13T20:15:58.927+08:00] New primary is now ready to reinstate.
[W000 2020-01-13T20:15:59.927+08:00] Issuing REINSTATE command.2020-01-13T20:15:59.927+08:00
Initiating reinstatement for database "zzzdgpri"...
Reinstating database "zzzdgpri", please wait...
[W000 2020-01-13T20:16:21.983+08:00] The standby zzzdgpri is ready to be a FSFO target
Reinstatement of database "zzzdgpri" succeeded
2020-01-13T20:17:09.802+08:00
[W000 2020-01-13T20:17:10.085+08:00] Successfully reinstated database zzzdgpri.DGMGRL> connect sys/oracle@TNS_ZZZDGPRI_DGMGRL as sysdba;
Connected to "ZZZDGPRI"
Connected as SYSDBA.
DGMGRL> disable fast_start failover;
Disabled.DGMGRL> show configuration verbose;Configuration - c1Protection Mode: MaxPerformanceMembers:zzzdgphy - Primary databasezzzdgpri - Physical standby database Properties:FastStartFailoverThreshold      = '30'OperationTimeout                = '30'TraceLevel                      = 'USER'FastStartFailoverLagLimit       = '30'CommunicationTimeout            = '180'ObserverReconnect               = '0'FastStartFailoverAutoReinstate  = 'TRUE'FastStartFailoverPmyShutdown    = 'TRUE'BystandersFollowRoleChange      = 'ALL'ObserverOverride                = 'FALSE'ExternalDestination1            = ''ExternalDestination2            = ''PrimaryLostWriteAction          = 'CONTINUE'ConfigurationWideServiceName    = 'ZZZ_CFG'Fast-Start Failover:  DisabledConfiguration Status:
SUCCESS

10、关闭FAILOVER

DGMGRL> connect sys/oracle@TNS_ZZZDGPRI_DGMGRL as sysdba;
Connected to "ZZZDGPRI"
Connected as SYSDBA.
DGMGRL> disable fast_start failover;
Disabled.DGMGRL> show configuration verbose;Configuration - c1Protection Mode: MaxPerformanceMembers:zzzdgphy - Primary databasezzzdgpri - Physical standby database Properties:FastStartFailoverThreshold      = '30'OperationTimeout                = '30'TraceLevel                      = 'USER'FastStartFailoverLagLimit       = '30'CommunicationTimeout            = '180'ObserverReconnect               = '0'FastStartFailoverAutoReinstate  = 'TRUE'FastStartFailoverPmyShutdown    = 'TRUE'BystandersFollowRoleChange      = 'ALL'ObserverOverride                = 'FALSE'ExternalDestination1            = ''ExternalDestination2            = ''PrimaryLostWriteAction          = 'CONTINUE'ConfigurationWideServiceName    = 'ZZZ_CFG'Fast-Start Failover:  DisabledConfiguration Status:
SUCCESS

这篇关于Oracle单实例ASM搭建DG_BROKER(Linux7.4_19C)的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!



http://www.chinasem.cn/article/1028338

相关文章

oracle DBMS_SQL.PARSE的使用方法和示例

《oracleDBMS_SQL.PARSE的使用方法和示例》DBMS_SQL是Oracle数据库中的一个强大包,用于动态构建和执行SQL语句,DBMS_SQL.PARSE过程解析SQL语句或PL/S... 目录语法示例注意事项DBMS_SQL 是 oracle 数据库中的一个强大包,它允许动态地构建和执行

前端原生js实现拖拽排课效果实例

《前端原生js实现拖拽排课效果实例》:本文主要介绍如何实现一个简单的课程表拖拽功能,通过HTML、CSS和JavaScript的配合,我们实现了课程项的拖拽、放置和显示功能,文中通过实例代码介绍的... 目录1. 效果展示2. 效果分析2.1 关键点2.2 实现方法3. 代码实现3.1 html部分3.2

PLsql Oracle 下载安装图文过程详解

《PLsqlOracle下载安装图文过程详解》PL/SQLDeveloper是一款用于开发Oracle数据库的集成开发环境,可以通过官网下载安装配置,并通过配置tnsnames.ora文件及环境变... 目录一、PL/SQL Developer 简介二、PL/SQL Developer 安装及配置详解1.下

本地搭建DeepSeek-R1、WebUI的完整过程及访问

《本地搭建DeepSeek-R1、WebUI的完整过程及访问》:本文主要介绍本地搭建DeepSeek-R1、WebUI的完整过程及访问的相关资料,DeepSeek-R1是一个开源的人工智能平台,主... 目录背景       搭建准备基础概念搭建过程访问对话测试总结背景       最近几年,人工智能技术

oracle如何连接登陆SYS账号

《oracle如何连接登陆SYS账号》在Navicat12中连接Oracle11g的SYS用户时,如果设置了新密码但连接失败,可能是因为需要以SYSDBA或SYSOPER角色连接,解决方法是确保在连接... 目录oracle连接登陆NmOtMSYS账号工具问题解决SYS用户总结oracle连接登陆SYS账号

Oracle数据库如何切换登录用户(system和sys)

《Oracle数据库如何切换登录用户(system和sys)》文章介绍了如何使用SQL*Plus工具登录Oracle数据库的system用户,包括打开登录入口、输入用户名和口令、以及切换到sys用户的... 目录打开登录入口登录system用户总结打开登录入口win+R打开运行对话框,输php入:sqlp

查询Oracle数据库表是否被锁的实现方式

《查询Oracle数据库表是否被锁的实现方式》本文介绍了查询Oracle数据库表是否被锁的方法,包括查询锁表的会话、人员信息,根据object_id查询表名,以及根据会话ID查询和停止本地进程,同时,... 目录查询oracle数据库表是否被锁1、查询锁表的会话、人员等信息2、根据 object_id查询被

mysqld_multi在Linux服务器上运行多个MySQL实例

《mysqld_multi在Linux服务器上运行多个MySQL实例》在Linux系统上使用mysqld_multi来启动和管理多个MySQL实例是一种常见的做法,这种方式允许你在同一台机器上运行多个... 目录1. 安装mysql2. 配置文件示例配置文件3. 创建数据目录4. 启动和管理实例启动所有实例

Java function函数式接口的使用方法与实例

《Javafunction函数式接口的使用方法与实例》:本文主要介绍Javafunction函数式接口的使用方法与实例,函数式接口如一支未完成的诗篇,用Lambda表达式作韵脚,将代码的机械美感... 目录引言-当代码遇见诗性一、函数式接口的生物学解构1.1 函数式接口的基因密码1.2 六大核心接口的形态学

5分钟获取deepseek api并搭建简易问答应用

《5分钟获取deepseekapi并搭建简易问答应用》本文主要介绍了5分钟获取deepseekapi并搭建简易问答应用,文中通过示例代码介绍的非常详细,对大家的学习或者工作具有一定的参考学习价值,需... 目录1、获取api2、获取base_url和chat_model3、配置模型参数方法一:终端中临时将加