Re: Standby Database: How do you make sure the redolog copied is the good one

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Wed, 2 May 2001 16:21:49 +0100
Message-ID: <3af02618$0$12246$ed9e5944_at_reading.news.pipex.net>


What version of Oracle.

The reason I ask is that automatic writing of redo logs to a standby location is available in 8i. The enhancements to standby in 8i make IMO a compelling reason to upgrade to it if you have not yet done so and require a standby database.

--
Niall Litchfield
Oracle DBA
Audit Commission UK

<u518615722_at_spawnkill.ip-mobilphone.net> wrote in message
news:l.988387816.1884063720_at_[198.138.198.252]...

> We have a standby database, and we use
> a perl scripts to copy all the redo logs
> to the standby site.
>
> The way we do is after we detect the file
> by ls -l, we wait another 30 seconds to make
> sure the redolog writing is finished. But
> it is not foolproof. Sometimes we got corrupted
> redolog files.
>
> Any better ideas except wait for another 30 seconds?
>
> Thanks
>
>
>
>
> --
> Sent by dbadba62 from hotmail in field com
> This is a spam protected message. Please answer with reference header.
> Posted via http://www.usenet-replayer.com/cgi/content/new
Received on Wed May 02 2001 - 17:21:49 CEST

Original text of this message