75.Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS

75.Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS
tablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten
since the last backup.
What would you do to recover the data file?
A.Take the USERS tablespace offline and re-create the lost data file.
B.Shut down the instance, restore the data file from the last consistent backup, and restart the database instance.
C.Shut down the instance, restore all the database files from the last consistent backup, and restart the database instance.
D.Take the USERS tablespace offline, restore all the data files of the USERS tablespace from the last consistent backup, and make the tablespace online.
答案:C
解析：数据库运行在非归档模式下，user表空间的数据文件损坏了，怎么处理
这里由于运行在非归档模式下，所以只能进行冷备，恢复的话只能将所有的数据文件，控制文件，重做日志文件，参数文件以及密码文件
全部进行替换，然后启动，因此只能选择C，注意其实不光是所有数据文件，最起码还需要控制文件和重做日志文件

最后

以上就是害羞战斗机为你收集整理的75.Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS的全部内容，希望文章能够帮你解决75.Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS所遇到的程序开发问题。

如果觉得靠谱客网站的内容还不错，欢迎将靠谱客网站推荐给程序员好友。