[20191118]ORA-01580.txt
--//别人建立dg遇到的问题,主要是2边目录结构不一样.做一个演示:
RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u02/app/oracle/product/11.2.0.4/dbhome_1/dbs/snapcf_book.f';
new RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u02/app/oracle/product/11.2.0.4/dbhome_1/dbs/snapcf_book.f';
new RMAN configuration parameters are successfully stored
RMAN> backup spfile ;
Starting backup at 2019-11-18 15:41:56
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=156 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 2019-11-18 15:41:59
channel ORA_DISK_1: finished piece 1 at 2019-11-18 15:42:00
piece handle=/u01/app/oracle/fast_recovery_area/BOOK/backupset/2019_11_18/o1_mf_nnsnf_TAG20191118T154158_gx4lt78v_.bkp tag=TAG20191118T154158 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 2019-11-18 15:42:00
ORA-01580: error creating control backup file /u02/app/oracle/product/11.2.0.4/dbhome_1/dbs/snapcf_book.f
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 1
RMAN-08132: WARNING: cannot update recovery area reclaimable file list
--//注意看下划线.目录不存在.修改正确后,ok.
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 '/u02/app/oracle/product/11.2.0.4/dbhome_1/dbs/snapcf_book.f';
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 spfile ;
Starting backup at 2019-11-18 15:45:05
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 SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 2019-11-18 15:45:06
channel ORA_DISK_1: finished piece 1 at 2019-11-18 15:45:07
piece handle=/u01/app/oracle/fast_recovery_area/BOOK/backupset/2019_11_18/o1_mf_nnsnf_TAG20191118T154506_gx4m02to_.bkp tag=TAG20191118T154506 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 2019-11-18 15:45:07