90. 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;
答案：E
没有归档的日志直接clear是不能清除掉的，须加上unarchived,而且该日志组应该也不能是current和active的
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/11312660/viewspace-718577/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
