1.假设删除ORAL2数据文件,模拟数据文件丢失
[img]http://dl.iteye.com/upload/attachment/199808/a37c7055-c2f7-3d1c-a3aa-88110336fcac.jpg[/img]
2.
[img]http://dl.iteye.com/upload/attachment/199824/facfed63-c80c-3c96-b4be-fb440f2973b9.jpg[/img]
3.
4.
5.
[img]http://dl.iteye.com/upload/attachment/199827/0645736b-627e-3e60-b901-7da10f9e93b0.jpg[/img]
6.
7.
[img]http://dl.iteye.com/upload/attachment/199808/a37c7055-c2f7-3d1c-a3aa-88110336fcac.jpg[/img]
2.
startup mount;
report schema;
[img]http://dl.iteye.com/upload/attachment/199824/facfed63-c80c-3c96-b4be-fb440f2973b9.jpg[/img]
3.
sql "alter database datafile 6 offline";
4.
restore datafile 6
5.
recover datafile 6
[img]http://dl.iteye.com/upload/attachment/199827/0645736b-627e-3e60-b901-7da10f9e93b0.jpg[/img]
6.
sql "alter database datafile 3 online";
7.
alter database open resetlogs;