Re: Help: Standby database
Date: Fri, 04 May 2001 04:59:06 GMT
Message-ID: <3AF236A9.9B5F1C7_at_home.com>
try something like this:
select file_name
from v$archived_log
[Quoted] where seq#=(
select max(SEQ#) from v$archived_log where archived='TRUE'
);
hth,
Paul
u518615722_at_spawnkill.ip-mobilphone.net 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 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
>
>
>
> --
> Sent by dbadba62 from hotmail within area com
> This is a spam protected message. Please answer with reference header.
> Posted via http://www.usenet-replayer.com/cgi/content/new
Received on Fri May 04 2001 - 06:59:06 CEST