转 ORA-16191 "Primary log shipping client not logged on standby

###sample 0

 

原因未知：

 

解决办法，重建密码文件

 

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;

 

转载于:https://www.cnblogs.com/feiyun8616/p/10858501.html