在AIX系统上设置一个归档路径到一个NFS目录，归档不成功，查看数据库日志：

Tue Oct 7 09:45:13 2008
Thread 1 advanced to log sequence 115
Current log# 3 seq# 115 mem# 0: /data/oradata/CMSPRD/redo03.log
Tue Oct 7 09:45:13 2008
Errors in file /apps/oracle/odbs/admin/CMSPRD/bdump/cmsprd_arc0_532534.trc:
ORA-19504: failed to create file "/apps712/oracle/oradata/CMSPRD/arch/arch1_114_664809703.dbf"
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
Additional information: 6
Tue Oct 7 09:45:13 2008
ARC0: Error 19504 Creating archive log file to '/apps712/oracle/oradata/CMSPRD/arch/arch1_114_664809703.dbf'

起初以为是mount时的参数不对，但是尝试了很多选项仍然无效，最后从国外一个网站上看到一个帖子，说只能从Oracle自身这边解决，从AIX这边无法解决，试验了一下居然成功了，原贴如下：

There is nothing that can be done on the AIX side. The only solution is to follow the Oracle Metalink Note:387700.1 Log in as Oracle DBA user
SQL>alter system set event='10298 trace name context forever, level 32' scope= spfile ;
then shutdown immediate/startup the database, then try backup again.

ITPub博客

Oracle - AIX上NFS目录归档失败

最新文章