Oracle - AIX上NFS目錄歸檔失敗

GM_DBA發表於2015-01-07
OracleAINFS

在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部落格 ” ，連結：http://blog.itpub.net/29319205/viewspace-1393248/，如需轉載，請註明出處，否則將追究法律責任。

相關文章