restore.txt

来自「Oracle培训专题3-数据库配置.ppt Oracle培训专题4-备份和恢复」· 文本 代码 · 共 41 行

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;