Chinaunix首页 | 论坛 | 博客
  • 博客访问: 1117120
  • 博文数量: 159
  • 博客积分: 3063
  • 博客等级: 中校
  • 技术积分: 2703
  • 用 户 组: 普通用户
  • 注册时间: 2012-04-01 01:51
文章分类

全部博文(159)

文章存档

2013年(48)

2012年(111)

分类: 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

阅读(6985) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~