题目：

331.Which of the following represents the correct way to perform an online recovery of datafile 4, which is assigned to a tablespace called USERS?
A. shutdown restore datafile 4; recover datafile 4; alter database open;
B. Sql alter database datafile 4 offline; restore datafile 4; recover datafile 4; alter database open;
C. Sql alter database datafile 4 offline; restore datafile 4; Sql alter database datafile 4 online;
D. Sql alter database datafile 4 offline; restore database datafile 4; recover database datafile 4; Sql alter database datafile 4 online;
E. Sql alter database datafile 4 offline; restore datafile 4; recover datafile 4; Sql alter database datafile 4 online;
 
参考答案 E
解析
题目意思问，对datafile 4 执行online recovery，哪个是正确的 ？
先offline，再restore，再recover，再online 。选择 E 。

参考文档：

参考https://blog.csdn.net/xxzhaobb/article/details/100240876

end