单项选择题
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.
相关考题
-
单项选择题
Whenyoucreateabackupcontrolfile，whereistheresultingfilewrittento？（）
A. The database user dump destination directory
B. The database diagnostic destination directory
C. To $ORACLE_HOME/rdbms
D. To $ORACLE_HOME/admin
E. To the directory and filename you specify in the command -
单项选择题
WhichofthefollowingstatementsistruewhenthedatabaseisinARCHIVELOGmodeand tablespacesareinhotbackupmode？（）
A. Archive log generation is suspended until the tablespaces are taken out of hot backup mode.
B. Datafiles are not written to during hot backups.
C. Changes to the database are cached during the backup and not written to the datafiles to ensure that the datafiles are consistent when recovered.
D. The datafile headers are not updated during the backup.
E. The way data is written to the online redo logs is unchanged during the backup. -
单项选择题
You are peer reviewing a fellow DBAs backup plan for his NOARCHIVELOG mode database， as shown here： Put the tablespaces in backup mode. Back up the datafiles for all tablespaces. Take the tablespaces out of backup mode. Back up all archived redo logs. Your colleague asks for you to comment on his plan. Which response would be correct？（）
A. The plan will work as is.
B. The plan needs to be modified to allow for an archive-log switch after step 3.
C. The plan needs to be modified so that a backup of the archived redo logs occurs before step 1.
D. The plan needs to be adjusted to shut down the database after step 1 and to restart the database after step 2.
E. The plan cannot work as presented.
