Oracle
1Z0-052 · Question #219
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
Sign in or unlock 1Z0-052 to reveal the answer and full explanation for question #219. The question stem and answer options stay visible for context.
Performing Backup and Recovery
Question
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?
Options
- Arecover using Oracle Flashback Database technology
- Brestore the data files from backup and perform a complete recovery
- Crestore only the corrupted data file and perform tablespace recovery
- Drestore the data files from backup and perform cancel-based recovery
- Erestore the entire database from the most recent backup and start the instance and open the
Unlock 1Z0-052 to see the answer
You've previewed enough free 1Z0-052 questions. Unlock 1Z0-052 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#NOARCHIVELOG mode#media recovery#complete recovery#full database restore