Re: remote server for log_archive_dest

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).

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