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

on most os's there should be some command that will tell you if a file is open by another process or not. On at least some UNIX systems the "fuser" command will tell you what process has a file open. If the return value is null, then nothing has the file open and, in this case, means that the redo log has finished being written to and can safely be transferred to your standby system

--
Jim Gregory
Principal Consultant for Keane, Inc.
Currently assigned to NCR, Dayton, OH

Opinions are my own and do not reflect those
of my employer or clients
<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