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: Help: Standby database issue

Re: Help: Standby database issue

From: Edward Knoch <eeknoch_at_gci.net>
Date: 30 May 2001 15:11:14 -0700
Message-ID: <c242a22d.0105301411.240f7e98@posting.google.com>

"ff" <cfs3526_at_ureach.com> wrote in message news:<WhKH6.7841$Aj1.3878670_at_typhoon2.ba-dsg.net>...
> We have a standby databse, and we use a in house developed perl script to
> copy the redologs from the remote production database.
> The way we do is we use 'ls -l' to detect the redolog file, as soon as we
> see it, wait for 30 seconds, and then we copy it over. Most of time it
> worked, but sometimes, the copy begins before the production finish writing
> to the redo, and we got corrupted file.
> Is there any way we can monitor the finish of the redologs and begin to copy
> only after the writing of redologs have finished?
>
> Thanks for your help.
>
> PS: Could some body show me your script for manually copy your redo logfile
> to remote standby database?
>
> Thanks.

Two questions:

  1. Is the standby on the same box as the primary database?
  2. What version of Oracle are you using (8.1.7.0.1 or other)..?

Thanks,

Ed Received on Wed May 30 2001 - 17:11:14 CDT

Original text of this message

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