Database Role: Physical standby database
Primary Database: dbuks_898_lhr
Ready for Switchover: Yes
Ready for Failover: Yes (Primary Running)
Managed by Clusterware:
dbuks_898_lhr: YES
dbuks_r2j_ams: YES
在主要資料庫上,執行命令來切換至待命資料庫。
請輸入:
switchover to DBUKS_R2J_AMS
執行結果應該和下列類似:
Performing switchover NOW, please wait...
Operation requires a connection to database "dbuks_r2j_ams"
Connecting ...
Connected to "dbuks_r2j_ams" Connected as SYSDBA.
New primary database "dbuks_r2j_ams" is opening...
Oracle Clusterware is restarting database "dbuks_898_lhr" ...
Connected to an idle instance. Connected to "dbuks_898_lhr"
Switchover succeeded, new primary is "dbuks_r2j_ams"
驗證資料庫 dbuks_r2j_ams:
validate database dbuks_r2j_ams
您應該會看見:
Database Role: Primary database
Ready for Switchover: Yes
Managed by Clusterware:
dbuks_r2j_ams: YES
驗證資料庫 dbuks_898_lhr:
DGMGRL> validate database dbuks_898_lhr
您應該會看見:
Database Role: Physical standby database
Primary Database: dbuks_r2j_ams
Ready for Switchover: Yes
Ready for Failover: Yes (Primary Running)
Managed by Clusterware:
dbuks_r2j_ams: YES
dbuks_898_lhr: YES
DGMGRL for Linux: Release 19.0.0.0.0 - Production on Mon Jul 10 06:59:41 2023
Version 19.19.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
Welcome to DGMGRL, type "help" for information.
Database Role: Primary database
Ready for Switchover: Yes
Managed by Clusterware:
dbuks_r2j_ams: YES
驗證資料庫 dbuks_898_lhr:
validate database dbuks_898_lhr;
您應該會看見:
Database Role: Physical standby database
Primary Database: dbuks_r2j_ams
Ready for Switchover: Yes
Ready for Failover: Yes (Primary Running)
Managed by Clusterware:
dbuks_r2j_ams: YES
dbuks_898_lhr: YES
從 dbuks_r2j_ams 切換至 dbuks_898_lhr:
switchover to dbuks_898_lhr ;
您應該會看見:
Performing switchover NOW, please wait...
Operation requires a connection to database "dbuks_898_lhr"
Connecting ...
Connected to "dbuks_898_lhr"
Connected as SYSDBA. New primary database "dbuks_898_lhr" is opening...
Oracle Clusterware is restarting database "dbuks_r2j_ams" ...
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 "dbuks_r2j_ams"
Switchover succeeded, new primary is "dbuks_898_lhr"