Your database is running in noarchivelog mode. One of the data files belonging to the system tablespace is corrupted. Yo

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899559
Joined: Mon Aug 02, 2021 8:13 am

Your database is running in noarchivelog mode. One of the data files belonging to the system tablespace is corrupted. Yo

Post by answerhappygod »

Your database is running in noarchivelog mode. One of the data files belonging to the system tablespace is corrupted. You notice that all online redo logs have been overwritten since the last backup.Which method would you use to recover the data file?

A. Shut downthe instance if not already shut down, restore all data files belonging to the system tablespace from the last backup, and restart the instance.
B. Shut down the instance if not already shut down, restore the corrupted data file belonging to the system tablespace from the last backup, and restart the instance.
C. Shut down the instance if not already shut down, restore all data files for the entire database from the last backup, and restart the instance.
D. Mount the database, restore all data files belongingto the system tablespace from the last backup, and open the database.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!

This question has been solved and has 1 reply.

You must be registered to view answers and replies in this topic. Registration is free.


Register Login
 
Post Reply