归档模式下数据文件丢失且无备份的恢复

要求所有归档日志都存在

shutdown immediate;
cp * ../db01bak/
startup
conn nick/nick
select * from nick;
insert into nick values(9,'nick09');
commit;
alter system switch logfile;
host rm nick.dbf
insert into nick values(10,'nick10');
commit;
conn /as sysdba;
shutdown immediate;
shutdown abort
startup
select * from v$recover_file;
alter database datafile 6 offline;
select * from v$recover_file;
alter database create datafile 6;
recover datafile 6;
auto
alter database open;
select tablespace_name,status from dba_tablespaces;
select FILE_NAME,STATUS from dba_data_files;
select FILE_NAME,online_STATUS from dba_data_files;
alter database datafile 6 online;
conn nick/nick
select * from nick.nick;