RMAN备份控制文件错误，RMAN-03009,ORA-19504,ORA-27040

使用RMAN备份控制文件报错：

Recovery Manager: Release 11.2.0.1.0 - Production on Thu Aug 9 14:01:39 2012

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

connected to target database: EAGAODB (DBID=1839368230)

RMAN> backup format '/backup/rmanback/control_%T_%U' current controlfile;

Starting backup at 09-AUG-12

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=193 device type=DISK

channel ORA_DISK_1: starting full datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set

including current control file in backup set

channel ORA_DISK_1: starting piece 1 at 09-AUG-12

channel ORA_DISK_1: finished piece 1 at 09-AUG-12

piece handle=/backup/rmanback/control_20120809_0jni7dma_1_1 tag=TAG20120809T140144 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

Finished backup at 09-AUG-12

Starting Control File and SPFILE Autobackup at 09-AUG-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 08/09/2012 14:01:50

ORA-19504: failed to create file "/u01/app/oracle/dbs/ /backup/contorlfileback/controlc-1839368230-20120809-00"

ORA-27040: file create error, unable to create file

Linux-x86_64 Error: 2: No such file or directory

上面提示没这样的文件和目录，但经过确认确实是存在目录和文件的已经权限都正确，很奇怪！！，再看看配置

RMAN> show all;

using target database control file instead of recovery catalog

RMAN configuration parameters for database with db_unique_name EAGAODB_DG2 are:

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 15 DAYS;

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 ' /backup/contorlfileback/control%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 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default

CONFIGURE EXCLUDE FOR TABLESPACE 'EAUNION_LOG';

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/dbs/snapcf_eagaodb.f'; # default

仔细的看看上面的保存路径， ' /backup/contorlfileback/control%F'; 好像/前多了一个空格，会不会是这里的问题？？，如是去掉空格

RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/backup/contorlfileback/control%F';

old RMAN configuration parameters:

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO ' /backup/contorlfileback/control%F';

new RMAN configuration parameters:

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/backup/contorlfileback/control%F';

new RMAN configuration parameters are successfully stored

RMAN> show all;

RMAN configuration parameters for database with db_unique_name EAGAODB_DG2 are:

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 15 DAYS;

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 '/backup/contorlfileback/control%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 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default

CONFIGURE EXCLUDE FOR TABLESPACE 'EAUNION_LOG';

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/dbs/snapcf_eagaodb.f'; # default

RMAN> backup format '/backup/rmanback/control_%T_%U' current controlfile;

Starting backup at 09-AUG-12

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=242 device type=DISK

channel ORA_DISK_1: starting full datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set

including current control file in backup set

channel ORA_DISK_1: starting piece 1 at 09-AUG-12

channel ORA_DISK_1: finished piece 1 at 09-AUG-12

piece handle=/backup/rmanback/control_20120809_0lni7dqb_1_1 tag=TAG20120809T140355 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

Finished backup at 09-AUG-12

Starting Control File and SPFILE Autobackup at 09-AUG-12

piece handle=/backup/contorlfileback/controlc-1839368230-20120809-01 comment=NONE

Finished Control File and SPFILE Autobackup at 09-AUG-12

RMAN>

备份成功了，还真是多了一个空格的问题，所以提醒各位不要粗心大意，犯了这样的错误！！！