转 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