RDBMS 11.2.0.4
确认没有备份
RMAN> list backup of database;
specification does not match any backup in the repository
RMAN>
在test表空间 ,创建一个表,然后破坏test表空间的文件
create tablespace test datafile '/u01/app/oracle/oradata/test/test.dbf' size 10M autoextend on;
SYS@test>create table t1(d1 date) tablespace test;
Table created.
SYS@test>insert into t1 values(sysdate);
1 row created.
SYS@test>commit;
Commit complete.
SYS@test>select * from t1;
D1
-------------------
2018-03-16 10:20:00
对test表空间的文件进行破坏,文件还存在(略,实际是使用vi命令,添加或者删除一些内容)
进行restore
SYS@test>alter database create datafile '/u01/app/oracle/oradata/test/test.dbf' as
'/u01/app/oracle/oradata/test/test01.dbf' reuse; 2
Database altered.
SYS@test>
进行recover
SYS@test>recover datafile '/u01/app/oracle/oradata/test/test01.dbf';
ORA-00279: change 2552694 generated at 03/16/2018 10:19:25 needed for thread 1
ORA-00289: suggestion : /u01/archive_log/1_216_963595172.dbf
ORA-00280: change 2552694 for thread 1 is in sequence #216
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto
ORA-00279: change 2553140 generated at 03/16/2018 10:21:30 needed for thread 1
ORA-00289: suggestion : /u01/archive_log/1_217_963595172.dbf
ORA-00280: change 2553140 for thread 1 is in sequence #217
ORA-00279: change 2553194 generated at 03/16/2018 10:21:47 needed for thread 1
ORA-00289: suggestion : /u01/archive_log/1_218_963595172.dbf
ORA-00280: change 2553194 for thread 1 is in sequence #218
ORA-00279: change 2553204 generated at 03/16/2018 10:21:55 needed for thread 1
ORA-00289: suggestion : /u01/archive_log/1_219_963595172.dbf
ORA-00280: change 2553204 for thread 1 is in sequence #219
ORA-00279: change 2553285 generated at 03/16/2018 10:22:52 needed for thread 1
ORA-00289: suggestion : /u01/archive_log/1_220_963595172.dbf
ORA-00280: change 2553285 for thread 1 is in sequence #220
ORA-00279: change 2553291 generated at 03/16/2018 10:22:55 needed for thread 1
ORA-00289: suggestion : /u01/archive_log/1_221_963595172.dbf
ORA-00280: change 2553291 for thread 1 is in sequence #221
ORA-00279: change 2553297 generated at 03/16/2018 10:22:58 needed for thread 1
ORA-00289: suggestion : /u01/archive_log/1_222_963595172.dbf
ORA-00280: change 2553297 for thread 1 is in sequence #222
ORA-00279: change 2553300 generated at 03/16/2018 10:22:58 needed for thread 1
ORA-00289: suggestion : /u01/archive_log/1_223_963595172.dbf
ORA-00280: change 2553300 for thread 1 is in sequence #223
ORA-00279: change 2553303 generated at 03/16/2018 10:22:58 needed for thread 1
ORA-00289: suggestion : /u01/archive_log/1_224_963595172.dbf
ORA-00280: change 2553303 for thread 1 is in sequence #224
Log applied.
Media recovery complete.
SYS@test>
验证:
SYS@test>alter database datafile 9 online;
Database altered.
SYS@test>select * from t1;
D1
-------------------
2018-03-16 10:20:00
SYS@test>
SYS@test>select file_name from dba_data_files where tablespace_name='TEST';
FILE_NAME
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/test/test01.dbf
SYS@test>
END。