How would you correct such a situation?
A. Recover the online redo log from backup.
B. Delete and re-create the log file.
C. Use the alter database clear logfile command to clear the log file.
D. Shut down the database and restart it.
E. Shut down the database and then mount it.Clear the log file with the alter database clear logfile command and then restart the database with alter database open resetlogs.
答案:(C)
解析:
C,实例并未崩溃,脏块没有丢失。把损坏的日志组clear掉,自动重建。
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/17013648/viewspace-1259864/ ,如需转载,请注明出处,否则将追究法律责任。