Skip to content

ERROR ORA-16191: Primary log shipping client not logged on standby

Problem:

standby database throws error

select dest_name, status, error from gv$archive_dest;

SQL>
DEST_NAME STATUS ERROR
————————————————– ——— —————————————————————–
LOG_ARCHIVE_DEST_1 ERROR ORA-16191: Primary log shipping client not logged on standby

Discovery: Problem with password file. Primary and standby does not have same password file.

 

Solution:

create same password file either on standby or primary database

srvctl modify database -d prm -pwfile
orapwd file=’+ORADATA1′ dbuniquename=prm password=abc format=12

srvctl modify database -d prmyc -pwfile
orapwd file=’+ORADATA1′ dbuniquename=stby password=abc format=12

 

 

No comments yet

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: