ITPub博客

首页 > 数据库 > Oracle > rman参数配置错误导致控制文件无法备份

rman参数配置错误导致控制文件无法备份

原创 Oracle 作者:始于脚下 时间:2017-06-15 14:25:41 0 删除 编辑

告警日志提示的错误信息:

Linux-x86_64 Error: 21: Is a directory

Fri Dec 11 08:54:36 2015

Errors in file /u01/app/oracle/diag/rdbms/jzfpdb/jzfpdb1/trace/jzfpdb1_m000_3150.trc:

ORA-01580: error creating control backup file /u01/app/oracle/11.2.0/db/dbs/

ORA-27056: could not delete file

Linux-x86_64 Error: 21: Is a directory

Errors in file /u01/app/oracle/diag/rdbms/jzfpdb/jzfpdb1/trace/jzfpdb1_m000_3150.trc:

ORA-01580: error creating control backup file /u01/app/oracle/11.2.0/db/dbs/

ORA-27056: could not delete file

Linux-x86_64 Error: 21: Is a directory


根据报错的信息,该错误是一个控制文件备份错误的问题,进入rman环境下,备份控制文件:

RMAN> backup current controlfile;

 

Starting backup at 11-DEC-15

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=3537 instance=jzfpdb1 device type=DISK

channel ORA_DISK_1: starting full datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03009: failure of backup command on ORA_DISK_1 channel at 12/11/2015 11:24:10

ORA-01580: error creating control backup file /u01/app/oracle/11.2.0/db/dbs/

ORA-27056: could not delete file

Linux-x86_64 Error: 21: Is a directory

可以看到,报出跟日志中同样的错误,说明问题的原因就在备份控制文件这个点上,查看rman备份参数:

RMAN> show all;

 

RMAN configuration parameters for database with db_unique_name JZFPDB 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 '/backup/%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 APPLIED ON STANDBY;

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/11.2.0/db/dbs/';

可以看到snapshot controlfile name参数的值指向了日志中错误提示出来的路径,从路径的目录来看,该参数指向的是一个文件夹目录,这是不正确的,一般情况下,该参数指向的应该是一个文件的绝对路径并且是指定文件名的,那么,我们尝试通过这种思路去解决这个问题,

在rman环境下修改snapshot controlfile name的值:

RMAN> configure snapshot  controlfile name to '/u01/app/oracle/11.2.0/db/dbs/snapcf_jzfpdb1.f';

 

old RMAN configuration parameters:

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/11.2.0/db/dbs/';

new RMAN configuration parameters:

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/11.2.0/db/dbs/snapcf_jzfpdb1.f';

new RMAN configuration parameters are successfully stored

可以看到参数设置已成功的保存,接着我们在测试一下看是不是这个原因,用同样的方法备份控制文件:

RMAN> backup current controlfile;

 

Starting backup at 11-DEC-15

using channel ORA_DISK_1

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 11-DEC-15

channel ORA_DISK_1: finished piece 1 at 11-DEC-15

piece handle=+FRA/jzfpdb/backupset/2015_12_11/ncnnf0_tag20151211t112709_0.760.898169231 tag=TAG20151211T112709 comment=NONE

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

Finished backup at 11-DEC-15

 

Starting Control File and SPFILE Autobackup at 11-DEC-15

piece handle=/backup/c-1095298896-20151211-00 comment=NONE

Finished Control File and SPFILE Autobackup at 11-DEC-15

可以看到,控制文件已成功备份,没有再报出先前备份控制文件的错误,监控数据库告警日志文件,再也没发现有错误描述所报的错误。

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

请登录后发表评论 登录
全部评论
拥有多年电信行业Oracle数据库管理经验,拥有Oracle OCP、OCM证书,擅长各个场景下的数据库备份与恢复、性能分析管理、上线规划及部署实施、架构设计、自动化运维等。

注册时间:2016-10-18

  • 博文量
    106
  • 访问量
    561503