How
comfortable with perl are you? I think you could put together a
quick perl daemon that could query your local archive directory every few
minutes and then copy new files to your alternate host via nfs mounted drives or
ftp if you are comfortable with that. If you are more comfortable with
shell scripting, you can do the same thing there. My advice would be to
start small and build in more automation and features as you go, because such a
'script' could grow to be fairly complex.
If the two hosts are on the same local network and the volume of archived logs
is not great you could write a fairly simple shell script to copy all new files
or even all files in the archive location to an nfs mounted destination on the
alternate host. In fact you may be able to use nfs to have Oracle handle
the whole process for you by specifying
log_archive_dest_2='nfs_mounted_remote_filesystem'.
P.S.
if you are not comfortable with perl or shell scripting, and are working with
Oracle on UNIX, get comfortable with perl or shell
scripting.
Steve
McClure
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bala Regupathy
Sent: Tuesday, December 10, 2002 1:53 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: archiving redo logsIn other words, I would like to simulate the behavior of :log_archive_dest_2 = 'SERVICE=PRODSB REOPEN=30'using unix/sql script.Bala.-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bala Regupathy
Sent: Tuesday, December 10, 2002 2:06 PM
To: Multiple recipients of list ORACLE-L
Subject: archiving redo logsHi,How can I archive redo logs automatically to a different machine ?. Standby database is not an option because the target machine's OS is different from the primary.Primary db is 8.1.7.2 resides on SUN E10k with SunOS 5.8.Target server is DEC Alpha 4.0If UNIX script is the only option, I appreciate if you can share it here.Thanks,Bala.