Oracle OCP 1Z0 053 Q178(Redo Log Corruption)

178.If a log file becomes corrupted, it may cause the database to stall. 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.
Answer: C


redo log衝突時，只要clear logfile即可，不需要進行恢復

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/8520577/viewspace-2075034/，如需轉載，請註明出處，否則將追究法律責任。