Re: How Does this work in Detail: Archiving the Standby Redo Log on the Standby Database
From: joel garry <joel-garry_at_home.com>
Date: Thu, 22 Oct 2009 16:06:45 -0700 (PDT)
Message-ID: <1f1f0d17-c1c2-43e3-9990-419d3240b18e_at_x25g2000prf.googlegroups.com>
On Oct 22, 12:23 pm, cfoughty <cfoug..._at_gmail.com> wrote:
> On Oct 22, 12:21 pm, cfoughty <cfoug..._at_gmail.com> wrote:
>
>
>
> > This is mainly just for my interest.
>
> > The documentation says the following:
>
> > A log switch on the primary database triggers a log switch on the
> > standby database, causing ARCn processes on the standby database to
> > archive the standby redo log files to archived redo log files on the
> > standby database.
>
> > So what process on the primary sends the message to what process on
> > the standby telling the ARCH on the standby server to archive the
> > current standby redo log?
>
> > Does the ARCH process on the primary send a message to the RFS process
> > on the standby server, and then the RFS process sends a message to the
> > ARCH process on the standby server telling the standby server ARCH to
> > archive the current standby redo log?
>
> > OR
>
> > Does the ARCH process on the primary send a message to the ARCH
> > process on the standby server telling the standby ARCH to archive the
> > current standby redo log?
>
> > OR
>
> > Some other method to tell the ARCH process on the standby server to
> > archive the current standby redo log?
>
> > I just want to know how it works.
Date: Thu, 22 Oct 2009 16:06:45 -0700 (PDT)
Message-ID: <1f1f0d17-c1c2-43e3-9990-419d3240b18e_at_x25g2000prf.googlegroups.com>
On Oct 22, 12:23 pm, cfoughty <cfoug..._at_gmail.com> wrote:
> On Oct 22, 12:21 pm, cfoughty <cfoug..._at_gmail.com> wrote:
>
>
>
> > This is mainly just for my interest.
>
> > The documentation says the following:
>
> > A log switch on the primary database triggers a log switch on the
> > standby database, causing ARCn processes on the standby database to
> > archive the standby redo log files to archived redo log files on the
> > standby database.
>
> > So what process on the primary sends the message to what process on
> > the standby telling the ARCH on the standby server to archive the
> > current standby redo log?
>
> > Does the ARCH process on the primary send a message to the RFS process
> > on the standby server, and then the RFS process sends a message to the
> > ARCH process on the standby server telling the standby server ARCH to
> > archive the current standby redo log?
>
> > OR
>
> > Does the ARCH process on the primary send a message to the ARCH
> > process on the standby server telling the standby ARCH to archive the
> > current standby redo log?
>
> > OR
>
> > Some other method to tell the ARCH process on the standby server to
> > archive the current standby redo log?
>
> > I just want to know how it works.
It depends: http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/log_transport.htm#i1182869
Look at table 5-2 and the pretty pictures throughout.
>
> > Thanks,
>
> > Cy Foughty
>
> I'm running 10gR2
jg
-- _at_home.com is bogus. http://www.flickr.com/photos/scobleizer/29119056/Received on Thu Oct 22 2009 - 18:06:45 CDT