This forum is currently locked. You can't register or post questions at this time. (read more)

Archive file not applying on standby database

All posts relating to Oracle database administration.

Moderator: Tim...

Raaj A
Senior Member
Posts: 51
Joined: Wed Mar 07, 2012 7:08 am

Archive file not applying on standby database

Postby Raaj A » Sat Jan 26, 2013 11:48 am

Hi Tim,

I have setup data gaurd on oracle(11.2.0.1) on AIX. Archive file are going from primary to standby database but it not applying on standby side.
i have checked media recovery process(MRP0) process is on on standby side.

Primary alert log file showing below message

Fri Jan 25 21:26:46 2013
WARN: ARCe: Terminating pid 1789976 hung on an I/O operation
WARN: ARCe: Terminating pid 1155260 hung on an I/O operation
krsv_proc_kill: Killing 1 processes (Process by index)
Fri Jan 25 21:26:58 2013
krsv_proc_kill: Killing 1 processes (Process by index)
ARCe: Detected ARCH process failure
ARCe: STARTING ARCH PROCESSES
Fri Jan 25 21:27:00 2013

Standby alert log file showing below messages:

Fri Jan 25 21:17:41 2013
krsv_proc_kill: Killing 1 processes (idle RFS by thread/sequence)
Fri Jan 25 21:17:46 2013
RFS[4]: Assigned to RFS process 17236212
RFS[4]: Opened log for thread 1 sequence 10799 dbid -1517571978 branch 774453046
Fri Jan 25 21:22:44 2013
RFS[4]: Possible network disconnect with primary database
Fri Jan 25 21:22:46 2013
RFS[5]: Assigned to RFS process 10092606
RFS[5]: Opened log for thread 1 sequence 10799 dbid -1517571978 branch 774453046
Fri Jan 25 21:23:16 2013
krsv_proc_kill: Killing 1 processes (idle RFS by thread/sequence)

Please help

Thanks
Raaj

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: Archive file not applying on standby database

Postby Tim... » Sat Jan 26, 2013 12:47 pm

Hi.

I've not experienced this before. I guess you should search on MyOracleSupport or raise an SR there.

Looking at the error, it seems there maybe an network issue here.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog


Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 4 guests

cron