In what order should you perform the following steps to recover your database?
1.Take the datafiles that were lost offline.
2.startup mount the database
3.Issue the alter database open command.
4.Restore the datafiles that were lost
5.Recover the datafiles with the recover datafile command.
6.Bring the datafiles back online.
7.Recover the database with the recover database command.
A. 2,1,3,4,5,6
B. 2,4,5,3
C. 4,7,3
D. 2,4,7,3
E. 2,7,3
答案:(B)
解析:
既然已经crash了,所以就不需要offline和online操作了,直接做restore和recover即可