Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: standby database not in synchronize with production database

Re: standby database not in synchronize with production database

From: yls177 <yls177_at_hotmail.com>
Date: 28 Mar 2004 20:47:17 -0800
Message-ID: <c06e4d68.0403282047.37416af4@posting.google.com>


Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl> wrote in message news:<f8bq509gnc6np6ajpqq4e4p0pana0nkjrm_at_4ax.com>...
> On 20 Mar 2004 18:26:16 -0800, yls177_at_hotmail.com (yls177) wrote:
>
> >yls177_at_hotmail.com (yls177) wrote in message news:<c06e4d68.0403082131.20abe6fe_at_posting.google.com>...
> >> yls177_at_hotmail.com (yls177) wrote in message news:<c06e4d68.0402100630.c439a6a_at_posting.google.com>...
> >> > in my oracle dr, trace file, i have the below entries repeating many times
> >> > Sat Feb 7 04:01:54 2004
> >> > RFS: Possible network disconnect with primary database
> >> > Sat Feb 7 04:01:58 2004
> >> > RFS: Possible network disconnect with primary database
> >> >
> >> >
> >> > and ocassionaly, some of the below entries
> >> > Sat Feb 7 04:05:04 2004
> >> > Fetching gap sequence for thread 1, gap sequence 182161-182223
> >> > Trying FAL server:
> >> > Error fetching gap sequence, no FAL server specified
> >> > Sat Feb 7 04:05:19 2004
> >> >
> >> > therefore, i went to check the usertrace file and get the below explanation
> >> >
> >> > "Encountered disk I/O error 19502"
> >> >
> >> > and apparanetly, in my errpt, it shows the below
> >> > "67581038 0207040504 T H hdisk32 DISK OPERATION ERROR
> >> > F45CFAFB 0130133804 P H hdisk374 OPEN FAILURE "
> >> >
> >> >
> >> > so i guess the culprit is the disk issues.
> >> >
> >> > the arch filesystem is not full in both databases.
> >> >
> >> > what do u think?
> >>
> >>
> >>
> >> again this happeened
> >>
> >>
> >> ARC0: RFS network connection lost at host 'standby'
> >> ARC0: Error 3113 creating standby archivelog file at host 'standby'
> >>
> >>
> >> is the network problem?
> >
> >
> >
> >
> >did a recover managed standby database, but then realised that the
> >archive logs files are not copied yet so i had to copy them after
> >issuing the command
> >
> >Tue Feb 3 12:38:36 2004
> >Fetching gap sequence for thread 1, gap sequence 181300-181300
> >Trying FAL server:
> >Error fetching gap sequence, no FAL server specified
> >Tue Feb 3 12:38:51 2004
> >Failed to request gap sequence. Thread #: 1, gap sequence:
> >181300-181300
> >All FAL server has been attempted.
> >
> >
> >after which, the database did not recover on its own, and all was
> >given was the message above. my thoughts are that after i copy the
> >files over, oracle should start recover but ti just hang there. so i
> >had to cancel the recovery and start with "recover standby database"
> >
> >
> >comments?
>
> That would be the normal, documented, procedure, wouldn't it?

okay.. thanks for confirming.... Received on Sun Mar 28 2004 - 22:47:17 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US