shutdown immediate
backup

insert into table1 values('10');
commit;
alter system switch logfile;
select name from v$archived_log; 

--數據文件、控制文件、日志文件完全丟失
shutdown immediate

restore

startup mount
recover database using backup controlfile;
anto
recover database using backup controlfile until cancel;
cancel
alter database open resetlogs 


--(單個數據)數據文件完全丟失、控制文件，日志文件沒有丟失

startup mount
recover database
alter database open

--數據文件、控制文件完全丟失，日志文件沒有丟失
startup mount
recover database using backup controlfile;
anto
recover database using backup controlfile until cancel;
d:\oracle\oradata\my9idb\redo03.log
alter database open resetlogs;