分类： Oracle
2013-08-10 13:51:23
RMAN-06094 Datafile does not exist
Applies to:
oracle server version 10.2.0.2 and later.
Symptomes
when trying to recover the database from an incremental backup,the following error is encounted.
Starting recover at 08-MAY-12
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 05/08/2012 13:22:30
RMAN-06094: datafile 1 must be restored
Sulution
When a standby controlfile is recreated, by restoring it from production, the datafile names as shown in v$datafile and RMAN's REPORT SCHEMA will actually reflect those of the primary database rather than the standby database.
RMAN> report schema;
using target database control file instead of recovery catalog
RMAN-06139: WARNING: control file is not current for REPORT SCHEMA
Report of database schema
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 0 SYSTEM *** +DG01/dms/system01.dbf
2 0 UNDOTBS1 *** +DG01/dms/undotbs01.dbf
3 0 SYSAUX *** +DG01/dms/sysaux01.dbf
4 0 USERS *** +DG01/dms/users01.dbf
5 0 UNDOTBS2 *** +DG01/dms/undotbs02.dbf
6 0 CSW_AUDIT *** +DG01/dms/csw_audit01.o02dms3
7 100 CSW_AUDIT_I *** /dms01/app/data/O02DMS3/csw_audit_i01.o02dms3
8 20 OTC_INDEX *** /dms01/app/data/O02DMS3/otc_index_01.o02dms3
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 0 TEMP 32767 +DG01/dms/temp01.dbf
RMAN> run{
2> SET NEWNAME FOR DATAFILE 1 TO '/dms01/app/data/O02DMS3/system01.dbf';
3> SET NEWNAME FOR DATAFILE 2 TO '/dms01/app/data/O02DMS3/undotbs01.dbf';
4> SET NEWNAME FOR DATAFILE 3 TO '/dms01/app/data/O02DMS3/sysaux01.dbf';
5> SET NEWNAME FOR DATAFILE 4 TO '/dms01/app/data/O02DMS3/users01.dbf';
6> SET NEWNAME FOR DATAFILE 5 TO '/dms01/app/data/O02DMS3/undotbs02.dbf';
7> SET NEWNAME FOR DATAFILE 6 TO '/dms01/app/data/O02DMS3/csw_audit01.o02dms3' ;
8> recover database noredo;
}9>
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting recover at 08-MAY-12
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=157 devtype=DISK
datafile 1 switched to datafile copy
input datafile copy recid=3 stamp=782758145 filename=/dms01/app/data/O02DMS3/sys tem01.dbf
datafile 2 switched to datafile copy
input datafile copy recid=5 stamp=782758145 filename=/dms01/app/data/O02DMS3/und otbs01.dbf
datafile 3 switched to datafile copy
input datafile copy recid=7 stamp=782758145 filename=/dms01/app/data/O02DMS3/sys aux01.dbf
datafile 4 switched to datafile copy
input datafile copy recid=9 stamp=782758145 filename=/dms01/app/data/O02DMS3/use rs01.dbf
datafile 5 switched to datafile copy
input datafile copy recid=11 stamp=782758145 filename=/dms01/app/data/O02DMS3/un dotbs02.dbf
datafile 6 switched to datafile copy
input datafile copy recid=13 stamp=782758145 filename=/dms01/app/data/O02DMS3/cs w_audit01.o02dms3
channel ORA_DISK_1: starting incremental datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00001: /dms01/app/data/O02DMS3/system01.dbf
destination for restore of datafile 00002: /dms01/app/data/O02DMS3/undotbs01.dbf
destination for restore of datafile 00003: /dms01/app/data/O02DMS3/sysaux01.dbf
destination for restore of datafile 00004: /dms01/app/data/O02DMS3/users01.dbf
destination for restore of datafile 00005: /dms01/app/data/O02DMS3/undotbs02.dbf
destination for restore of datafile 00006: /dms01/app/data/O02DMS3/csw_audit01.o 02dms3
destination for restore of datafile 00007: /dms01/app/data/O02DMS3/csw_audit_i01 .o02dms3
destination for restore of datafile 00008: /dms01/app/data/O02DMS3/otc_index_01. o02dms3
channel ORA_DISK_1: reading from backup piece /dms01/app/dump/rman/bk_0hnafrhj_1 _1_782757427
channel ORA_DISK_1: restored backup piece 1
piece handle=/dms01/app/dump/rman/bk_0hnafrhj_1_1_782757427 tag=TAG20120508T1637 06
channel ORA_DISK_1: restore complete, elapsed time: 00:01:19
Finished recover at 08-MAY-12
RMAN> exit
RMAN> report schema;
using target database control file instead of recovery catalog
RMAN-06139: WARNING: control file is not current for REPORT SCHEMA
Report of database schema
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 510 SYSTEM *** /dms01/app/data/O02DMS3/system01.dbf
2 30 UNDOTBS1 *** /dms01/app/data/O02DMS3/undotbs01.dbf
3 250 SYSAUX *** /dms01/app/data/O02DMS3/sysaux01.dbf
4 140 USERS *** /dms01/app/data/O02DMS3/users01.dbf
5 489 UNDOTBS2 *** /dms01/app/data/O02DMS3/undotbs02.dbf
6 500 CSW_AUDIT *** /dms01/app/data/O02DMS3/csw_audit01.o02dms3
7 100 CSW_AUDIT_I *** /dms01/app/data/O02DMS3/csw_audit_i01.o02dms3
8 20 OTC_INDEX *** /dms01/app/data/O02DMS3/otc_index_01.o02dms3
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 0 TEMP 32767 +DG01/dms/temp01.dbf
