Monday, October 29, 2007

NFS archive destinations.

Scenario
Two instances
rac1 on system1 and rac2 on system2.

Wanted to use a shared nfs(not a CFS) location for archivelogs from both the instances.


created an nfs mount in system2 /backup/rac
Mount it on the system1 and set log_archive_dest_1 in both instances to point to /backup/rac/.

Archival on System 1 was consistently failing with following error.

ORA-19504: failed to create file "" It is not me who removed the file name !!!!!!!! The error message was exactly the same. Instance is complaining it is not able to write the file But it could not even give the file name !!

(ofcouse I have already verified the location is writable by oracle using "touch" ).

Hmm again time for research............
Well found out the following nfs mount options (from oracle doc).

used them -- great. Archival is happening now... and my fstab looks like...
.........
sys2:/backup/rac2/arch /backup/rac2/arch nfs hard,rsize=32768,wsize=32768,noac 0 0
.........
Great I have shared nfs location for archive logs..

Good to go with further experiments !!!!!!!

No comments: