rac環境下使用impdp匯入資料出錯

lfree發表於2007-11-03

關鍵字:rac ocfs2 ORA-39083 ORA-01115 impdp
前一陣子,幫別人解決了一個問題,就是建立好ocfs2檔案系統後,使用impdp匯入大量資料出錯,報告如下:

ORA-39083: Object type INDEX failed to create with error:
ORA-01115: IO error reading block from file 24 (block # 29334)
ORA-01110: data file 24: '/data/orcl/XXX.dbf'
ORA-27091: unable to queue I/O
ORA-27072: File I/O error

google找到如下連結:
http://oss.oracle.com/projects/ocfs2/dist/documentation/ocfs2_faq.html

從第二個連線看似乎已經匯入完成,但是問題也是在建立索引的時候存在問題,在仔細看第1個連線的文件,發現存在如下內容:

ORACLE RAC
# Any special flags to run Oracle RAC?
OCFS2 volumes containing the Voting diskfile (CRS), Cluster registry (OCR), Data files, Redo logs, Archive logs and Control files must be mounted with the datavolume and nointr mount options. The datavolume option ensures that the Oracle processes opens these files with the o_direct flag. The nointr option ensures that the ios are not interrupted by signals.
# mount -o datavolume,nointr -t ocfs2 /dev/sda1 /u01/db
# What about the volume containing Oracle home?
Oracle home volume should be mounted normally, that is, without the datavolume and nointr mount options. These mount options are only relevant for Oracle files listed above.
# mount -t ocfs2 /dev/sdb1 /software/orahome
Also as OCFS2 does not currently support shared writeable mmap, the health check (GIMH) file $ORACLE_HOME/dbs/hc_ORACLESID.dat and the ASM file $ASM_HOME/dbs/ab_ORACLESID.dat should be symlinked to local filesystem. We expect to support shared writeable mmap in the OCFS2 1.4 release.

修改/etc/fstat引數,加入nointr後,在使用impdp匯入正常:
/dev/sdb1 /xxx ocfs2 _netdev,datavolume,nointr 0 0

補充說明一點,就是按照第一個連結,建立ocfs2
mkfs.ocfs2 -b 4K -C 256K -N 4 -L /oradata /dev/sdb1
測試問題一樣,在加入nointr引數後正常。


來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/267265/viewspace-83104/,如需轉載,請註明出處,否則將追究法律責任。

相關文章