ITPub博客

首页 > 数据库 > Oracle > [20180502]ORA-01580.txt

[20180502]ORA-01580.txt

原创 Oracle 作者:lfree 时间:2018-05-02 15:40:38 0 删除 编辑

[20180502]ORA-01580.txt

RMAN> backup current controlfile;

Starting backup at 2018-05-02 15:36:03
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
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 05/02/2018 15:36:04
ORA-01580: error creating control backup file /u01/app/oracle/product/11.2.0.4/dbhome_1/dbs
ORA-27056: could not delete file
Linux-x86_64 Error: 21: Is a directory


RMAN> show SNAPSHOT CONTROLFILE NAME;
RMAN configuration parameters for database with db_unique_name BOOK are:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs';

--//必须写入文件名!!

RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/snapcf_book.f';

old RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs';
new RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/snapcf_book.f';
new RMAN configuration parameters are successfully stored

RMAN> backup current controlfile;

Starting backup at 2018-05-02 15:37:15
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
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 2018-05-02 15:37:16
channel ORA_DISK_1: finished piece 1 at 2018-05-02 15:37:17
piece handle=/u01/app/oracle/fast_recovery_area/BOOK/backupset/2018_05_02/o1_mf_ncnnf_TAG20180502T153715_fgltodl9_.bkp tag=TAG20180502T153715 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 2018-05-02 15:37:17

Starting Control File and SPFILE Autobackup at 2018-05-02 15:37:17
piece handle=/u01/app/oracle/fast_recovery_area/BOOK/autobackup/2018_05_02/o1_mf_s_975080237_fgltofp0_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 2018-05-02 15:37:18

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

请登录后发表评论 登录
全部评论
熟悉oracle相关技术,擅长sql优化,rman备份与恢复,熟悉linux shell编程。

注册时间:2008-01-03

  • 博文量
    4006
  • 访问量
    7971419