控制文件自动备份不支持NAS

今天本来想把控制文件和spfile自动备份在NAS上，结果不支持，改来本地存储备份正常。

原配置如下：

[oracle@zzbrac42 ctl_zzbrac4]$ rman target /

Recovery Manager: Release 11.1.0.7.0 - Production on Tue Nov 27 10:06:33 2012

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

connected to target database: ZZBRAC4 (DBID=625164168)

RMAN> show all;

using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name ZZBRAC4 are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/mnt/ctlbak/ctl_zzbrac4/ctl_zzbrac4_%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BZIP2'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.1.0/db_1/dbs/snapcf_zzbrac42.f'; # default

RMAN>

 

/mnt/ctlbak/是NAS挂过来的目录。

 

备份时出现如下错误：

 

Starting backup at 27-NOV-12
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting compressed archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=148 RECID=271 STAMP=800444104
input archived log thread=1 sequence=149 RECID=272 STAMP=800444113
input archived log thread=2 sequence=126 RECID=270 STAMP=800444104
input archived log thread=2 sequence=127 RECID=273 STAMP=800444115
channel ORA_DISK_1: starting piece 1 at 27-NOV-12
channel ORA_DISK_1: finished piece 1 at 27-NOV-12
piece handle=/mnt/rmanbak/zzbrac4_rmanbackup/arch_26_1_800444124 tag=TAG20121127T093524 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
channel ORA_DISK_1: deleting archived log(s)
archived log file name=+DATADG/zzbrac4/archivelog/2012_11_27/thread_1_seq_148.495.800444105 RECID=271 STAMP=800444104
archived log file name=+DATADG/zzbrac4/archivelog/2012_11_27/thread_1_seq_149.485.800444113 RECID=272 STAMP=800444113
archived log file name=+DATADG/zzbrac4/archivelog/2012_11_27/thread_2_seq_126.493.800444105 RECID=270 STAMP=800444104
archived log file name=+DATADG/zzbrac4/archivelog/2012_11_27/thread_2_seq_127.489.800444115 RECID=273 STAMP=800444115
Finished backup at 27-NOV-12

Starting Control File and SPFILE Autobackup at 27-NOV-12
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of Control File and SPFILE Autobackup command on ORA_DISK_1 channel at 11/27/2012 09:35:29
ORA-19504: failed to create file "/mnt/rmanbak/ctl_zzbrac4/ctl_zzbrac4_c-625164168-20121127-00"
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
Additional information: 3

 

后来改到本地：

 

[oracle@zzbrac42 ctl_zzbrac4]$ rman target /

Recovery Manager: Release 11.1.0.7.0 - Production on Tue Nov 27 10:06:33 2012

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

connected to target database: ZZBRAC4 (DBID=625164168)

RMAN> show all;

using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name ZZBRAC4 are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/ctl_zzbrac4/ctl_zzbrac4_%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BZIP2'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.1.0/db_1/dbs/snapcf_zzbrac42.f'; # default

RMAN>

 

自动备份成功：

Starting backup at 27-NOV-12
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting compressed archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=150 RECID=275 STAMP=800445734
input archived log thread=1 sequence=151 RECID=276 STAMP=800445749
input archived log thread=2 sequence=128 RECID=274 STAMP=800445735
input archived log thread=2 sequence=129 RECID=277 STAMP=800445751
channel ORA_DISK_1: starting piece 1 at 27-NOV-12
channel ORA_DISK_1: finished piece 1 at 27-NOV-12
piece handle=/mnt/rmanbak/zzbrac4_rmanbackup/arch_28_1_800445755 tag=TAG20121127T100235 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_1: deleting archived log(s)
archived log file name=+DATADG/zzbrac4/archivelog/2012_11_27/thread_1_seq_150.493.800445735 RECID=275 STAMP=800445734
archived log file name=+DATADG/zzbrac4/archivelog/2012_11_27/thread_1_seq_151.485.800445749 RECID=276 STAMP=800445749
archived log file name=+DATADG/zzbrac4/archivelog/2012_11_27/thread_2_seq_128.489.800445735 RECID=274 STAMP=800445735
archived log file name=+DATADG/zzbrac4/archivelog/2012_11_27/thread_2_seq_129.495.800445751 RECID=277 STAMP=800445751
Finished backup at 27-NOV-12

Starting Control File and SPFILE Autobackup at 27-NOV-12
piece handle=/home/oracle/ctl_zzbrac4/ctl_zzbrac4_c-625164168-20121127-01 comment=NONE
Finished Control File and SPFILE Autobackup at 27-NOV-12

RMAN>

Recovery Manager complete.
------copy controlfile to nas------
----- Tue Nov 27 10:02:38 CST 2012 ------
-------------end------------------

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/27471208/viewspace-750037/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/27471208/viewspace-750037/