已索引

切换前检查：

ADG 切换前检查

已索引检查日志同步如果日志同步异常，不要做切换。在主库上查询：SQL> SELECT INST_ID, DE... 

DGMGRL> show configuration;

Configuration - demodb

  Protection Mode: MaxAvailability
  Members:
  demodb    - Primary database
    demodbstd - Physical standby database

Fast-Start Failover:  Disabled

Configuration Status:
SUCCESS   (status updated 31 seconds ago) 
DGMGRL> switchover to demodbstd;
Performing switchover NOW, please wait...
New primary database "demodbstd" is opening...
Oracle Clusterware is restarting database "demodb" ...
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 an idle instance.
Connected to an idle instance.
Connected to an idle instance.
Connected to "demodb"
Connected to "demodb"
Switchover succeeded, new primary is "demodbstd"
DGMGRL> show configuration;    <--- 切换后就查询会有很多报错，要多等一会儿，可能长达几分钟

Configuration - demodb

  Protection Mode: MaxAvailability
  Members:
  demodbstd - Primary database
    demodb    - Physical standby database

Fast-Start Failover:  Disabled

Configuration Status:
SUCCESS   (status updated 47 seconds ago)
-- By 许望（RHCA、OCM、VCP）
最后修改：2024 年 09 月 23 日 05 : 11 PM
© 允许规范转载
如果觉得我的文章对你有用，请随意赞赏