RE: Why does it take so long to write archive logs

Hi Patrice,

I would never use NFS for the primary archive logs. I was only thinking about the second "optional" destination (LOG_ARCHIVE_DEST_2). I don't think 7.3 supported being able to write archive logs to multiple destinations. I'm running 8.1.7.4.

Kip

|I don't know about 9i, but in 7.3 Oracle Support told me they don't certify
|or support setups where archived logs are written to NFS mounts if you are
|using NFS bundled into the UNIX OS.

|I asked which OS... they said every one, including Digital, HP and Sun.

|They said that if I insisted on using NFS mounts, I had to use a
|connection-based NFS from a 3rd party vendor, which means more $$ to spend.

|So we do not use NFS mounts for archived logs.

|: )

|Patrice.

|-----Original Message-----
|Sent: Monday, July 07, 2003 10:14 PM
|To: Multiple recipients of list ORACLE-L

|Hi John,

|Were you also using "optional" on the secondary, nfs mounted destination?
|Did your DB eventually grind to a stop waiting for the secondary to complete
|(I'm assuming "yes")? I'm considering this sort of thing for a DR setup to
|eliminate the "traffic jam" effect that might be caused by an ftp script run

|through cron. This is for an outsourced DR "solution" with no standby DB.
|I
|managed to talk them into an "archive collecter" server at the outsourcer.

|I've seen problems with WAN (even LAN) NFS mounts where the file is complete

|but apears "locked by another process" on the hosting server (VMS)... I've
|always assumed bandwidth but I wonder whether a busy server could cause
|something similar...

|Kip Bryant

||I had a similar problem on 9.2 and, just as you describe, I could watch the

||file on the remote location and the byte count would show the whole file
||was there but the alert log file would not show the archive complete for
||as long an one hour. When it did finally complete, the byte count on the
||remote file did not change. I worked with Oracle for several month before
||they finally convinced me it was a network problem. I do not really know
||anything about networks so I cannot really help you but our Unix admin guys

||made some changes in the network and the problem went away. Sorry, I
||cannot give you more info because we were also in the process of changing
||out a lot of hardware including network hardware so there is no magic
||parameter I can tell you to change. Just talk to your network gurus and
||hopefully, they can figure it out.

||HTH,
||John

||-----Original Message-----
||Sent: Monday, July 07, 2003 3:34 PM
||To: Multiple recipients of list ORACLE-L

||Hello everyone,

||We have an 8.1.7.4 on HP-UX 11.0 OPS database that uses 200mb archive logs
||with 3 archive log destinations, the first destination is local to the
||machine which is mandatory, the second destination is a filesystem
||accessible via nfs which is optional and the third destination is a remote
||standby database accessible via a vpn which is also optional. We have 10
||archive processes to take care of the writing of the archives. Both the
||local destination and nfs mounted filesystems are on a HP XP256 storage
||device.

||This morning there was a process running that would update a table that is
||used for a catalog of parts. The process was producing archive logs, but
|the
||archives were taking around 10 minutes to write. During the process we
|would
||see the file created with the expected byte count of the file within the
||first minute, but the timestamp of the file would indicate access for the
||next ten minutes.

||We have two other 8.1.7 databases that are setup in a similar manner (that
||are not OPS) that have 2 destinations, one local and the other being sent
|to
||a remote standy database. We are not seeing the same type of issue with the
||archive logs.

||Can someone point me in the direction of either information or advice about
||why the archives may be taking so long to write?

||Is it that we have 3 destinations and it waits until all 3 destinations are
||taken care of?

||Why does the archive log file appear to be modified even though the byte
||count hasn't changed?

||TIA,

||Bryan Rodrigues
||Elcom, Inc.
||Oracle DBA
||--
||Please see the official ORACLE-L FAQ: http://www.orafaq.net
||--
||Author: Rodrigues, Bryan
|| INET: [EMAIL PROTECTED]

||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: [EMAIL PROTECTED] (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).
||--
||Please see the official ORACLE-L FAQ: http://www.orafaq.net
||--
||Author: John Carlson
|| INET: [EMAIL PROTECTED]

||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: [EMAIL PROTECTED] (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).

|--
|Please see the official ORACLE-L FAQ: http://www.orafaq.net
|--
|Author:
| INET: [EMAIL PROTECTED]

|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: [EMAIL PROTECTED] (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).
|--
|Please see the official ORACLE-L FAQ: http://www.orafaq.net
|--
|Author: Boivin, Patrice J
| INET: [EMAIL PROTECTED]

|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: [EMAIL PROTECTED] (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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).