Re: Help: Standby database

try something like this:

select file_name
  from v$archived_log
 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 Thu May 03 2001 - 23:59:06 CDT