Re: remote server for log_archive_dest

On 8/24/05, Mark Bole <makbo_at_pacbell.net> wrote:
> For successful user-managed archived redo log backups, you must
> duplicate two key features of automated log transport:
>
> 1) don't copy a file until it is completely written and closed.
>
> 2) copy those files, and only those files, which haven't already been
> copied (due to network outages, target system down, whatever).
>
> For item 1, you can query the database (SELECT THREAD#,SEQUENCE#,NAME
> FROM V$ARCHIVED_LOG;) or, on most flavors of Unix, the "fuser" command
> can determine whether a process currently has a file open. (I am not
> aware of a "fuser" equivalent under Windows).

Hi mark,

The utility "handle.exe" from SysInternals might be of some use here. One could dump all the handle info for the pid of the oracle process of interest and grep that for archived redo logs.

The brute force method would be to move the files to a staging directory. If a handle is held on the file, the move will fail. Its ugly, but works.

Paul

> For item 2, the rsync command works great, either using ssh to a remote
> server (as described below) or on any network-mounted filesystem. On
> Windows, the robocopy.exe utility duplicates most of rsync's
> functionality but only with a mounted filesystem, not a remote server.
>
> --
> Mark Bole
> http://www.bincomputing.com
>
> Eric Buddelmeijer wrote:
> > Secure copy or secure ftp (scp or sftp) is the first that comes to mind.
> > Secure replacements for rcp and ftp respectively. Requires an ssh daemon on
> > the server you will be copying to and of course the client versions on your
> > oracle server. When using authentication with private/public key pairs it
> > can be running in the background.
> >
> > Kind regards,
> > Eric.
> [...]
> >>
> >>I am wanting to write my archive logs to a different server
> >>to the one my database runs on.
> >>
> >>This server will not be running Oracle therefore I can't send
> >>the archive job via NET8, i currently send the file via FTP
> >>but is there a slicker method
> >>
>
> --
> http://www.freelists.org/webpage/oracle-l
>

-- 
#/etc/init.d/init.cssd stop
# f=ma, divide by 1, convert to moles.
--
http://www.freelists.org/webpage/oracle-l