rman-数据文件丢失的恢复

1.假设删除ORAL2数据文件，模拟数据文件丢失
[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;