052-241(新增70题2018)

最新推荐文章于 2025-12-06 15:58:48 发布

转载最新推荐文章于 2025-12-06 15:58:48 发布 · 69 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/Babylon/p/8623732.html

文章标签：

#数据库

本文详细介绍了在Oracle数据库中遇到Redo日志文件未复用、Redo日志块在第2组中损坏且归档停止的问题时的解决方案。当所有Redo日志已满且数据库活动停止时，文章提供了正确的命令来清除未归档的损坏Redo日志组，以避免归档并使日志可供再次使用。

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?

A. RECOVER LOGFILE BLOCK GROUP 2;

B. ALTER DATABASE DROP LOGFILE GROUP 2;

C. ALTER DATABASE CLEAR LOGFILE GROUP 2;

D. ALTER DATABASE RECOVER LOGFILE GROUP 2;

E. ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 2;

Answer: E

Clearing a Redo Log File

If the corrupt redo log file has not been archived, use the UNARCHIVED keyword in the statement.

ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3;

This statement clears the corrupted redo logs and avoids archiving them. The cleared redo logs are available for use even though they were not archived.

转载于:https://www.cnblogs.com/Babylon/p/8623732.html