Oracle
1Z0-052 · Question #259
1Z0-052 Question #259: Real Exam Question with Answer & Explanation
The correct answer is E: ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 2;. See the full explanation below for the reasoning.
Question
Redo log files are not multiplexed in your database. Redo log blocks are corrupted in group 2, and archiving has stopped. All the redo logs are filled and database activity is halted. Database writer has written everything to disk. Which command would you execute to proceed further?
Options
- ARECOVER LOGFILE BLOCK GROUP 2;
- BALTER DATABASE DROP LOGFILE GROUP 2;
- CALTER DATABASE CLEAR LOGFILE GROUP 2;
- DALTER DATABASE RECOVER LOGFILE GROUP 2;
- EALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 2;
Community Discussion
No community discussion yet for this question.