RMAN> alter database mount;

RMAN> recover database;

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01245: offline file 6 will be lost if RESETLOGS is done
ORA-01111: name for data file 6 is unknown - rename to correct file
ORA-01110: data file 6: '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/UNNAMED00006'

将数据文件6改名字
alter database create datafile 6 as '/u01/app/oracle/oradata/PROD2/indx01.dbf';

SYS@PROD2>alter database datafile 6 online;

Database altered.

RMAN> recover database;

Starting recover at 12-MAY-15
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3

starting media recovery

archived log for thread 1 with sequence 5 is already on disk as file /u01/app/oracle/oradata/PROD2/redo02.log
archived log file name=/u01/app/oracle/oradata/PROD2/redo02.log thread=1 sequence=5
Oracle Error:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01245: offline file 6 will be lost if RESETLOGS is done
ORA-01110: data file 6: '/u01/app/oracle/oradata/PROD2/indx01.dbf'

media recovery complete, elapsed time: 00:00:00
Finished recover at 12-MAY-15

注意不要使用rman恢复当using backup controlfile 使用sqlplus

sqlplus / as sysdba
SYS@PROD2>recover database using backup controlfile;
ORA-00279: change 1212936 generated at 05/12/2015 02:15:52 needed for thread 1
ORA-00289: suggestion : /u01/app/oracle/archive/1_5_879466155.dbf
ORA-00280: change 1212936 for thread 1 is in sequence #5

Specify log: { =suggested | filename | AUTO | CANCEL}
auto

SYS@PROD2>select group#,sequence#,status from v$log;

GROUP# SEQUENCE# STATUS
---------- ---------- ----------------
1 4 CURRENT
3 3 ACTIVE
2 2 INACTIVE

sequence 为5 的还没有归档，指定当前redo日志目录

SYS@PROD2>recover database using backup controlfile;
ORA-00279: change 1212936 generated at 05/12/2015 02:15:52 needed for thread 1
ORA-00289: suggestion : /u01/app/oracle/archive/1_5_879466155.dbf
ORA-00280: change 1212936 for thread 1 is in sequence #5

Specify log: { =suggested | filename | AUTO | CANCEL}
/u01/app/oracle/oradata/PROD2/redo02.log
Log applied.
Media recovery complete.

SYS@PROD2>select * from v$recover_file;

no rows selected

SYS@PROD2>alter database open resetlogs;

SYS@PROD2>select * from test;

EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
---------- ---------- --------- ---------- --------- ---------- ---------- ----------
7369 SMITH CLERK 7902 17-DEC-80 800 20
7566 JONES MANAGER 7839 02-APR-81 2975 20
7782 CLARK MANAGER 7839 09-JUN-81 2450 10
7788 SCOTT ANALYST 7566 19-APR-87 3000 20
7839 KING PRESIDENT 17-NOV-81 5000 10
7876 ADAMS CLERK 7788 23-MAY-87 1100 20
7902 FORD ANALYST 7566 03-DEC-81 3000 20
7934 MILLER CLERK 7782 23-JAN-82 1300 10

8 rows selected.

?

查看记录正常，恢复成功！

注意事项：

1。需要重定向数据文件

alter database create datafile 6 as '/u01/app/oracle/oradata/PROD2/indx01.dbf';

2。数据文件修改为online

alter database datafile 6 online;

3。当using backup controlfile时，不能使用rman恢复

?