单选题A redo log file is corrupted while the database is open； as a consequence， database operations are stopped because archiving cannot continue. What would you do to solve the problem？（）A  clear the redo log groupB  perform redo log file importC  perform 

第1题：

Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains one redo member. When you attempt to start the database, you receive the following errors: ORA-00313: open failed for members of log group 1 of thread 1 ORA-00312: online log 1 thread 1: 'D:/REDO01.LOG' You discover that the online redo log file of the current redo group is corrupted. Which statement should you use to resolve this issue?（）

• A、ALTER DATABASE DROP LOGFILE GROUP 1;
• B、ALTER DATABASE CLEAR LOGFILE GROUP 1;
• C、ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;
• D、ALTER DATABASE DROP LOGFILE MEMBER 'D:/REDO01.LOG

第2题：

The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. One of the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file：   ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3；   Which action should you perform immediately after using this command？（）  

• A、 You should perform a log switch
• B、 You should make a backup of the database
• C、 You should switch the database to the NONARCHIVELOG mode
• D、 You should shut down the database instance and perform a complete database recovery

第3题：

第4题：

A redo log file is corrupted while the database is open； as a consequence， database operations are stopped because archiving cannot continue. What would you do to solve the problem？（）

• A、 clear the redo log group
• B、 perform redo log file import
• C、 perform an incomplete recovery
• D、 perform a redo log recovery using Recovery Manager （RMAN）
• E、 shut down the database and open the database in the NOARCHIVELOG mode

第5题：

Because of hardware failure， you decided to drop a redo log member from the database. Which condition should be met to drop a redo log file？（）

• A、 The redo log file should belong to an active group.
• B、 The redo log file should belong to an inactive group.
• C、 The redo log file should belong to the current group.
• D、 The redo log file can be dropped only if all the transactions are stopped.
• E、 Before a redo log file is dropped， it should be deleted from the operating system （OS）.

第6题：

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.

第7题：

You configured the Flash Recovery Area for your database. The database instance has been started inARCHIVELOG mode and the LOG_ARCHIVE_DEST_1 parameter is not set. What will be the implications onthe archiving and the location of archive redo log files（）

• A、Archiving will be disabled because the destination for the redo log files is missing.
• B、The database instance will shut down and the error details will be logged in the alert log file.
• C、Archiving will be enabled and the destination for the archived redo log file will be set to the Flash RecoveryArea implicitly.
• D、Archiving will be enabled and the location for the archive redo log file will be created in the default location$ORACLE_HOME/log.

第8题：

第9题：

Which statement about recovering from the loss of a redo log group is true?（）

• A、If the lost redo log group is ACTIVE, you should first attempt to clear the log file.
• B、If the lost redo log group is CURRENT, you must clear the log file.
• C、If the lost redo log group is ACTIVE, you must restore, perform cancel-based incomplete recovery, and open the database using the RESETLOGS option.
• D、If the lost redo log group is CURRENT, you must restore, perform cancel-based incomplete recovery, and open the database using the RESETLOGS option.

第10题：

Examine the following scenario：   -Database is running in ARCHIVELOG mode.  -Complete consistent backup is taken every Sunday.  -On Tuesday the instance terminates abnormally because the disk on which control files are located gets corruptedThe disk having active online redo log files is also corrupted.  The hardware is repaired and the paths for online redo log files and control files are still valid.  Which option would you use to perform the recovery of database till the point of failure？（）  

• A、 Restore the latest whole backup，perform complete recovery，and open the database normally 
• B、 Restore the latest whole backup，perform incomplete recovery，and open the database with the  RESETLOGS option.
• C、 Restore the latest backups control file，perform complete recovery，and open the database with the RESETLOGS option.
• D、 Restore the latest backup control file，perform incomplete recovery using backup control file，and open the database with the RESETLOG option.