QUESTION NO: 78
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
Explanation:
Clearing a Redo Log File
A redo log file might become corrupted while the database is open, and ultimately stop database activity because archiving cannot continue. In this situation the ALTER DATABASE CLEAR LOGFILE statement can be used to reinitialize the file without shutting down the database.
The following statement clears the log files in redo log group number 3:
ALTER DATABASE CLEAR LOGFILE GROUP 3;来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29555029/viewspace-1612600/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29555029/viewspace-1612600/