###sample 0

 

SRE实战 互联网时代守护先锋,助力企业售后服务体系运筹帷幄!一键直达领取阿里云限量特价优惠。

原因未知:

 

解决办法,重建密码文件

 

primary db :
alter system set log_archive_dest_state_2=defer sid='*' scope=both;

 


standby db

db:
su - db

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

 

in primary

mv orapwdb1 orapwdb1.bak
orapwd file=orapwdb1 password=manager entries=100 ignorecase=Y

mv orapwdb2 orapwdb2.bak
orapwd file=orapwdb2 password=manager entries=100 ignorecase=Y

SQL> alter user sys identified by manager;

 

in standby

mv orapwdb1 orapwdb1.bak
orapwd file=orapwdb1 password=manager entries=100 ignorecase=Y

mv orapwdb2 orapwdb2.bak
orapwd file=orapwdb2 password=manager entries=100 ignorecase=Y


db:
alter database recover managed standby database using current logfile disconnect from session;

 

 

primary db :
alter system set log_archive_dest_state_2=ENABLE sid='*' scope=both;

 

扫码关注我们
微信号:SRE实战
拒绝背锅 运筹帷幄