ARCH wait on SENDREQ

 

ROBLEM: ARCHIVE process get hang on Primary Database
——–
The problem has been that the standby hardware have some faulty backpane.
This has caused processes in the standby to go into what is called as “D”
state where the processes gets stuck in a kernel call. So the RFS processes
on the standby are getting hung in the Operating System. This in turn causes the ARCH processes on the primary to hang. These ARCH processes on the primary are in actuality archiving the ORLs to the standby and to the local destination. So when they hang, they are also preventing the archival of the ORLs to the local destination. When enough of these ARCH processes hang, the primary runs out of ORLs and thus the primary itself hangs even though log_archive_local_first is set to true (default).

DIAGNOSTIC ANALYSIS:
——————–

ORKAROUND:
———–
Manually transfer archives and apply them to the standby database daily.
RELATED BUGS:
————-
bug 6113783 and bug 6987510

Advertisements

About Sher khan

Senior Oracle DBA, Oracle 10g , Oracle 11g OCE ,Oracle 12C and Oracle 11g OPN certified Specialist, OCP Certified in Oracle 9i,10g , 11g and 12C. I am working in Oracle technology since 2004. Currently working in U.A.E Email: sher487@hotmail.com
This entry was posted in Oracle DataGaurd. Bookmark the permalink.

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