switchovertoxxx犯的低级错误-创新互联
1.环境描述
创新互联公司致力于互联网品牌建设与网络营销,包括网站设计、网站建设、SEO优化、网络推广、整站优化营销策划推广、电子商务、移动互联网营销等。创新互联公司为不同类型的客户提供良好的互联网应用定制及解决方案,创新互联公司核心团队10年专注互联网开发,积累了丰富的网站经验,为广大企业客户提供一站式企业网站建设服务,在网站建设行业内树立了良好口碑。ORACLE 12CR1
RHEL 7.0
2.操作过程
switchover to xxx 报错,过程如下:
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>
另外有需要云服务器可以了解下创新互联cdcxhl.cn,海内外云服务器15元起步,三天无理由+7*72小时售后在线,公司持有idc许可证,提供“云服务器、裸金属服务器、高防服务器、香港服务器、美国服务器、虚拟主机、免备案服务器”等云主机租用服务以及企业上云的综合解决方案,具有“安全稳定、简单易用、服务可用性高、性价比高”等特点与优势,专为企业上云打造定制,能够满足用户丰富、多元化的应用场景需求。
名称栏目:switchovertoxxx犯的低级错误-创新互联
标题网址:http://azwzsj.com/article/ieeoh.html