returning error ORA-16191

Hi,

Issue - Standby not in sync

Version - oracle 11g

Error in alert log file -

PING[ARC1]: Heartbeat failed to connect to standby ‘STANDBY’. Error is 16191.
Sat Aug 06 02:06:52 2011
Error 1017 received logging on to the standby
------------------------------------------------------------
Check that the primary and standby are using a password file
and remote_login_passwordfile is set to SHARED or EXCLUSIVE,
and that the SYS password is same in the password files.
returning error ORA-16191

If you face the above error in your 11g standby setup, then do not waste your time with investigating unnecessary things. First check listener status at both sites and then check remote_login_passwordfile.
It should be shared or exclusive.

Most probably the above said things would be fine.

So just copy your primary password file to standby passwordfile location.($ORACLE_HOME/dbs).

Now check your RFS & MRP process it would be running.

If not just restart the MRPO process. :)

To Stop MRP

SQL>alter database recover managed standby database cancel

To Start MRP (If your environment is real time apply then use second command to restart MRP)

SQL>alter database recover managed standby database disconnect from session;

SQL>alter database recover managed standby database using current logfile disconnect from session;

Thank u..