What would you do in this situation?

Your database is in NOARCHIVELOG mode and a logswitch happens every 20 minutes. On
Thursday morning, media failure resulted in corruption of a data file belonging to the TOOLS
tablespace. Backups are taken on every Sunday. What would you do in this situation?

Your database is in NOARCHIVELOG mode and a logswitch happens every 20 minutes. On
Thursday morning, media failure resulted in corruption of a data file belonging to the TOOLS
tablespace. Backups are taken on every Sunday. What would you do in this situation?

A.
recover using Oracle Flashback Database technology

B.
restore the data files from backup and perform a complete recovery

C.
restore only the corrupted data file and perform tablespace recovery

D.
restore the data files from backup and perform cancel-based recovery

E.
restore the entire database from the most recent backup and start the instance and
open the database



Leave a Reply 1

Your email address will not be published. Required fields are marked *