Hendry's "Oracle and SQL Server DBA Stuff"

Oracle and SQL Server Database Solutions for DBA's please visit http://hendrydba.com for the latest posts. Thanks

ORA-16086: standby database does not contain available standby log files

Posted by Hendry chinnapparaj on May 10, 2011

Alert log shows the errors below and log gap detected for the dataguard environment

PRIMARY DATABASE SERVER

————————————-

Mon May  9 11:36:43 2011

LGWR: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (16086)

LGWR: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned

LGWR: Error 16086 creating archivelog file ‘(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=drpserver)(PORT=1521)

))(CONNECT_DATA=(SERVICE_NAME=lmsprd_js_XPT)(INSTANCE_NAME=lmsprd)(SERVER=dedicated)))’

Mon May  9 11:36:43 2011

Errors in file /u01/oracle/admin/lmsprd/bdump/lmsprd_lgwr_36962468.trc:

ORA-16086: standby database does not contain available standby log files

Mon May  9 11:36:43 2011

Destination LOG_ARCHIVE_DEST_2 is UNSYNCHRONIZED

LGWR: Failed to archive log 3 thread 1 sequence 25059 (16086)

Mon May  9 11:36:47 2011

Thread 1 advanced to log sequence 25059 (LGWR switch)

Current log# 3 seq# 25059 mem# 0: /u50/oradata/lmsprd/redo_3a.log

Current log# 3 seq# 25059 mem# 1: /u51/oradata/lmsprd/redo_3b.log

Mon May  9 11:42:21 2011

STANDBY DATABASE SERVER

———————————–

SQL> select group#,sequence#,bytes,used,archived,status from v$standby_log;

GROUP#  SEQUENCE#      BYTES       USED ARC STATUS

———- ———- ———- ———- — ———-

14          0 2147483648        512 NO  UNASSIGNED

15          0 2147483648        512 NO  UNASSIGNED

16          0 2147483648        512 NO  UNASSIGNED

17          0 2147483648        512 YES UNASSIGNED

Trace file at Standby Server

—————————

rfxdgid:0x0

rfxogapflg:0x0

rfsarb.kccicrls:0:79191975

rfsarb.kccicrlc:662481912

Error 16086 creating standby archive log file at host ‘(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=drpserver)

(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=lmsprd_js_XPT)(INSTANCE_NAME=lmsprd)(SERVER=dedicated)))’

*** 2011-05-09 12:24:55.631 62692 kcrr.c

LGWR: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (16086)

*** 2011-05-09 12:24:55.631 62692 kcrr.c

LGWR: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned

*** 2011-05-09 12:24:55.631 62692 kcrr.c

LGWR: Error 16086 creating archivelog file ‘(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=drpserver)(PORT=1521)

))(CONNECT_DATA=(SERVICE_NAME=lmsprd_js_XPT)(INSTANCE_NAME=lmsprd)(SERVER=dedicated)))’

ORA-16086: standby database does not contain available standby log files

*** 2011-05-09 12:24:55.631 60970 kcrr.c

kcrrfail: dest:2 err:16086 force:0 blast:1

Receiving message from LNSb

*** 2011-05-09 12:24:55.637 57269 kcrr.c

Making upidhs request to LNSb (ocis 0x1104a3cf8). Begin time is <05/09/2011 12:24:51> and NET_TIMEOUT <180> seconds

NetServer pid:11927790

*** 2011-05-09 12:24:59.637 57441 kcrr.c

upidhs done status 0

*** 2011-05-09 12:30:07.969

Oracle Fix Recommended

—————————-

Increase the log file size or add more redo logs

Workaround / FIX

——————–

Disable and enable Dataguard broker from the Primary

Dgmgrl sys/*****

Show configuration

Disable configuration

Enable configuration

After disabling / enabling dataguard broker  configuration

select group#,sequence#,bytes,used,archived,status from v$standby_log;

GROUP#  SEQUENCE#      BYTES       USED ARC STATUS

———- ———- ———- ———- — ———-

14      25072 2147483648   10079744 YES ACTIVE

15          0 2147483648        512 NO  UNASSIGNED

16          0 2147483648        512 NO  UNASSIGNED

17          0 2147483648        512 YES UNASSIGNED

Check the Log Gap for Data guard – run the Log Gap check Job.

Advertisements

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

 
%d bloggers like this: