ORA-27054 on NFS file system on SUSE 10 SP2 for archives to be create directly on standby server.

On SUSE 10 SP 2 which is the supported version to be used with LOCAL,SAN,NAS devices and database 10gR2 although you create nfs filesystems archiver process reports the following error :

ORA-27054: NFS file system where the file is created or resides is not mounted with correct options

This is happening because on Oracle 10gR2 Oracle checks the options with which a NFS mount is mounted on the filesystem.
Correct option for SUSE datafiles,archives and backup are :
cio,rw,bg,hard,nointr,rsize=32768,wsize=32768,proto=tcp,noac,vers=3,timeo=600

If you mount your NFS filesystems and you got on this error this is due to bug 5146667

If available apply patch. Else use the following work around:

1) set the Event 10298 in the init file event="10298 trace name context forever, level 32"

If you are using the spfile then :


SQL> alter system set event='10298 trace name context forever, level 32'scope= spfile sid='*';

Once you set the above parameter bounce the instance to effect parameter.

Check as follows

SQL> select name, value from v$parameter where name = 'event';
NAME VALUE
---------- ------------------------------------------------------------
Event 10298 trace name context forever, level 32

Then try by switching logfile again.

sid='*' is for RAC. For single instance do not use it.