ORA-27054 in Oracle10g RMAN with NFS

on

环境:IBM AIX 5L + Oracle10.2.0.3 RAC + ASM
动作:实施RMAN

RMAN通过下面的命令在zc2节点上发起对于两个节点上归档日志的备份:

allocate channel t5 type disk connect ‘sys/password@zc2’;
allocate channel t6 type disk connect ‘sys/password@zc1’;
sql ‘alter system archive log thread 2 current’;
sql ‘alter system archive log thread 1 current’;
backup
filesperset 10
format ‘/orabk/arch_%t_%s_%c_%p.arc’
(archivelog UNTIL TIME ‘SYSDATE’ LIKE ‘%/arch/arch2/%’ delete all input channel t5)
(archivelog UNTIL TIME ‘SYSDATE’ LIKE ‘%/arch/arch1/%’ delete all input channel t6);
release channel t5;
release channel t6;

在本地zc2节点上备份成功,但是在zc1节点上的备份命令报错。

RMAN-03009: failure of backup command on t6 channel at 04/15/2007 14:57:19
ORA-19504: failed to create file “/orabk/arch_619973830_547_1_1.arc”
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
Additional information: 5

通过oerr看错误解释,似乎是说zc1节点上NFS的mount选项不正确。

$oerr ora 27054
27054, 00000, “NFS file system where the file is created or resides is not mounted with correct options”
// *Cause: The file was on an NFS partition and either reading the mount tab
// file failed or the partition wass not mounted with the correct
// mount option.
// *Action: Make sure mount tab file has read access for Oracle user and
// the NFS partition where the file resides is mounted correctly.
// For the list of mount options to use refer to your platform
// specific documentation.

反复检查zc1节点上NFS的配置,没有发现问题。后来跟piner交流,甚至按照他们的设置重新设定了NFS,仍然无效。

最后Metalink发现原来居然是Oracle 10.2.0.1之后的一个bug(Bug 5146667),目前只在AIX和Solaris平台上有此症状。解决方法是在实例级别设置10298事件。

alter system set event=’10298 trace name context forever, level 32’scope= spfile ;

2 Comments Add yours

  1. Fenng says:

    是要设置 Hard方式 mount 吧

    不过 Hard 方式 mount ,可用性就差了很多

  2. kamus says:

    测试过hard方式,也同样有错误。

Leave a Reply

Your email address will not be published. Required fields are marked *