RFS restarts after a long time after network disconnection is there

[swathi]

hi Friends,

In standby data guard, when there is physical disconnect in network
from primary to standby once when the archival file is being written
by RFS, then in our system, the RFS writing is stopped for that
archival and continues being writing for next archival. After next
archivals are written and it sees that no more archivals are pending,
then the lower sequence which was stopped before then starts to be
written from first by rfs after a long time like 1 to 2 hours.

How can this be solved?

Regards
Swathi

[Anand Buldeo]

Swati,

 

Just kill the rfs process which stucks on standby, and delete the archive log. after that just switch the log file on production, it will start..

 

Anand
 

--
You received this message because you are subscribed to the Google Groups "Ask Oracle DBA" group.
To post to this group, send an email to ask-ora...@googlegroups.com.
To unsubscribe from this group, send email to ask-oracle-db...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/ask-oracle-dba?hl=en-GB.

--
Regards
Anand Buldeo

[swathi]

Hi anand

How do we know the RFS process id ti kill it?

Regards
Swathi

On 8 Feb, 12:09, Anand Buldeo <anandbul...@gmail.com> wrote:
> Swati,
>
> Just kill the rfs process which stucks on standby, and delete the archive
> log. after that just switch the log file on production, it will start..
>
> Anand
>

> On 2/8/10, swathi <swath...@gmail.com> wrote:
>
>
>
>
>
>
>
> > hi Friends,
>
> > In standby data guard, when there is physical disconnect in network
> > from primary to standby once when the archival file is being written
> > by RFS, then in our system, the RFS writing is stopped for that
> > archival and continues being writing for next archival. After next
> > archivals are written and it sees that no more archivals are pending,
> > then the lower sequence which was stopped before then starts to be
> > written from first by rfs after a long time like 1 to 2 hours.
>
> > How can this be solved?
>
> > Regards
> > Swathi
>
> > --
> > You received this message because you are subscribed to the Google Groups
> > "Ask Oracle DBA" group.
> > To post to this group, send an email to ask-ora...@googlegroups.com.
> > To unsubscribe from this group, send email to

> > ask-oracle-db...@googlegroups.com<ask-oracle-dba%2Bunsubscribe@go­oglegroups.com>

> > .
> > For more options, visit this group at
> >http://groups.google.com/group/ask-oracle-dba?hl=en-GB.
>
> --
> Regards

> Anand Buldeo- Hide quoted text -
>
> - Show quoted text -

[Anand Buldeo]

Swati,

 

It is mentioned in v$managed_standby there is column called pid. So using that pid you can kill it.

 

On which platform u r working?

 

Anand

To unsubscribe from this group, send email to ask-oracle-db...@googlegroups.com.

For more options, visit this group at http://groups.google.com/group/ask-oracle-dba?hl=en-GB.

--
Regards
Anand Buldeo

[swathi]

Hi

is wondows 2003 server.Should i use orakill pid

also rfs stops like this frequently.should we have do kill this every
time?

regards
Swathi

On 8 Feb, 14:28, Anand Buldeo <anandbul...@gmail.com> wrote:
> Swati,
>

[swathi]

Hi Anand

It works.I have killed the rfs process thatw as hung and another
process has started.

Regards
swathi

> > - Show quoted text -- Hide quoted text -

[Anand Buldeo]

Swati,

 

Good to see your reply.

One question, for which company r u working and what's your role

 

Regards

Anand Buldeo

To unsubscribe from this group, send email to ask-oracle-db...@googlegroups.com.

For more options, visit this group at http://groups.google.com/group/ask-oracle-dba?hl=en-GB.

--
Regards
Anand Buldeo