Re: Standby Log corruption -- in Recover phase

From: Krishna <krishna.setwin_at_gmail.com>
Date: Mon, 2 Jul 2012 09:05:26 -0400
Message-ID: <CAF6DRCoZ5saYGRGv6zs7sjUCrbfb5kAyM=dHD0uDFK6gN9i_GA_at_mail.gmail.com>

Mark,
Thanks for your reply.
I dont see any corruption errors on primary nodes.

I see the following errors on primary..

FAL[server, ARC2]: FAL archive failed, see trace file. ARCH: FAL archive failed. Archiver continuing ORACLE Instance primdb1 - Archival Error. Archiver continuing.

On Mon, Jul 2, 2012 at 8:49 AM, Mark W. Farnham <mwf_at_rsiz.com> wrote:

> I would start by validating the archived redo log on the primary. That
> should help determine a direction for the solution and establish whether
> the
> corruption is primary or a network artifact.
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of Krishna
> Sent: Monday, July 02, 2012 6:57 AM
> To: Oracle List
> Subject: Standby Log corruption -- in Recover phase
>
> Hi All,
> I am trying to set up RAC to RAC dataguard between 2 databases in different
> data centers.
> I am able to ship archivelogs from primary to DR. The logs are not getting
> applied.
>
>
> In the standby alert log -- I see the following errors (several of these
> CORRUPTION DETECTED Errors)
>
> *CORRUPTION DETECTED: In redo blocks starting at block 4097count 2048 for
> thread 4 sequence 15019*
> RFS[1185]: Possible network disconnect with primary database *Deleted
> Oracle
> managed file
> +FR1/drdb/archivelog/2012_07_02/thread_4_seq_15019.578.787560321*
> RFS[1186]: Possible network disconnect with primary database Mon Jul 02
> 06:45:36 2012
> RFS[1189]: Assigned to RFS process 5016
> RFS[1189]: Opened log for thread 2 sequence 12872 dbid 832151255 branch
> 782279895
> *CORRUPTION DETECTED: In redo blocks starting at block 1count 2048 for
> thread 2 sequence 12872 Deleted Oracle managed file
> +FR1/drdb/archivelog/2012_07_02/thread_2_seq_12872.578.787560337*
> Mon Jul 02 06:45:38 2012
>
>
> another thing is -- I have any another application, where there is
> dataguard from RAC to single instance. For this I dont see any problem..
>
> can anybody throw some light on this problem?
>
> Thanks in advance..
>
> Krishna
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Jul 02 2012 - 08:05:26 CDT