[oracle@oradba04-observ11t ~]$ . oraenv
ORACLE_SID = [oracle] ? TEST
The Oracle base has been changed from /home/oracle to /applications/oracle/d19.3.0/oracle_base
[oracle@oradba04-observ11t ~]$
[oracle@oradba04-observ11t ~]$
[oracle@oradba04-observ11t ~]$ cd $ORACLE_HOME/network/admin
[oracle@oradba04-observ11t admin]$
[oracle@oradba04-observ11t admin]$
[oracle@oradba04-observ11t admin]$
[oracle@oradba04-observ11t admin]$ vi tnsnames.ora
[oracle@oradba04-observ11t admin]$
[oracle@oradba04-observ11t admin]$
[oracle@oradba04-observ11t admin]$
[oracle@oradba04-observ11t admin]$ tnsping SSDB
TNS Ping Utility for Linux: Version 19.0.0.0.0 - Production on 16-JAN-2025 17:27:55
Copyright (c) 1997, 2024, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.1.142)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = SSDB) (UR = A)))
OK (0 msec)
[oracle@oradba04-observ11t admin]$ tnsping SSDBDG
TNS Ping Utility for Linux: Version 19.0.0.0.0 - Production on 16-JAN-2025 17:28:03
Copyright (c) 1997, 2024, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.1.144)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = SSDBDG) (UR = A)))
OK (0 msec)
[oracle@oradba04-observ11t]$ dgmgrl sys/sys123@SSDB
DGMGRL for Linux: Release 19.0.0.0.0 - Production on Thu Jan 16 17:30:21 2025
Version 19.24.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
Welcome to DGMGRL, type "help" for information.
Connected to "SSDB"
Connected as SYSDBA.
DGMGRL>
DGMGRL>
DGMGRL> show configuration;
Configuration - DG_CONFIG
Protection Mode: MaxAvailability
Members:
SSDB - Primary database
ssdbdg - Physical standby database
Fast-Start Failover: Disabled
Configuration Status:
SUCCESS (status updated 40 seconds ago)
DGMGRL>
DGMGRL>
DGMGRL> show configuration verbose;
Configuration - DG_CONFIG
Protection Mode: MaxAvailability
Members:
SSDB - Primary database
ssdbdg - Physical standby database
Properties:
FastStartFailoverThreshold = '600'
OperationTimeout = '30'
TraceLevel = 'USER'
FastStartFailoverLagLimit = '30'
CommunicationTimeout = '180'
ObserverReconnect = '30'
FastStartFailoverLagGraceTime = '0'
FastStartFailoverAutoReinstate = 'TRUE'
FastStartFailoverPmyShutdown = 'TRUE'
BystandersFollowRoleChange = 'ALL'
ObserverOverride = 'FALSE'
ExternalDestination1 = ''
ExternalDestination2 = ''
PrimaryLostWriteAction = 'CONTINUE'
ConfigurationWideServiceName = 'SSDB_CFG'
FastStartFailoverLagType = 'APPLY'
Fast-Start Failover: Disabled
Configuration Status:
SUCCESS
[oracle@oradba04-observ11t admin]$
[oracle@oradba04-observ11t admin]$
[oracle@oradba04-observ11t admin]$ dgmgrl sys/sys123@SSDBDG
DGMGRL for Linux: Release 19.0.0.0.0 - Production on Thu Jan 16 17:31:35 2025
Version 19.24.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
Welcome to DGMGRL, type "help" for information.
Connected to "SSDBDG"
Connected as SYSDBA.
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> show configuration;
Configuration - DG_CONFIG
Protection Mode: MaxAvailability
Members:
SSDB - Primary database
ssdbdg - Physical standby database
Fast-Start Failover: Disabled
Configuration Status:
SUCCESS (status updated 42 seconds ago)
DGMGRL>[oracle@oradba04-observ11t admin]$
[oracle@oradba04-observ11t admin]$
[oracle@oradba04-observ11t admin]$ dgmgrl sys/sys123@SSDBDG
DGMGRL for Linux: Release 19.0.0.0.0 - Production on Thu Jan 16 17:31:35 2025
Version 19.24.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
Welcome to DGMGRL, type "help" for information.
Connected to "SSDBDG"
Connected as SYSDBA.
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> show configuration;
Configuration - DG_CONFIG
Protection Mode: MaxAvailability
Members:
SSDB - Primary database
ssdbdg - Physical standby database
Fast-Start Failover: Disabled
Configuration Status:
SUCCESS (status updated 42 seconds ago)
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> show configuration verbose;
Configuration - DG_CONFIG
Protection Mode: MaxAvailability
Members:
SSDB - Primary database
ssdbdg - Physical standby database
Properties:
FastStartFailoverThreshold = '600'
OperationTimeout = '30'
TraceLevel = 'USER'
FastStartFailoverLagLimit = '30'
CommunicationTimeout = '180'
ObserverReconnect = '30'
FastStartFailoverLagGraceTime = '0'
FastStartFailoverAutoReinstate = 'TRUE'
FastStartFailoverPmyShutdown = 'TRUE'
BystandersFollowRoleChange = 'ALL'
ObserverOverride = 'FALSE'
ExternalDestination1 = ''
ExternalDestination2 = ''
PrimaryLostWriteAction = 'CONTINUE'
ConfigurationWideServiceName = 'SSDB_CFG'
FastStartFailoverLagType = 'APPLY'
Fast-Start Failover: Disabled
Configuration Status:
SUCCESS
DGMGRL>
DGMGRL>
[oracle@oradba04-observ11t ~]$ cd $ORACLE_HOME/network/admin
[oracle@oradba04-observ11t admin]$
[oracle@oradba04-observ11t admin]$
[oracle@oradba04-observ11t admin]$ ls -lrt
total 12
drwxr-xr-x 2 oracle oinstall 4096 Jan 10 10:46 samples
-rw-r--r-- 1 oracle oinstall 1536 Jan 10 10:46 shrept.lst
-rw-r--r-- 1 oracle oinstall 388 Jan 16 17:27 tnsnames.ora
[oracle@oradba04-observ11t admin]$
[oracle@oradba04-observ11t admin]$
[oracle@oradba04-observ11t admin]$ vi tnsnames.ora
[oracle@oradba04-observ11t admin]$
[oracle@oradba04-observ11t admin]$
[oracle@oradba04-observ11t admin]$ tnsping SSDB.WORLD
TNS Ping Utility for Linux: Version 19.0.0.0.0 - Production on 16-JAN-2025 17:41:24
Copyright (c) 1997, 2024, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.1.142)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = SSDB) (UR=A)))
OK (0 msec)
[oracle@oradba04-observ11t admin]$ tnsping SSDBDG.WORLD
TNS Ping Utility for Linux: Version 19.0.0.0.0 - Production on 16-JAN-2025 17:41:33
Copyright (c) 1997, 2024, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.1.144)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = SSDBDG) (UR=A)))
OK (10 msec)
[oracle@oradba04-observ11t admin]$
[oracle@oradba04-observ11t admin]$
[oracle@oradba04-observ11t admin]$
[oracle@oradba04-observ11t admin]$ echo $TNS_ADMIN
/applications/oracle/d19.3.0/oracle_home/network/admin
[oracle@oradba04-observ11t admin]$
[oracle@oradba04-observ11t admin]$
[oracle@oradba04-observ11t admin]$
[oracle@oradba04-observ11t admin]$ dgmgrl
DGMGRL for Linux: Release 19.0.0.0.0 - Production on Thu Jan 16 17:42:22 2025
Version 19.24.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
Welcome to DGMGRL, type "help" for information.
DGMGRL>
DGMGRL>
DGMGRL> sys/sys123@SSDB.WORLD
Unrecognized command "sys", try "help"
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> connect sys/sys123@SSDB.WORLD
Connected to "SSDB"
Connected as SYSDBA.
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> show configuration;
Configuration - DG_CONFIG
Protection Mode: MaxAvailability
Members:
SSDB - Primary database
ssdbdg - Physical standby database
Fast-Start Failover: Disabled
Configuration Status:
SUCCESS (status updated 11 seconds ago)
DGMGRL>
DGMGRL>
DGMGRL> show configuration verbose;
Configuration - DG_CONFIG
Protection Mode: MaxAvailability
Members:
SSDB - Primary database
ssdbdg - Physical standby database
Properties:
FastStartFailoverThreshold = '600'
OperationTimeout = '30'
TraceLevel = 'USER'
FastStartFailoverLagLimit = '30'
CommunicationTimeout = '180'
ObserverReconnect = '30'
FastStartFailoverLagGraceTime = '0'
FastStartFailoverAutoReinstate = 'TRUE'
FastStartFailoverPmyShutdown = 'TRUE'
BystandersFollowRoleChange = 'ALL'
ObserverOverride = 'FALSE'
ExternalDestination1 = ''
ExternalDestination2 = ''
PrimaryLostWriteAction = 'CONTINUE'
ConfigurationWideServiceName = 'SSDB_CFG'
FastStartFailoverLagType = 'APPLY'
Fast-Start Failover: Disabled
Configuration Status:
SUCCESS
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> exit[oracle@oradba04-observ11t admin]$
[oracle@oradba04-observ11t admin]$ dgmgrl sys/sys123@SSDBDG.WORLD
DGMGRL for Linux: Release 19.0.0.0.0 - Production on Thu Jan 16 17:44:45 2025
Version 19.24.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
Welcome to DGMGRL, type "help" for information.
Connected to "SSDBDG"
Connected as SYSDBA.
DGMGRL>
DGMGRL>
DGMGRL> show configuration;
Configuration - DG_CONFIG
Protection Mode: MaxAvailability
Members:
SSDB - Primary database
ssdbdg - Physical standby database
Fast-Start Failover: Disabled
Configuration Status:
SUCCESS (status updated 46 seconds ago)
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> show configuration verbose;
Configuration - DG_CONFIG
Protection Mode: MaxAvailability
Members:
SSDB - Primary database
ssdbdg - Physical standby database
Properties:
FastStartFailoverThreshold = '600'
OperationTimeout = '30'
TraceLevel = 'USER'
FastStartFailoverLagLimit = '30'
CommunicationTimeout = '180'
ObserverReconnect = '30'
FastStartFailoverLagGraceTime = '0'
FastStartFailoverAutoReinstate = 'TRUE'
FastStartFailoverPmyShutdown = 'TRUE'
BystandersFollowRoleChange = 'ALL'
ObserverOverride = 'FALSE'
ExternalDestination1 = ''
ExternalDestination2 = ''
PrimaryLostWriteAction = 'CONTINUE'
ConfigurationWideServiceName = 'SSDB_CFG'
FastStartFailoverLagType = 'APPLY'
Fast-Start Failover: Disabled
Configuration Status:
SUCCESS
DGMGRL>
DGMGRL>
DGMGRL> show database SSDB ObserverConnectIdentifier;
ObserverConnectIdentifier = ''
DGMGRL>
DGMGRL>
DGMGRL> show database SSDBDG ObserverConnectIdentifier;
ObserverConnectIdentifier = ''
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> edit databae SSDB set property ObserverConnectIdentifier='SSDB.WORLd';
edit databae SSDB set property ObserverConnectIdentifier='SSDB.WORLd';
^
Syntax error before or at "databae"
DGMGRL>
DGMGRL>
DGMGRL> edit database SSDB set property ObserverConnectIdentifier='SSDB.WORLd';
Property "observerconnectidentifier" updated
DGMGRL>
DGMGRL>
DGMGRL> edit database SSDBDG set property ObserverConnectIdentifier='SSDB.WORLd';
Property "observerconnectidentifier" updated
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> exit
[oracle@oradba04-observ11t admin]$ dgmgrl sys/sys123@SSDBDG.WORLD
DGMGRL for Linux: Release 19.0.0.0.0 - Production on Thu Jan 16 17:50:09 2025
Version 19.24.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
Welcome to DGMGRL, type "help" for information.
Connected to "SSDBDG"
Connected as SYSDBA.
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> show configuration;
Configuration - DG_CONFIG
Protection Mode: MaxAvailability
Members:
SSDB - Primary database
ssdbdg - Physical standby database
Fast-Start Failover: Disabled
Configuration Status:
SUCCESS (status updated 27 seconds ago)
DGMGRL>
DGMGRL>
DGMGRL> show configuration verbose;
Configuration - DG_CONFIG
Protection Mode: MaxAvailability
Members:
SSDB - Primary database
ssdbdg - Physical standby database
Properties:
FastStartFailoverThreshold = '600'
OperationTimeout = '30'
TraceLevel = 'USER'
FastStartFailoverLagLimit = '30'
CommunicationTimeout = '180'
ObserverReconnect = '30'
FastStartFailoverLagGraceTime = '0'
FastStartFailoverAutoReinstate = 'TRUE'
FastStartFailoverPmyShutdown = 'TRUE'
BystandersFollowRoleChange = 'ALL'
ObserverOverride = 'FALSE'
ExternalDestination1 = ''
ExternalDestination2 = ''
PrimaryLostWriteAction = 'CONTINUE'
ConfigurationWideServiceName = 'SSDB_CFG'
FastStartFailoverLagType = 'APPLY'
Fast-Start Failover: Disabled
Configuration Status:
SUCCESS
DGMGRL>
DGMGRL>
DGMGRL> show fast_start failover;
Fast-Start Failover: Disabled
Protection Mode: MaxAvailability
Lag Limit: 30 seconds
Lag Type: APPLY
Threshold: 600 seconds
Active Target: (none)
Potential Targets: "ssdbdg"
ssdbdg valid
Observer: (none)
Shutdown Primary: TRUE
Auto-reinstate: TRUE
Observer Reconnect: 30 seconds
Observer Override: FALSE
Lag Grace Time: 0 seconds
Configurable Failover Conditions
Health Conditions:
Corrupted Controlfile YES
Corrupted Dictionary YES
Inaccessible Logfile NO
Stuck Archiver NO
Datafile Write Errors YES
Oracle Error Conditions:
(none)
DGMGRL>
DGMGRL>
DGMGRL> enable fast_start failover;
Enabled in Zero Data Loss Mode.
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> show fast_start failover;
Fast-Start Failover: Enabled in Zero Data Loss Mode
Protection Mode: MaxAvailability
Lag Limit: 30 seconds (not in use)
Lag Type: APPLY
Threshold: 600 seconds
Active Target: ssdbdg
Potential Targets: "ssdbdg"
ssdbdg valid
Observer: (none)
Shutdown Primary: TRUE
Auto-reinstate: TRUE
Observer Reconnect: 30 seconds
Observer Override: FALSE
Lag Grace Time: 0 seconds
Configurable Failover Conditions
Health Conditions:
Corrupted Controlfile YES
Corrupted Dictionary YES
Inaccessible Logfile NO
Stuck Archiver NO
Datafile Write Errors YES
Oracle Error Conditions:
(none)
DGMGRL>
DGMGRL>
DGMGRL> show configuration verbose;
Configuration - DG_CONFIG
Protection Mode: MaxAvailability
Members:
SSDB - Primary database
Warning: ORA-16819: fast-start failover observer not started
ssdbdg - (*) Physical standby database
Warning: ORA-16819: fast-start failover observer not started
(*) Fast-Start Failover target
Properties:
FastStartFailoverThreshold = '600'
OperationTimeout = '30'
TraceLevel = 'USER'
FastStartFailoverLagLimit = '30'
CommunicationTimeout = '180'
ObserverReconnect = '30'
FastStartFailoverLagGraceTime = '0'
FastStartFailoverAutoReinstate = 'TRUE'
FastStartFailoverPmyShutdown = 'TRUE'
BystandersFollowRoleChange = 'ALL'
ObserverOverride = 'FALSE'
ExternalDestination1 = ''
ExternalDestination2 = ''
PrimaryLostWriteAction = 'CONTINUE'
ConfigurationWideServiceName = 'SSDB_CFG'
FastStartFailoverLagType = 'APPLY'
Fast-Start Failover: Enabled in Zero Data Loss Mode
Lag Limit: 30 seconds (not in use)
Lag Type: APPLY
Threshold: 600 seconds
Active Target: ssdbdg
Potential Targets: "ssdbdg"
ssdbdg valid
Observer: (none)
Shutdown Primary: TRUE
Auto-reinstate: TRUE
Observer Reconnect: 30 seconds
Observer Override: FALSE
Lag Grace Time: 0 seconds
Configuration Status:
WARNING
DGMGRL>
DGMGRL>
DGMGRL> exit
[oracle@oradba04-observ11t admin]$ nohup dgmgrl sys/Welcome#2024@SSDBDG.WORLD "start observer file='/applications/oracle/d19.3.0/oracle_home/dbs/fsfo.dat'" -logfile /home/oracle/OBSERVER_LOGS/observer.log &
[1] 2221945
[oracle@oradba04-observ11t admin]$ nohup: ignoring input and appending output to 'nohup.out'
[1]+ Exit 255 nohup dgmgrl sys/Welcome#2024@SSDBDG.WORLD "start observer file='/applications/oracle/d19.3.0/oracle_home/dbs/fsfo.dat'" -logfile /home/oracle/OBSERVER_LOGS/observer.log
[oracle@oradba04-observ11t admin]$
[oracle@oradba04-observ11t admin]$
[oracle@oradba04-observ11t admin]$
[oracle@oradba04-observ11t admin]$
[oracle@oradba04-observ11t admin]$ cd
[oracle@oradba04-observ11t ~]$
[oracle@oradba04-observ11t ~]$
[oracle@oradba04-observ11t ~]$
[oracle@oradba04-observ11t ~]$
[oracle@oradba04-observ11t ~]$ ls -lrt
total 0
drwxr-xr-x 2 oracle oinstall 26 Jan 16 17:59 OBSERVER_LOGS
[oracle@oradba04-observ11t ~]$
[oracle@oradba04-observ11t ~]$
[oracle@oradba04-observ11t ~]$
[oracle@oradba04-observ11t ~]$ cd OBSERVER_LOGS
[oracle@oradba04-observ11t OBSERVER_LOGS]$
[oracle@oradba04-observ11t OBSERVER_LOGS]$
[oracle@oradba04-observ11t OBSERVER_LOGS]$ ls -lrt
total 4
-rw-r----- 1 oracle oinstall 278 Jan 16 17:59 observer.log
[oracle@oradba04-observ11t OBSERVER_LOGS]$
[oracle@oradba04-observ11t OBSERVER_LOGS]$
[oracle@oradba04-observ11t OBSERVER_LOGS]$ tail -200f observer.log
DGMGRL for Linux: Release 19.0.0.0.0 - Production on Thu Jan 16 17:59:00 2025
Version 19.24.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
Welcome to DGMGRL, type "help" for information.
ORA-01017: invalid username/password; logon denied
^C
[oracle@oradba04-observ11t OBSERVER_LOGS]$ rm -rf observer.log
[oracle@oradba04-observ11t OBSERVER_LOGS]$ nohup dgmgrl sys/sys123@SSDBDG.WORLD "start observer file='/applications/oracle/d19.3.0/oracle_home/dbs/fsfo.dat'" -logfile /home/oracle/OBSERVER_LOGS/observer.log &
[1] 2223598
[oracle@oradba04-observ11t OBSERVER_LOGS]$ nohup: ignoring input and appending output to 'nohup.out'
[oracle@oradba04-observ11t OBSERVER_LOGS]$
[oracle@oradba04-observ11t OBSERVER_LOGS]$
[oracle@oradba04-observ11t OBSERVER_LOGS]$
[oracle@oradba04-observ11t OBSERVER_LOGS]$ ls -lrt
total 12
-rw-r----- 1 oracle oinstall 269 Jan 16 18:00 observer.log
-rw------- 1 oracle oinstall 280 Jan 16 18:00 nohup.out
-rw-r----- 1 oracle oinstall 658 Jan 16 18:00 observer_oradba04-observ11t.log
[oracle@oradba04-observ11t OBSERVER_LOGS]$
[oracle@oradba04-observ11t OBSERVER_LOGS]$
[oracle@oradba04-observ11t OBSERVER_LOGS]$
[oracle@oradba04-observ11t OBSERVER_LOGS]$ tail -200f observer_oradba04-observ11t.log
Observer 'oradba04-observ11t' started
[W000 2025-01-16T18:00:18.609+01:00] Observer trace level is set to USER
[W000 2025-01-16T18:00:18.609+01:00] Try to connect to the primary.
[W000 2025-01-16T18:00:18.609+01:00] Try to connect to the primary SSDB.WORLD.
[W000 2025-01-16T18:00:18.617+01:00] The standby ssdbdg is ready to be a FSFO target
[W000 2025-01-16T18:00:18.617+01:00] Reconnect interval expired, connecting to primary database.
[W000 2025-01-16T18:00:19.617+01:00] Connection to the primary restored!
[W000 2025-01-16T18:00:19.617+01:00] Reconnecting to primary succeeded.
[W000 2025-01-16T18:00:21.618+01:00] Disconnecting from database SSDB.WORLD.
[W000 2025-01-16T18:00:49.669+01:00] Reconnect interval expired, connecting to primary database.
[W000 2025-01-16T18:00:50.669+01:00] Reconnecting to primary succeeded.
[W000 2025-01-16T18:01:20.721+01:00] Reconnect interval expired, connecting to primary database.
[W000 2025-01-16T18:01:21.722+01:00] Reconnecting to primary succeeded.
[W000 2025-01-16T18:01:51.764+01:00] Reconnect interval expired, connecting to primary database.
[W000 2025-01-16T18:01:52.768+01:00] Reconnecting to primary succeeded.
[W000 2025-01-16T18:02:22.809+01:00] Reconnect interval expired, connecting to primary database.
[W000 2025-01-16T18:02:23.810+01:00] Reconnecting to primary succeeded.
^C
[oracle@oradba04-observ11t OBSERVER_LOGS]$
[oracle@oradba04-observ11t OBSERVER_LOGS]$
[oracle@oradba04-observ11t OBSERVER_LOGS]$
[oracle@oradba04-observ11t OBSERVER_LOGS]$ dgmgrl sys/sys123@SSDBDG.WORLD
DGMGRL for Linux: Release 19.0.0.0.0 - Production on Thu Jan 16 18:03:12 2025
Version 19.24.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
Welcome to DGMGRL, type "help" for information.
Connected to "SSDBDG"
Connected as SYSDBA.
DGMGRL>
DGMGRL>
DGMGRL> show observer;
Configuration - DG_CONFIG
Primary: SSDB
Active Target: ssdbdg
Observer "oradba04-observ11t"(19.24.0.0.0) - Master
Host Name: oradba04-observ11t
Last Ping to Primary: 0 seconds ago
Last Ping to Target: 4 seconds ago
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> exit
[oracle@oradba04-observ11t OBSERVER_LOGS]$
[oracle@oradba04-observ11t OBSERVER_LOGS]$
[oracle@oradba04-observ11t OBSERVER_LOGS]$
[oracle@oradba04-observ11t OBSERVER_LOGS]$
[oracle@oradba04-observ11t OBSERVER_LOGS]$
[oracle@oradba04-observ11t OBSERVER_LOGS]$
[oracle@oradba04-observ11t OBSERVER_LOGS]$ ls -rlt
total 12
-rw-r----- 1 oracle oinstall 269 Jan 16 18:00 observer.log
-rw------- 1 oracle oinstall 280 Jan 16 18:00 nohup.out
-rw-r----- 1 oracle oinstall 2686 Jan 16 18:06 observer_oradba04-observ11t.log
[oracle@oradba04-observ11t OBSERVER_LOGS]$
[oracle@oradba04-observ11t OBSERVER_LOGS]$
[oracle@oradba04-observ11t OBSERVER_LOGS]$
[oracle@oradba04-observ11t OBSERVER_LOGS]$ tail -200f observer_oradba04-observ11t.log
Observer 'oradba04-observ11t' started
[W000 2025-01-16T18:00:18.609+01:00] Observer trace level is set to USER
[W000 2025-01-16T18:00:18.609+01:00] Try to connect to the primary.
[W000 2025-01-16T18:00:18.609+01:00] Try to connect to the primary SSDB.WORLD.
[W000 2025-01-16T18:00:18.617+01:00] The standby ssdbdg is ready to be a FSFO target
[W000 2025-01-16T18:00:18.617+01:00] Reconnect interval expired, connecting to primary database.
[W000 2025-01-16T18:00:19.617+01:00] Connection to the primary restored!
[W000 2025-01-16T18:00:19.617+01:00] Reconnecting to primary succeeded.
[W000 2025-01-16T18:00:21.618+01:00] Disconnecting from database SSDB.WORLD.
[W000 2025-01-16T18:00:49.669+01:00] Reconnect interval expired, connecting to primary database.
[W000 2025-01-16T18:00:50.669+01:00] Reconnecting to primary succeeded.
[W000 2025-01-16T18:01:20.721+01:00] Reconnect interval expired, connecting to primary database.
[W000 2025-01-16T18:01:21.722+01:00] Reconnecting to primary succeeded.
[W000 2025-01-16T18:01:51.764+01:00] Reconnect interval expired, connecting to primary database.
[W000 2025-01-16T18:01:52.768+01:00] Reconnecting to primary succeeded.
[W000 2025-01-16T18:02:22.809+01:00] Reconnect interval expired, connecting to primary database.
[W000 2025-01-16T18:02:23.810+01:00] Reconnecting to primary succeeded.
[W000 2025-01-16T18:02:53.852+01:00] Reconnect interval expired, connecting to primary database.
[W000 2025-01-16T18:02:54.853+01:00] Reconnecting to primary succeeded.
[W000 2025-01-16T18:03:24.896+01:00] Reconnect interval expired, connecting to primary database.
[W000 2025-01-16T18:03:25.899+01:00] Reconnecting to primary succeeded.
[W000 2025-01-16T18:03:55.945+01:00] Reconnect interval expired, connecting to primary database.
[W000 2025-01-16T18:03:56.945+01:00] Reconnecting to primary succeeded.
[W000 2025-01-16T18:04:26.987+01:00] Reconnect interval expired, connecting to primary database.
[W000 2025-01-16T18:04:27.987+01:00] Reconnecting to primary succeeded.
[W000 2025-01-16T18:04:57.029+01:00] Reconnect interval expired, connecting to primary database.
[W000 2025-01-16T18:04:58.033+01:00] Reconnecting to primary succeeded.
[W000 2025-01-16T18:05:28.077+01:00] Reconnect interval expired, connecting to primary database.
[W000 2025-01-16T18:05:29.078+01:00] Reconnecting to primary succeeded.
[W000 2025-01-16T18:05:59.118+01:00] Reconnect interval expired, connecting to primary database.
[W000 2025-01-16T18:06:00.119+01:00] Reconnecting to primary succeeded.
[W000 2025-01-16T18:06:30.160+01:00] Reconnect interval expired, connecting to primary database.
[W000 2025-01-16T18:06:31.166+01:00] Reconnecting to primary succeeded.
[W000 2025-01-16T18:07:01.206+01:00] Reconnect interval expired, connecting to primary database.
[W000 2025-01-16T18:07:02.207+01:00] Reconnecting to primary succeeded.
[W000 2025-01-16T18:07:32.251+01:00] Reconnect interval expired, connecting to primary database.
[W000 2025-01-16T18:07:33.251+01:00] Reconnecting to primary succeeded.
[W000 2025-01-16T18:08:03.294+01:00] Reconnect interval expired, connecting to primary database.
[W000 2025-01-16T18:08:04.298+01:00] Reconnecting to primary succeeded.
No comments:
Post a Comment