本文详细阐述了在数据库运行过程中，当数据文件users_01.dbf丢失时，如何通过离线该数据文件、从备份介质中恢复并进行数据恢复等步骤来解决此问题。正确顺序为：离线数据文件、恢复数据文件、恢复数据、在线数据文件。
QUESTION 172
Your database has experienced a loss of datafile users_01.dbf, which is associated with a
ablespace called USERS. The database is still running.Which answer properly describes the rder
of the steps that you would use to recover from this error?
1.Shut down the database.
2.Take the users_01.dbf datafile offline with the alter database command.
3.Restore the users_01.dbf datafile from backup media with the required archived redo logs.
4.Restore all users tablespace-related datafiles from backup media.
5.Issue the recover tablespace users command.
6.Issue the recover datafile users_01.dbf command.
7.Start up the database.
8.Bring the users_01.dbf datafile online with the alter database command.
A. 1,3,6,7
B. 2,3,6,8
C. 1,2,3,6,7
D. 1,2,3,6,,7,8
E. 2,3,6,5,7
Answer: B
同564题：http://blog.csdn.net/rlhua/article/details/13774447
Explanation/Reference:
Section: Backup, Recovery & Recovery Manager (RMAN)
扫一扫
1530
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
