当前位置: 代码迷 >> Oracle管理 >> rman出错RMAN-03009: failure of Control File and SPFILE
  详细解决方案

rman出错RMAN-03009: failure of Control File and SPFILE

热度:686   发布时间:2016-04-24 04:08:14.0
rman报错RMAN-03009: failure of Control File and SPFILE
RMAN> backup current controlfile for standby format '/pddata2/oracle/backup/data/ctlfile.bak.20150127';                                                                                        

Starting backup at 27-JAN-15                                                                                                                                                                   
using target database control file instead of recovery catalog                                                                                                                                 
allocated channel: ORA_DISK_1                                                                                                                                                                  
channel ORA_DISK_1: SID=692 device type=DISK
channel ORA_DISK_1: starting full datafile backup set                                                                                                                                          
channel ORA_DISK_1: specifying datafile(s) in backup set
including standby control file in backup set                                                                                                                                                   
channel ORA_DISK_1: starting piece 1 at 27-JAN-15
channel ORA_DISK_1: finished piece 1 at 27-JAN-15                                                                                                                                              
piece handle=/pddata2/oracle/backup/data/ctlfile.bak.20150127 tag=TAG20150127T145925 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 27-JAN-15
                                                                                                                                                                                               
Starting Control File and SPFILE Autobackup at 27-JAN-15                                                                                                                                       
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 01/27/2015 14:59:28
ORA-19504: failed to create file "/data/oracle/backup/data/ctl_auto/c-3391761643-20150127-01"
ORA-27041: unable to open file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 9

RMAN>   

我show all;
看了下信息:
RMAN>  show all;                                                                                                                                                                               

RMAN configuration parameters for database with db_unique_name PDUNQ 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 '/data/oracle/backup/data/ctl_auto/%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 ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_powerdes.f'; # default

RMAN>            

这个目录确实不存了,问下可以不可以修改rman的信息,把/data/oracle/backup/data/修改成新的目录呢?
------解决思路----------------------
可以的,备份路径可以随时修改
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '新的路径/%F';
即可
  相关解决方案