您好,登錄后才能下訂單哦!
1.環境描述
ORACLE 12CR1
RHEL 7.0
2.操作過程
switchover to xxx 報錯,過程如下:
<orcldg:orcldg:/home/oracle>$dgmgrl /
DGMGRL for Linux: Version 12.1.0.2.0 - 64bit Production
Copyright (c) 2000, 2013, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
Connected as SYSDG.
DGMGRL> show configuration;
Configuration - dg_config
Protection Mode: MaxAvailability
Members:
orcl - Primary database
orcldg - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS (status updated 14 seconds ago)
DGMGRL> validate database orcl;
Database Role: Primary database
Ready for Switchover: Yes
DGMGRL> validate database orcldg;
Database Role: Physical standby database
Primary Database: orcl
Ready for Switchover: Yes
Ready for Failover: Yes (Primary Running)
DGMGRL> switchover to orcldg;
Performing switchover NOW, please wait...
New primary database "orcldg" is opening...
Oracle Clusterware is restarting database "orcl" ...
ORA-01017: invalid username/password; logon denied
Warning: You are no longer connected to ORACLE.
shut down instance "orcl" of database "orcl"
start up instance "orcl" of database "orcl"
DGMGRL>
DGMGRL> connect sys/oracle@orcl
Connected as SYSDBA.
DGMGRL> switchover to orcldg;
Performing switchover NOW, please wait...
Error: ORA-16558: database specified for switchover is not a standby database
Failed.
Unable to switchover, primary database is still "orcldg"
DGMGRL> switchover to orcl;
Performing switchover NOW, please wait...
New primary database "orcl" is opening...
Oracle Clusterware is restarting database "orcldg" ...
Switchover succeeded, new primary is "orcl"
DGMGRL>
免責聲明:本站發布的內容(圖片、視頻和文字)以原創、轉載和分享為主,文章觀點不代表本網站立場,如果涉及侵權請聯系站長郵箱:is@yisu.com進行舉報,并提供相關證據,一經查實,將立刻刪除涉嫌侵權內容。