Standby fell behind primary after sys password reset

Problem

In a Data Guard environment, the SYS password for the primary was changed.
Now the primary and the standby do not have the same password.
The two databases need to have the same SYS password, otherwise, the standby will not be able to apply logs.

In this environment, there is a primary and a Data Guard standby.

The standby is desynchronized, it is 2 hours behind the primary.
In the standby:
select  round((sysdate-max(first_time))*(1440/60))|| ‘ hours behind the primary’
from  V$ARCHIVED_LOG

ROUND((SYSDATE-MAX(FIRST_TIME))*(1440/60))||’Hours behind the primary ‘
—————————————————————–
2 hours behind the primary

Errors in the primary alert.log:
******************************************************************
LGWR: Setting ‘active’ archival for destination LOG_ARCHIVE_DEST_2
******************************************************************
LNS: Standby redo logfile selected for thread 1 sequence 50165 for destination LOG_ARCHIVE_DEST_2
Tue Jan 14 10:56:43 2014
Archived Log entry 138887 added for thread 1 sequence 50164 ID 0xffffffffd5b9f30d dest 1:
Tue Jan 14 11:01:14 2014
Error 1031 received logging on to the standby
PING[ARC2]: Heartbeat failed to connect to standby ‘oradbstby’. Error is 1031.
Tue Jan 14 11:02:14 2014
Error 1031 received logging on to the standby
PING[ARC2]: Heartbeat failed to connect to standby ‘oradbstby’. Error is 1031.
Tue Jan 14 11:03:15 2014

Solution

Replace the standby orapwd with the primary’s orapwd:
Copy the orapwd file from the primary to the standby.
Rename the file so that it will be the same as the standby’s original orapwd.

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s