[20180502]ORA-01580.txt

lfree發表於2018-05-02

[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部落格 ” ,連結:http://blog.itpub.net/267265/viewspace-2153661/,如需轉載,請註明出處,否則將追究法律責任。