| NFS archivelog destination [message #349982] |
Tue, 23 September 2008 11:59  |
mkahler
Messages: 1
Registered: September 2008
|
Junior Member |
|
|
Hi. I want to setup a secondary archivelog destination to a NFS mount point (10.2.0.3). For example, I want to set the following spfile parameters:
db_recovery_file_dest=/data3/flash_recovery_area
log_archive_dest_2='LOCATION=/nfs_mount_point'
log_archive_dest_10='LOCATION=USE_DB_RECOVERY_FILE_DEST'
The problem is if the nfs server serving /nfs_mount_point becomes unavailable. Since /nfs_mount_point needs to be mounted with the "hard" attribute (per 10.2.x), any I/O's to the NFS mount point will wait until the nfs server returns. Therefore, the archiver will hang writing to that mount point...and the database hangs. Since no error is returned from NFS, the archiver hangs indefinitely until the nfs server returns.
We tried setting OPTIONAL for log_archive_dest_2, with no luck. It seems if I mount the /nfs_mount_point as "soft" and specify a timeout, the archiver will continue once it receives the timeout error from NFS.
Any help in working around this hang issue would be greatly appreciated. Thank you!
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
