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>
备份成功了,还真是多了一个空格的问题,所以提醒各位不要粗心大意,犯了这样的错误!!!
- RMAN备份控制文件错误,RMAN-03009,ORA-19504,ORA-27040
- oracle rman备份与ORA-19504&ORA-27040&RMAN-03009
- RAC RMAN 备份 RMAN-03009 ORA-19504 ORA-27040 RMAN-06012 channel c3 not allocated 错误分析
- RAC RMAN 备份 RMAN-03009 ORA-19504 ORA-27040 RMAN-06012 channel c3 not allocated 错误分析
- 11gR2 RAC RMAN备份问题------ORA-00245控制文件autobackup错误
- RMAN备份错误ORA-19502的学习
- RMAN备份时ORA-19809错误
- rman异地和本地备份---ORA-19504
- rman 备份出现ORA-00245/RMAN-08132
- RMAN备份失败 RMAN-06059 ORA-19625
- Oracle 11g RAC RMAN ORA-00245 control file backup operation failed 错误 与 控制文件备份 说明
- Oracle 11g RAC RMAN ORA-00245 control file backup operation failed 错误 与 控制文件备份 说明
- 只有spfile和控制文件情况下进行rman恢复时报ORA-00312 ORA-00313错误
- RMAN备份遭遇ORA-235
- rman备份出现ORA-19625
- rman备份出现ORA-19625
- rman备份出现ORA-19625
- 备份遇到RMAN-03009,ORA-19809,ORA-19804
- 随CAD加载Arx和dll
- Spring、MyBatis的整合数据映射器类(UserMapper->iocContext.xml)配置文件详解
- LAMP CentOS 6.x yum v2
- LNMP CentOS 6.x fastcgi spawn-fcgi v1
- Java代码优化--尽可能地使用stack(栈)变量(方法内部的局部变量)
- RMAN备份控制文件错误,RMAN-03009,ORA-19504,ORA-27040
- 自定义JS 字符串操作函数
- ps 查看系统进程
- 关于容器内URL传递中文参数乱码的解决方案
- Android中利用tcp dump抓包
- JSONArrayBuilder:用于生成格式简单的json array字符串
- C++笔记(二)友元
- Install VMware Tools on Ubuntu
- PHP 面向对象:访问控制