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