Re: Standby Log corruption -- in Recover phase

From: Krishna <krishna.setwin_at_gmail.com>
Date: Mon, 2 Jul 2012 23:50:06 -0400
Message-ID: <CAF6DRCrWG0aou371Gw9UffcXZ-fJOt3Pjpppe-tWtip=V+jjpg_at_mail.gmail.com>

hi,
Thanks Mark and Li Li.
I validated the archivelogs on primary. They are fine.

Now, I am having this error.

Redo transport problem detected: redo transport for database drdb has the following error:
  ORA-00270: error creating archive log
07/02/2012 23:41:26
Redo transport problem detected: redo transport for database drdb has the following error:
  ORA-00270: error creating archive log
07/02/2012 23:42:26
Redo transport problem detected: redo transport for database drdb has the following error:
  ORA-00270: error creating archive log

FRA sizes on both DR & Primary are less than 50%.(i am checking V$FLASH_RECOVERY_AREA_USAGE) i have the following parameter:
log_archive_dest_2='SERVICE=drdb LGWR ASYNC NOAFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=drdb' scope=both sid='*' ;

Any inputs strongly appreciated.

Thanks
krishna.

On Mon, Jul 2, 2012 at 1:03 PM, Li Li <litanli_at_gmail.com> wrote:

> I have had this issue and oracle has logged bug 14227837 for it.
> Currently I manually copy the logs over to standby, then rman catalog
> it to get through this situation.
>
> On Mon, Jul 2, 2012 at 8:05 AM, Krishna <krishna.setwin_at_gmail.com> wrote:
> > 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
> >
> >
>

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

Received on Mon Jul 02 2012 - 22:50:06 CDT