RMAN基于备份控制文件恢复失败

我做了个RMAN基于备份控制文件恢复的测试，但最后datafile显示MISSING00006不知是何原因，下面是测试步骤，请帮忙看看/

--先建立一个表空间，后面删除并恢复它
SQL> create tablespace eric
  2  datafile 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\LISA\DATAFILE\eric01.DBF'
  3  size 10m;

Tablespace created.

C:\Documents and Settings\L5M>rman target /

Recovery Manager: Release 10.2.0.3.0 - Production on Tue Feb 26 08:45:09 2008

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

connected to target database: LISA (DBID=1171353837)

RMAN> configure controlfile autobackup on;

RMAN> backup database;

SQL> select to_char(sysdate,'yyyy-mm-dd:hh24:mi:ss') from dual;

TO_CHAR(SYSDATE,'YY
-------------------
2008-02-26:08:50:11

SQL> drop tablespace eric including contents and datafiles;

Tablespace dropped.

C:\Documents and Settings\L5M>set nls_date_format=yyyy-mm-dd hh24:mi:ss

C:\Documents and Settings\L5M>rman target /

RMAN> startup force nomount

RMAN> set dbid=1171353837

RMAN> restore controlfile from autobackup;
Starting restore at 2008-02-26 08:57:13
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=157 devtype=DISK

recovery area destination: D:\oracle\product\10.2.0\admin\lisa\flash_recovery_ar
ea
database name (or database unique name) used for search: LISA
channel ORA_DISK_1: autobackup found in the recovery area
channel ORA_DISK_1: autobackup found: D:\ORACLE\PRODUCT\10.2.0\ADMIN\LISA\FLASH_
RECOVERY_AREA\LISA\AUTOBACKUP\2008_02_26\O1_MF_S_647686276_3W6RN4SW_.BKP
channel ORA_DISK_1: control file restore from autobackup complete
output filename=D:\ORACLE\PRODUCT\10.2.0\ORADATA\LISA\CONTROLFILE\CONTROL.CTL
Finished restore at 2008-02-26 08:57:19

RMAN> alter database mount;

RMAN> run {
2> set until time='2008-02-26 08:50:11';
3> restore database;
4> recover database;
5> sql 'alter database open resetlogs';
6> }


SQL> select ts#,name from v$datafile;

       TS# NAME
---------- -----------------------------------------------------------------
         0 D:\ORACLE\PRODUCT\10.2.0\ORADATA\LISA\DATAFILE\SYSTEM01.DBF
         1 D:\ORACLE\PRODUCT\10.2.0\ORADATA\LISA\DATAFILE\UNDOTBS01.DBF
         2 D:\ORACLE\PRODUCT\10.2.0\ORADATA\LISA\DATAFILE\SYSAUX01.DBF
         4 D:\ORACLE\PRODUCT\10.2.0\ORADATA\LISA\DATAFILE\USERS01.DBF
         4 D:\ORACLE\PRODUCT\10.2.0\ORADATA\LISA\DATAFILE\USERS02.DBF
         9 D:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\MISSING00006

6 rows selected.


SQL> select ts#,name from v$tablespace;

       TS# NAME
---------- -----------------------------------
         0 SYSTEM
         1 UNDOTBS1
         2 SYSAUX
         4 USERS
         3 TEMP
         9 ERIC

6 rows selected.


看得出来，表空间是恢复出来了，数据文件应该恢复到'D:\ORACLE\PRODUCT\10.2.0\ORADATA\LISA\DATAFILE\eric01.DBF'。不知哪里有问题，请大虾们帮忙看看。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/271283/viewspace-195786/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/271283/viewspace-195786/