Switchover Activity.
[oraprd@prd2 STANDBY]$ dgmgrl
DGMGRL for Linux: Release 19.0.0.0.0 - Production on Mon May 31 18:21:07 2021
Version 19.8.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
Welcome to DGMGRL, type "help" for information.
DGMGRL> connect sys/abc#123@lapdrdb
Connected to "LAPDRDB"
Connected as SYSDBA.
DGMGRL> show configuration;
Configuration - NewDR
Protection Mode: MaxAvailability
Members:
LAPDRDB - Primary database
lapprimdb - Physical standby database
Fast-Start Failover: Disabled
Configuration Status:
SUCCESS (status updated 33 seconds ago)
DGMGRL>
DGMGRL for Linux: Release 19.0.0.0.0 - Production on Mon May 31 18:21:07 2021
Version 19.8.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
Welcome to DGMGRL, type "help" for information.
DGMGRL> connect sys/abc#123@lapdrdb
Connected to "LAPDRDB"
Connected as SYSDBA.
DGMGRL> show configuration;
Configuration - NewDR
Protection Mode: MaxAvailability
Members:
LAPDRDB - Primary database
lapprimdb - Physical standby database
Fast-Start Failover: Disabled
Configuration Status:
SUCCESS (status updated 33 seconds ago)
DGMGRL>
[oraprd@prd2 STANDBY]$ ./stat.sh
DESTINATION STATUS ERROR
---------------------------------------- --------- -----------------------------------------------------------------
/u001/PRD/arch VALID
lapprimdb VALID
PROCESS
---------
ARCH
DGRD
DGRD
ARCH
ARCH
ARCH
DGRD
LGWR
8 rows selected.
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
service_names string LAPDRDB.hana.com
NAME DATABASE_ROLE OPEN_MODE DB_UNIQUE_NAME
--------- ---------------- -------------------- ------------------------------
LAP PRIMARY READ WRITE LAPDRDB
[oraprd@prd2 STANDBY]$
[oraprd@prd1 STANDBY]$ cat validate_dg.sh
dgmgrl <<eof
connect sys/abc#123@lapdrdb
show configuration
validate database 'lapdrdb'
eof
[oraprd@prd1 STANDBY]$
dgmgrl <<eof
connect sys/abc#123@lapdrdb
show configuration
validate database 'lapdrdb'
eof
[oraprd@prd1 STANDBY]$
[oraprd@prd1 STANDBY]$ ./validate_dg.sh
DGMGRL for Linux: Release 19.0.0.0.0 - Production on Mon May 31 18:26:49 2021
Version 19.8.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
Welcome to DGMGRL, type "help" for information.
DGMGRL> Connected to "LAPDRDB"
Connected as SYSDBA.
DGMGRL>
Configuration - NewDR
Protection Mode: MaxAvailability
Members:
LAPDRDB - Primary database
lapprimdb - Physical standby database
Fast-Start Failover: Disabled
Configuration Status:
SUCCESS (status updated 3 second ago)
DGMGRL>
Database Role: Primary database
Ready for Switchover: Yes
Flashback Database Status:
LAPDRDB: Off
Managed by Clusterware:
LAPDRDB: NO
Validating static connect identifier for the primary database LAPDRDB...
The static connect identifier allows for a connection to database "LAPDRDB".
DGMGRL> DGMGRL> [oraprd@prd1 STANDBY]$
DGMGRL for Linux: Release 19.0.0.0.0 - Production on Mon May 31 18:26:49 2021
Version 19.8.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
Welcome to DGMGRL, type "help" for information.
DGMGRL> Connected to "LAPDRDB"
Connected as SYSDBA.
DGMGRL>
Configuration - NewDR
Protection Mode: MaxAvailability
Members:
LAPDRDB - Primary database
lapprimdb - Physical standby database
Fast-Start Failover: Disabled
Configuration Status:
SUCCESS (status updated 3 second ago)
DGMGRL>
Database Role: Primary database
Ready for Switchover: Yes
Flashback Database Status:
LAPDRDB: Off
Managed by Clusterware:
LAPDRDB: NO
Validating static connect identifier for the primary database LAPDRDB...
The static connect identifier allows for a connection to database "LAPDRDB".
DGMGRL> DGMGRL> [oraprd@prd1 STANDBY]$
[oraprd@prd1 STANDBY]$ cat ./validate_dg.sh
dgmgrl <<eof
connect sys/abc#123@lapdrdb
show configuration
validate database 'lapdrdb'
eof
look like we can do switchover,
[oraprd@prd2 STANDBY]$ dgmgrl /
DGMGRL for Linux: Release 19.0.0.0.0 - Production on Mon May 31 18:28:04 2021
Version 19.8.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
Welcome to DGMGRL, type "help" for information.
Connected to "LAPDRDB"
Connected as SYSDG.
DGMGRL> connect sys/abc#123@lapdrd
Connected to "LAPDRDB"
Connected as SYSDBA.
DGMGRL> show configuration;
Configuration - NewDR
Protection Mode: MaxAvailability
Members:
LAPDRDB - Primary database
lapprimdb - Physical standby database
Fast-Start Failover: Disabled
Configuration Status:
SUCCESS (status updated 35 seconds ago)
DGMGRL> switchover to lapprimdb;
Performing switchover NOW, please wait...
Operation requires a connection to database "lapprimdb"
Connecting ...
Connected to "LAPPRIMDB"
Connected as SYSDBA.
New primary database "lapprimdb" is opening...
Operation requires start up of instance "LAPDRDB" on database "LAPDRDB"
Starting instance "LAPDRDB"...
Connected to an idle instance.
ORACLE instance started.
Connected to "LAPDRDB"
Database mounted.
Connected to "LAPDRDB"
Switchover succeeded, new primary is "lapprimdb"
DGMGRL>
After Switchover.===>
DGMGRL> show configuration;
Configuration - NewDR
Protection Mode: MaxAvailability
Members:
lapprimdb - Primary database
LAPDRDB - Physical standby database
Warning: ORA-16854: apply lag could not be determined
Fast-Start Failover: Disabled
Configuration Status:
WARNING (status updated 38 seconds ago)
DGMGRL>
LAPPRIMDB Become Primary Database and LAPDRDB become Standby Database.
******************************************************************
EOD
******************************************************************
No comments:
Post a Comment