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"