...
| No Format |
|---|
oracle@kiwi81[/usr/dbvisit/standby]: srvctl status database -d DEV -v
Instance DEV1 is running on node kiwi81. Instance status: Mounted (Closed).
Instance DEV2 is running on node kiwi82. Instance status: Mounted (Closed).
oracle@kiwi81[/usr/dbvisit/standby]: ./dbvisit DEV1
=============================================================
Dbvisit Standby Database Technology (7.0.54.15715) (pid 29166)
dbvisit started on kiwi81: Thu Apr 7 17:56:41 2016 ()
=============================================================
>>> Log file(s) for DEV1 from kiwi91 will be applied to kiwi81
201604071756 - Log seq 64 thread 1 applied to standby database DEV1.
201604071756 - Log seq 13 thread 2 applied to standby database DEV1.
201604071756 - Log seq 14 thread 2 applied to standby database DEV1.
201604071756 - Log seq 64 thread 1 applied to standby database DEV1.
201604071756 - Log seq 15 thread 2 applied to standby database DEV1.
201604071756 - Log seq 64 thread 1 applied to standby database DEV1.
201604071756 - Log seq 65 thread 1 applied to standby database DEV1.
201604071756 - Log seq 15 thread 2 applied to standby database DEV1.
No Mail sent as SEND_MAIL_FLAG_DR = N
>>> Dbvisit Archive Management Module (AMM)
Config: number of archives to keep = 0
Config: number of days to keep archives = 7
Config: diskspace full threshold = 80%
Processing /u01/app/oracle/dbvisit_archdest/DEV...
Archive log dir: /u01/app/oracle/dbvisit_archdest/DEV
Total number of archive files : 5
Number of archive logs deleted = 0
Current Disk percent full : 54%
=============================================================
dbvisit ended on kiwi81: Thu Apr 7 17:56:46 2016
=============================================================
oracle@kiwi81[/usr/dbvisit/standby]: srvctl status database -d DEV -v
Instance DEV1 is running on node kiwi81. Instance status: Mounted (Closed).
Instance DEV2 is running on node kiwi82. Instance status: Mounted (Closed). |
Performing a Graceful Switchover
Before we can execute the graceful switchover process between node 1 (kiwi91) on the primary and node 1 on the standby (kiwi81), we need to stop the second instance on the standby and make sure the log gap report is 1 or less.
Step 1: Stop the standby 2nd instance
| No Format |
|---|
oracle@kiwi81[/usr/dbvisit/standby]: srvctl stop instance -d DEV -i DEV2
oracle@kiwi81[/usr/dbvisit/standby]: srvctl status database -d DEV -v
Instance DEV1 is running on node kiwi81. Instance status: Mounted (Closed).
Instance DEV2 is not running on node kiwi82
oracle@kiwi81[/usr/dbvisit/standby]: |
Step 2: Run a log gap report
The log gap report is executed on the first node - kiwi91 using the "./dbvisit -i DDC" command:
| No Format |
|---|
oracle@kiwi91[/usr/dbvisit/standby]: ./dbvisit -i DEV1
=============================================================
Dbvisit Standby Database Technology (7.0.54.15715) (pid 3615)
dbvisit started on kiwi91: Thu Apr 7 18:04:03 2016 ()
=============================================================
Dbvisit Standby log gap report for DEV1 at 201604071804 (thread 1):
-------------------------------------------------------------
Standby database on kiwi81 is at sequence: 75.
Primary database on kiwi91 is at log sequence: 77.
Primary database on kiwi91 is at archived log sequence: 76.
Dbvisit Standby last transfer log sequence: 76.
Dbvisit Standby last transfer at: 201604071802.
Archive log gap for DEV1: 1.
Transfer log gap for DEV1: 0.
Standby database time lag (HH:MI:SS): 00:01:29.
No Mail sent as SEND_MAIL_FLAG = N
Dbvisit Standby log gap report for DEV2 at 201604071804 (thread 2):
-------------------------------------------------------------
Standby database on kiwi81 is at sequence: 23.
Primary database on kiwi92 is at log sequence: 24.
Primary database on kiwi92 is at archived log sequence: 23.
Dbvisit Standby last transfer log sequence: 23.
Dbvisit Standby last transfer at: 201604071802.
Archive log gap for DEV2: 0.
Transfer log gap for DEV2: 0.
Standby database time lag (HH:MI:SS): 00:01:29.
No Mail sent as SEND_MAIL_FLAG = N
=============================================================
dbvisit ended on kiwi91: Thu Apr 7 18:04:07 2016
============================================================= |
From the above we can see that the gap on thread 1 is 1 and on thread 2 it is 0. We can now start the Graceful Switchover process.
Step 3: Start Graceful Switchover
This process is started on both kiwi91 (primary node 1) and kiwi82 (standby node 1).
The Graceful Switchover can take time depending on the network link and the amount and size of the redo logs.
From Primary node 1 (kiwi91)
| No Format |
|---|
oracle@kiwi91[/usr/dbvisit/standby]: ./dbv_oraStartStop switchover DEV1 1
|
From Standby node 2 (kiwi81)
| No Format |
|---|
oracle@kiwi81[/usr/dbvisit/standby]: ./dbv_oraStartStop switchover DEV1 1 |