问题:
今天在AIX 5L 的一个双节点RAC环境测试一个数据库的备份脚本,一开始遇到了一些错误,但没能记录下来,最后就记录下来了这一个ORA-27054错误。
以下是操作过程:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on c2 channel at 04/10/2011 08:12:23
ORA-19504: failed to create file "/vol1/backup/orcl_08m9djj6_1_1_20110410"
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
Additional information: 6
以下是我从网络上找到的3种解决方案:
1、设置事件10298 level 32
alter system set event='10298 trace name context forever,level 32' scope=spfile;
重新启动数据库后生效。
2、打补丁:5146667
3、mount NFS目录时加参数
mount -t nfs -o rw,bg,hard,nointr,rsize=32768,wsize=32768,timeo=600,actimeo=0 192.168.50.165:/home/oracle/testdb
/oracle/oradata
以上参数不是对每个系统都通用。
第三种方法在REDHAT ENTERPRISE LINUX SERVER RELEASE 5.1,oracle 10g 10.2.0.1.0环境测试通过。
我在这个问题中采取第1种方案,重启RAC数据库后问题解决。
以下是执行备份脚本产生的输出:
Script rac_hot_nocatalog_full_database_backup.sh
--------Started on Sun Apr 10 08:29:54 CDT 2011--------
--------Log oracle variables begin--------
RMAN: /u01/app/oracle/product/10.2.0/db_1/bin/rman
ORACLE_SID: orcl1
ORACLE_USER: oracle
ORACLE_HOME: /u01/app/oracle/product/10.2.0/db_1
--------Log oracle variables end--------
--------Begin Rman Backup--------
Today is:Sun Apr 10 08:29:54 CDT 2011
--------Another User Executed--------
User Command String:
ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
export ORACLE_HOME
ORACLE_SID=orcl1
export ORACLE_SID
/u01/app/oracle/product/10.2.0/db_1/bin/rman nocatalog target sys/oracle msglog rac_hot_nocatalog_full_database_backup.sh.out append << EOF
RUN {
allocate channel c1 device type disk connect 'sys/oracle@orcl1';
allocate channel c2 device type disk connect 'sys/oracle@orcl2';
BACKUP FORMAT '/vol1/backup/orcl_%U_%T' skip inaccessible filesperset 5 DATABASE TAG orcl_hot_db_bk;
sql 'alter system archive log current';
BACKUP FORMAT '/vol1/backup/arch_%U_%T' skip inaccessible filesperset 5 ARCHIVELOG ALL DELETE INPUT;
backup current controlfile tag='bak_ctlfile' format='/vol1/backup/ctl_file_%U_%T';
backup spfile tag='spfile' format='/vol1/backup/ORCL_spfile_%U_%T';
release channel c1;
release channel c2;
}
allocate channel for maintenance device type disk connect 'sys/oracle@orcl1';
allocate channel for maintenance device type disk connect 'sys/oracle@orcl2';
report obsolete;
delete noprompt obsolete;
crosscheck backup;
delete noprompt expired backup;
list backup summary;
release channel;
Script rac_hot_nocatalog_full_database_backup.sh
--------Started on Sun Apr 10 08:29:54 CDT 2011--------
--------Log oracle variables begin--------
RMAN: /u01/app/oracle/product/10.2.0/db_1/bin/rman
ORACLE_SID: orcl1
ORACLE_USER: oracle
ORACLE_HOME: /u01/app/oracle/product/10.2.0/db_1
--------Log oracle variables end--------
--------Begin Rman Backup--------
Today is:Sun Apr 10 08:29:54 CDT 2011
--------Another User Executed--------
User Command String:
ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
export ORACLE_HOME
ORACLE_SID=orcl1
export ORACLE_SID
/u01/app/oracle/product/10.2.0/db_1/bin/rman nocatalog target sys/oracle msglog rac_hot_nocatalog_full_database_backup.sh.out append << EOF
RUN {
allocate channel c1 device type disk connect 'sys/oracle@orcl1';
allocate channel c2 device type disk connect 'sys/oracle@orcl2';
BACKUP FORMAT '/vol1/backup/orcl_%U_%T' skip inaccessible filesperset 5 DATABASE TAG orcl_hot_db_bk;
sql 'alter system archive log current';
BACKUP FORMAT '/vol1/backup/arch_%U_%T' skip inaccessible filesperset 5 ARCHIVELOG ALL DELETE INPUT;
backup current controlfile tag='bak_ctlfile' format='/vol1/backup/ctl_file_%U_%T';
backup spfile tag='spfile' format='/vol1/backup/ORCL_spfile_%U_%T';
release channel c1;
release channel c2;
}
allocate channel for maintenance device type disk connect 'sys/oracle@orcl1';
allocate channel for maintenance device type disk connect 'sys/oracle@orcl2';
report obsolete;
delete noprompt obsolete;
crosscheck backup;
delete noprompt expired backup;
list backup summary;
release channel;
#EOF
Recovery Manager: Release 10.2.0.4.0 - Production on Sun Apr 10 08:29:54 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: ORCL (DBID=1275659867)
using target database control file instead of recovery catalog
RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11>
allocated channel: c1
channel c1: sid=133 instance=orcl2 devtype=DISK
allocated channel: c2
channel c2: sid=125 instance=orcl1 devtype=DISK
Starting backup at 10-APR-11
channel c1: starting full datafile backupset
channel c1: specifying datafile(s) in backupset
input datafile fno=00008 name=+DATA/orcl/datafile/catalog_01.dbf
input datafile fno=00002 name=+DATA/orcl/datafile/undotbs01.dbf
input datafile fno=00006 name=+DATA/orcl/datafile/undotsb02.dbf
input datafile fno=00004 name=+DATA/orcl/datafile/users01.dbf
channel c1: starting piece 1 at 10-APR-11
channel c2: starting full datafile backupset
channel c2: specifying datafile(s) in backupset
input datafile fno=00001 name=+DATA/orcl/datafile/system01.dbf
input datafile fno=00003 name=+DATA/orcl/datafile/sysaux01.dbf
input datafile fno=00007 name=+DATA/orcl/datafile/lsf.dbf
input datafile fno=00005 name=+DATA/orcl/datafile/example01.dbf
channel c2: starting piece 1 at 10-APR-11
channel c1: finished piece 1 at 10-APR-11
piece handle=/vol1/backup/orcl_09m9dkk4_1_1_20110410 tag=ORCL_HOT_DB_BK comment=NONE
channel c1: backup set complete, elapsed time: 00:00:01
channel c1: starting full datafile backupset
channel c1: specifying datafile(s) in backupset
including current control file in backupset
channel c1: starting piece 1 at 10-APR-11
channel c1: finished piece 1 at 10-APR-11
piece handle=/vol1/backup/orcl_0bm9dkk5_1_1_20110410 tag=ORCL_HOT_DB_BK comment=NONE
channel c1: backup set complete, elapsed time: 00:00:02
channel c1: starting full datafile backupset
channel c1: specifying datafile(s) in backupset
including current SPFILE in backupset
channel c1: starting piece 1 at 10-APR-11
channel c1: finished piece 1 at 10-APR-11
piece handle=/vol1/backup/orcl_0cm9dkk7_1_1_20110410 tag=ORCL_HOT_DB_BK comment=NONE
channel c1: backup set complete, elapsed time: 00:00:01
channel c2: finished piece 1 at 10-APR-11
piece handle=/vol1/backup/orcl_0am9dkk5_1_1_20110410 tag=ORCL_HOT_DB_BK comment=NONE
channel c2: backup set complete, elapsed time: 00:00:10
Finished backup at 10-APR-11
sql statement: alter system archive log current
Starting backup at 10-APR-11
current log archived
channel c1: starting archive log backupset
channel c1: specifying archive log(s) in backup set
input archive log thread=1 sequence=34 recid=51 stamp=747805229
input archive log thread=1 sequence=35 recid=53 stamp=747805255
input archive log thread=1 sequence=36 recid=55 stamp=747805261
input archive log thread=1 sequence=37 recid=59 stamp=747863966
input archive log thread=1 sequence=38 recid=61 stamp=747955972
channel c1: starting piece 1 at 10-APR-11
channel c2: starting archive log backupset
channel c2: specifying archive log(s) in backup set
input archive log thread=2 sequence=17 recid=44 stamp=747804081
input archive log thread=2 sequence=18 recid=46 stamp=747804162
input archive log thread=2 sequence=19 recid=49 stamp=747805148
input archive log thread=2 sequence=20 recid=57 stamp=747805262
input archive log thread=2 sequence=21 recid=63 stamp=747980099
channel c2: starting piece 1 at 10-APR-11
channel c1: finished piece 1 at 10-APR-11
piece handle=/vol1/backup/arch_0dm9dkl5_1_1_20110410 tag=TAG20110410T083018 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:02
channel c1: deleting archive log(s)
archive log filename=+RECOVERY_AREA/orcl_racdb/archivelog/2011_04_07/thread_1_seq_34.304.747805229 recid=51 stamp=747805229
archive log filename=+RECOVERY_AREA/orcl_racdb/archivelog/2011_04_07/thread_1_seq_35.305.747805255 recid=53 stamp=747805255
archive log filename=+RECOVERY_AREA/orcl_racdb/archivelog/2011_04_07/thread_1_seq_36.306.747805261 recid=55 stamp=747805261
archive log filename=+RECOVERY_AREA/orcl_racdb/archivelog/2011_04_07/thread_1_seq_37.308.747863967 recid=59 stamp=747863966
archive log filename=+RECOVERY_AREA/orcl_racdb/archivelog/2011_04_08/thread_1_seq_38.309.747955973 recid=61 stamp=747955972
channel c2: finished piece 1 at 10-APR-11
piece handle=/vol1/backup/arch_0em9dkl6_1_1_20110410 tag=TAG20110410T083018 comment=NONE
channel c2: backup set complete, elapsed time: 00:00:01
channel c2: deleting archive log(s)
archive log filename=+RECOVERY_AREA/orcl_racdb/archivelog/2011_04_07/thread_2_seq_17.299.747804081 recid=44 stamp=747804081
archive log filename=+RECOVERY_AREA/orcl_racdb/archivelog/2011_04_07/thread_2_seq_18.301.747804163 recid=46 stamp=747804162
archive log filename=+RECOVERY_AREA/orcl_racdb/archivelog/2011_04_07/thread_2_seq_19.303.747805149 recid=49 stamp=747805148
archive log filename=+RECOVERY_AREA/orcl_racdb/archivelog/2011_04_07/thread_2_seq_20.307.747805263 recid=57 stamp=747805262
archive log filename=+RECOVERY_AREA/orcl_racdb/archivelog/2011_04_09/thread_2_seq_21.310.747980099 recid=63 stamp=747980099
channel c1: starting archive log backupset
channel c1: specifying archive log(s) in backup set
input archive log thread=1 sequence=39 recid=65 stamp=748040773
channel c1: starting piece 1 at 10-APR-11
channel c2: starting archive log backupset
channel c2: specifying archive log(s) in backup set
input archive log thread=1 sequence=40 recid=70 stamp=748058166
input archive log thread=1 sequence=41 recid=72 stamp=748058180
input archive log thread=1 sequence=42 recid=74 stamp=748058289
input archive log thread=1 sequence=43 recid=82 stamp=748058427
input archive log thread=1 sequence=44 recid=86 stamp=748081754
channel c2: starting piece 1 at 10-APR-11
channel c1: finished piece 1 at 10-APR-11
piece handle=/vol1/backup/arch_0fm9dkl7_1_1_20110410 tag=TAG20110410T083018 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:01
channel c1: deleting archive log(s)
archive log filename=+RECOVERY_AREA/orcl_racdb/archivelog/2011_04_09/thread_1_seq_39.311.748040773 recid=65 stamp=748040773
channel c2: finished piece 1 at 10-APR-11
piece handle=/vol1/backup/arch_0gm9dkl8_1_1_20110410 tag=TAG20110410T083018 comment=NONE