Re: Help: Standby database issue

From: Frank van Bortel <fbortel_at_home.nl>
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 Bortel
Received on Wed May 02 2001 - 20:24:57 CEST

Original text of this message