Oracle-L: RE: archiving redo logs

From: Steve McClure <smcclure_at_usscript.com>
Date: Tue, 10 Dec 2002 16:17:34 -0800
Message-ID: <F001.00517148.20021210161734@fatcity.com>

RE: Oracle 9i installation - Basic Qs - HELP!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: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Bala Regupathy
  Sent: Tuesday, December 10, 2002 1:53 PM   To: Multiple recipients of list ORACLE-L   Subject: RE: archiving redo logs

In 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: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Bala Regupathy

Sent: Tuesday, December 10, 2002 2:06 PM To: Multiple recipients of list ORACLE-L Subject: archiving redo logs

Hi,

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

If UNIX script is the only option, I appreciate if you can share it here.

Thanks,

Bala.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Steve McClure
INET: smcclure_at_usscript.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Dec 10 2002 - 18:17:34 CST