Re: Help: Standby database issue
Date: Wed, 02 May 2001 18:24:57 GMT
Message-ID: <3AF051CF.38BE34CA_at_home.nl>
"Daniel A. Morgan" wrote:
>
> ff wrote:
>
> > 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
>
> You could:
>
> SELECT *
> FROM v$log;
>
> to find out which one is active.
>
> Or you could use Oracle replication and throw the PERL away.
>
> Daniel A. Morgan
That would only work on open databases, not in standby mode. However, you could specify your remote location in the init.ora file of your main instance; check the log_archive_dest_n params (EE Only!)
-- Gtrz, Frank van BortelReceived on Wed May 02 2001 - 20:24:57 CEST