[20191118]ORA-01580.txt

[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