ocp認證052考題解析：1Z0-V8.02-第75題
最新學訊：近期OCP認證正在報名中，因考試人員較多請盡快報名獲取最近考試時間，報名費用請聯系在線老師，甲骨文官方認證，報名從速！
我要咨詢ocp認證052考題解析：1Z0-V8.02-第75題，完整題庫請點擊這里聯系老師咨詢了解
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.
Answer: C
答案解析：
在非歸檔模式下，只能使用冷備份來備份所有的文件，當數據文件丟失，重做日志被覆蓋。則只能恢復到最近一次的一致性備份。不能用重做日志恢復到指定的時間點。
數據庫處于NOARCHIVELOG模式(默認模式)時，只能恢復到最后一次備份時的狀態。在該備份之后執行的所有事務處理都會丟失。
