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

来源:互联网 发布:excel关联表格数据 编辑:程序博客网 时间:2024/05/29 16:30

使用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>


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