多选题You are managing an Oracle Database 11g database running in ARCHIVELOG mode. The FlashRecovery Area is specified as the destination for the archived redo log files. You notice this warning in thealert log file： ORA-19815： WARNING:// db_recovery_file_dest_size of 3221225472 bytes is 100.00% used， and has 0remaining bytes available. What would you do to reclaim the used space in the Flash Recovery Area（）ABack up the Flash Recovery Area.BDecrease the retention time for the database backup and flashback log files.CManually delete all the archived log files from the Flash Recovery Area by using operating system （OS）commands.DManually delete all the expired backup sets from the Flash Recovery Area by using operating system（OS） commands.
多选题
You are managing an Oracle Database 11g database running in ARCHIVELOG mode. The FlashRecovery Area is specified as the destination for the archived redo log files. You notice this warning in thealert log file： ORA-19815： WARNING:// db_recovery_file_dest_size of 3221225472 bytes is 100.00% used， and has 0remaining bytes available. What would you do to reclaim the used space in the Flash Recovery Area（）
A
Back up the Flash Recovery Area.
B
Decrease the retention time for the database backup and flashback log files.
C
Manually delete all the archived log files from the Flash Recovery Area by using operating system （OS）commands.
D
Manually delete all the expired backup sets from the Flash Recovery Area by using operating system（OS） commands.
参考解析
解析：
暂无解析
相关考题：
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 switchB. You should make a backup of the databaseC. You should switch the database to the NONARCHIVELOG modeD. You should shut down the database instance and perform a complete database recovery
The Oracle Database 11g database is running in the ARCHIVELOG mode. The archived redo log files are stored on three locations. The Flash Recovery Area is one of the locations. The details are given below:Which statement is true regarding what this command accomplishes?（）A. All archived redo log files backed up at least twice to tape are deleted.B. All archived redo log files backed up at least once to tape are eligible for deletion.C. All archived redo log files backed up at least twice to tape are deleted from the flash recovery area.D. All archived redo log files in local archiving destinations and the flash recovery area backed up at least twice to tape are eligible for deletion.
You configured the Flash Recovery Area （FRA） for your database. The database instance is running inARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Area. Which twofiles are removed automatically if the space is required in the FRA as per the retention policy（）A、Flashback log filesB、Backups that have become obsoleteC、User managed backups of the data files and control filesD、Archived redo log files that have multiple copies in a different archive location and not backed up
You have configured flash recovery area in your database and you set the following Initialization parameters for your database instance： LOG_ARCHIVE_DEST 1 = ，，LOCATION=/disk1/arch MANDATORY’ LOG _ARCHIEVE_DEST 2 = ，，LOCATION=/disk2/arch’ LOG_ARCHIVK_DEST_3 = ，，LOCATION=/diSk3/arch LOG_ARCH1VK_DEST_4 = ’ LOCATION=/disk4/arch’ LOG_ARCHIVE_MIN-SUCCEED_DEST = 2 While the database instance is functional，you realized that the destination set by the LOG_ARCHIVE_DEST_I parameter Is not available for the archived redo log file to be created in. All redo log groups have been used. What happens in an event of log switch？（） A、 The online redo log file Is not allowed to be overwritten.B、 The archived redo log files are written to the flash recovery area until the MANDATORY destination is made available.C、 The database instance will crash because the archived redo log file cannot be created in a destination set as MANDATORY.D、 The destination set by the LOG_ARCHIVE_DEST_1 parameter is ignored and the archived redo log files are created in the next two available locations to guarantee archive log success.
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 switchB、 You should make a backup of the databaseC、 You should switch the database to the NONARCHIVELOG modeD、 You should shut down the database instance and perform a complete database recovery
You want to use the automatic management of backup and recovery operations features for your database.Which configuration must you set?（）A、Enable the flash recovery area and specify it as the archived redo log destination.B、Disable the flash recovery area and start the database instance in ARCHIVELOG mode.C、Enable the flash recovery area but do not specify it as the archived redo log destination.D、Disable the flash recovery area and start the database instance in NOARCHIVELOG mode
You want to use the automatic management of backup and recovery operations features for your database.Which configuration must you set?（）A、Enable the flash recovery area and specify it as the archived redo log destination.B、Disable the flash recovery area and start the database instance in ARCHIVELOG mode.C、Enable the flash recovery area but do not specify it as the archived redo log destination.D、Disable the flash recovery area and start the database instance in NOARCHIVELOG mode.
You are trying to recover your database. During the recovery process， you receive the following error： ORA-00279： change 5033391 generated at 08/17/2008 06：37：40 needed for thread 1ORA-00289： suggestion ： /oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17 /o1_mf_1_11_%u_.arc ORA-00280： change 5033391 for thread 1 is in sequence #11 ORA-00278： log file ，，/oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17 /o1_mf_1_10_4bj6wnqm_.arc no longer needed for this recovery Specify log： {=suggested | filename | AUTO | CANCEL} ORA-00308： cannot open archived log ，，/oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17 /o1_mf_1_11_%u_.arc ORA-27037： unable to obtain file status Linux Error： 2： No such file or directory Additional information： 3 How do you respond to this error？（）A、 Restore the archived redo log that is missing and attempt recovery again.B、 Recovery is complete and you can open the database.C、 Recovery needs redo that is not available in any archived redo log. Attempt to apply an online redo log if available.D、 Recover the entire database and apply all archived redo logs again.E、 Recovery is not possible because an archived redo log has been lost.
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.
You database is running an ARCHIVELOG mode. The following parameter are set in your database instance: LOG_ARCHIVE_FORMAT = arch+%t_%r.arc LOG_ARCHIVE_DEST_1 = ‘LOCATION = /disk1/archive’ DB_RECOVERY_FILE_DEST_SIZE = 50G DB_RECOVERY_FILE = ‘/u01/oradata’ Which statement is true about the archived redo log files?（）A、They are created only in the location specified by the LOG_ARCHIVE_DEST_1 parameter.B、They are created only in the Fast Recovery Area.C、They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and in the default location $ORACLE_HOME/dbs/arch.D、They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the location specified by the DB_RECOVERY_FILE_DEST parameter.
You configured the Flash Recovery Area （FRA） for your database. The database instance is runningin ARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Area. Which two files are removed automaticallyif the space is required in the FRA as per the retention policy（）A、flashback log filesB、backups that have become obsoleteC、copies of the data files and control filesD、archived redo log files that have multiple copies in a different archive location and not backed up
In your production database， you have observed that the database server performance degrades whenever there is a switch between the log groups. On further investigation， you find that the database is running in ARCHIVELOG mode and the archived log files are being written to the same disk that is used to store the redo log members. Which two actions would you take to improve the performance of the database server？ （）A、increase the size of the redo log bufferB、increase the number of redo log groupsC、increase the number of log writer processesD、increase the number of ARCn processesE、change the appropriate LOG_ARCHIVE_DEST_n parameter to place the archived log files in a separate location
Your database is functioning in ARCHIVELOG mode. In which two situations would you perform a cancel/x7fbased recovery？（）A、You find that one of the redo log members in each redo log group is lost.B、You find that a data file that belongs to the USERS tablespace is damaged.C、You find that a data file that belongs to the SYSTEM tablespace is damaged.D、You find that the current redo log group is damaged and is not available for recovery.E、You realized while performing a recovery that an archived redo log file needed for recovery is lost.
You are working as a DBA on Oracle Database 9i. You plan to upgrade your 9i database to Oracle 10g. To be familiar with the new database technology， you decide to install Oracle Database 10g on your workstation at home. You create a general purpose database. After the installation， you make the following changes in your initialization parameter file：LOG_ARCHIVE_DEST_1=’LOCATION=USE_DB_RECOVERY_FILE_DEST’ DB_RECOVERY_FILE_DEST = ’LOCATION=d：/product/10.1.0/flash_recovery_area’ DB_RECOVERY_FILE_DEST_SIZE=10g Where are the archived redo logs stored for your database？（）A、 The archived redo logs are stored in an operating system-dependent location.B、 The archived redo logs are stored in the location specified by LOG_ARCHIVE_DEST_1.C、 The archived redo logs are stored in the location specified by DB_RECOVERY_FILE_DEST.D、 The archived redo logs are stored in the locations specified by both LOG_ARCHIVE_DEST_1 and DB_RECOVERY_FILE_DEST.
While performing the backup of the flash recovery area, you notice that one of the archived redo log files is missing. You have multiple destinations for archived redo log files. What implications does it have on the backup of the flash recovery area?（）A、The backup fails because one of the archived redo log files is missing. B、The backup succeeds but it would be without the missing archived log. C、During backup, you are prompted for the alternative destination for the missing archived redo log file. D、The backup succeeds because it fails over to one of the alternative archived redo log destinations.
You are working on Oracle Database 10g， which is in ARCHIVELOG mode. All the archived log files are intact. In which scenario would performing a recovery require the opening of the database with the RESETLOGS option？（）A、 loss of one of the tablespacesB、 loss of a system data fileC、 loss of one of the control filesD、 loss of a tempfileE、 loss of the only member of an unarchived redo log groupF、 loss of a member from each redo log group
You configured the Flash Recovery Area for your database. The database instance has been startedin ARCHIVELOG mode and the LOG_ARCHIVE_DEST_1 parameter is not set. What will be the implications on the 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 FlashRecovery Area implicitly.D、Archiving will be enabled and the location for the archive redo log file will be created in the defaultlocation $ORACLE_HOME/log.
多选题In your production database， you have observed that the database server performance degrades whenever there is a switch between the log groups. On further investigation， you find that the database is running in ARCHIVELOG mode and the archived log files are being written to the same disk that is used to store the redo log members. Which two actions would you take to improve the performance of the database server？ （）Aincrease the size of the redo log bufferBincrease the number of redo log groupsCincrease the number of log writer processesDincrease the number of ARCn processesEchange the appropriate LOG_ARCHIVE_DEST_n parameter to place the archived log files in a separate location
多选题You configured the Flash Recovery Area （FRA） for your database. The database instance is running inARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Area. Which twofiles are removed automatically if the space is required in the FRA as per the retention policy（）AFlashback log filesBBackups that have become obsoleteCUser managed backups of the data files and control filesDArchived redo log files that have multiple copies in a different archive location and not backed up
多选题You configured the Flash Recovery Area （FRA） for your database. The database instance is runningin ARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Area. Which two files are removed automaticallyif the space is required in the FRA as per the retention policy（）Aflashback log filesBbackups that have become obsoleteCcopies of the data files and control filesDarchived redo log files that have multiple copies in a different archive location and not backed up
多选题You are trying to recover your database. During the recovery process， you receive the following error： ORA-00279： change 5033391 generated at 08/17/2008 06：37：40 needed for thread 1ORA-00289： suggestion ： /oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17 /o1_mf_1_11_%u_.arc ORA-00280： change 5033391 for thread 1 is in sequence #11 ORA-00278： log file ，，/oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17 /o1_mf_1_10_4bj6wnqm_.arc no longer needed for this recovery Specify log： {=suggested | filename | AUTO | CANCEL} ORA-00308： cannot open archived log ，，/oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17 /o1_mf_1_11_%u_.arc ORA-27037： unable to obtain file status Linux Error： 2： No such file or directory Additional information： 3 How do you respond to this error？（）ARestore the archived redo log that is missing and attempt recovery again.BRecovery is complete and you can open the database.CRecovery needs redo that is not available in any archived redo log. Attempt to apply an online redo log if available.DRecover the entire database and apply all archived redo logs again.ERecovery is not possible because an archived redo log has been lost.
单选题The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. Oneof 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?（）AYou should perform a log switchBYou should make a backup of the databaseCYou should switch the database to the NONARCHIVELOG modeDYou should shut down the database instance and perform a complete database recovery
单选题While performing the backup of the flash recovery area, you notice that one of the archived redo log files is missing. You have multiple destinations for archived redo log files. What implications does it have on the backup of the flash recovery area?（）AThe backup fails because one of the archived redo log files is missing. BThe backup succeeds but it would be without the missing archived log. CDuring backup, you are prompted for the alternative destination for the missing archived redo log file. DThe backup succeeds because it fails over to one of the alternative archived redo log destinations.
单选题You database is running an ARCHIVELOG mode. The following parameter are set in your database instance: LOG_ARCHIVE_FORMAT = arch+%t_%r.arc LOG_ARCHIVE_DEST_1 = ‘LOCATION = /disk1/archive’ DB_RECOVERY_FILE_DEST_SIZE = 50G DB_RECOVERY_FILE = ‘/u01/oradata’ Which statement is true about the archived redo log files?（）AThey are created only in the location specified by the LOG_ARCHIVE_DEST_1 parameter.BThey are created only in the Fast Recovery Area.CThey are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and in the default location $ORACLE_HOME/dbs/arch.DThey are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the location specified by the DB_RECOVERY_FILE_DEST parameter.
单选题You are working on Oracle Database 10g， which is in ARCHIVELOG mode. All the archived log files are intact. In which scenario would performing a recovery require the opening of the database with the RESETLOGS option？（）Aloss of a tempfileBloss of a system data fileCloss of one of the control filesDloss of one of the tablespacesEloss of a member from each redo log groupFloss of the only member of an unarchived redo log group
单选题You want to use the automatic management of backup and recovery operations features for your database. Which configuration must you set？（）A Enable the flash recovery area and specify it as the archived redo log destination.B Disable the flash recovery area and start the database instance in ARCHIVELOG mode.C Enable the flash recovery area but do not specify it as the archived redo log destination. D Disable the flash recovery area and start the database instance in NOARCHIVELOG mode.
多选题You are managing an Oracle Database 11g database running in ARCHIVELOG mode. The FlashRecovery Area is specified as the destination for the archived redo log files. You notice this warning in thealert log file： ORA-19815： WARNING:// db_recovery_file_dest_size of 3221225472 bytes is 100.00% used， and has 0remaining bytes available. What would you do to reclaim the used space in the Flash Recovery Area（）ABack up the Flash Recovery Area.BDecrease the retention time for the database backup and flashback log files.CManually delete all the archived log files from the Flash Recovery Area by using operating system （OS）commands.DManually delete all the expired backup sets from the Flash Recovery Area by using operating system（OS） commands.
单选题The Oracle Database 11g database is running in the ARCHIVELOG mode. The archived redo log files are stored on three locations. The Flash Recovery Area is one of the locations. The details are given below： LOG_ARCHIVE_DEST_1 = ’LOCATION = /disk1/archive’ LOG_ARCHIVE_DEST_2 = ’SERVICE = stdb1’ DB_RECOVERY_FILE_DEST = ’/u01/oradata’ Examine the following RMAN command issued to set the deletion policy for archived log files： RMAN CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO sbt； Which statement is true regarding what this command accomplishes？（）A All archived redo log files backed up at least twice to tape are deleted.B All archived redo log files backed up at least once to tape are eligible for deletion.C All archived redo log files backed up at least twice to tape are deleted from the flash recovery area.D All archived redo log files in local archiving destinations and the flash recovery area backed up at least twice to tape are eligible for deletion.