OCP 11G认证考试
单选题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?（
题目
The backup fails because one of the archived redo log files is missing.
The backup succeeds but it would be without the missing archived log.
During backup, you are prompted for the alternative destination for the missing archived redo log file.
The backup succeeds because it fails over to one of the alternative archived redo log destinations.
相似问题和答案
第1题：
A. Alert log file
B. Archived redo log files
C. Control file autobackups
D. Server Parameter file (SPFILE)
E. Recovery Manager (RMAN) backup piece
第2题：
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.
正确答案:D
第3题：
A. Alert log file
B. Archived redo log files
C. Control file autobackups
D. Server Parameter file (SPFILE)
E. Recovery Manager (RMAN) backup piece
第4题：
You have configured the flash recovery area to store online redo log files， control files， archived redo logs and RMAN backups. Which of the following files can you successfully delete from the flash recovery area if you want to reclaim the space within it？（）
- A、 multiplexed control files
- B、 RMAN obsolete backups
- C、 multiplexed online redo log files
- D、 archived redo logs that have not been copied to tape
正确答案:B
第5题：
You are using the flash recovery area (fast recovery area in 11g Release 2) to store backup related files in your database. After regular monitoring of space usage in the Mash recovery area. You realize that the flash recovery area is jetting filled up very fast and it is running out of space. Your database flash recovery area is low on space and you have no more room on disk. Proactively, which two options could you use to make more space available in the flash recovery？（）
- A、Change the RMAN archived log deletion policy
- B、Use the RMAN CROSSCHECK command to reclaim the archived log space
- C、Change the RMAN retention policy to retain backups for a shorter period of time
- D、Use OS command to move files from the flash recovery area to some other location
正确答案:B,D
第6题：
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 files
- B、Backups that have become obsolete
- C、User managed backups of the data files and control files
- D、Archived redo log files that have multiple copies in a different archive location and not backed up
正确答案:A,B
第7题：
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
正确答案:A
第8题：
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.
第9题：
You are using recovery Manager (RMAN) with a recovery catalog to backup up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. The database was open and transactions were recorded in the redo logs. Because of fire in the building you lost your servers having the production database and the recovery catalog database. The archive log files generated after the last backup are intact on one of the remote locations. While performing a disaster recovery of the production database what is the next step that you must perform after restoring the data files and applying archived redo logs?（）
- A、Open the database in NORMAL mode
- B、Open the database in read-only mode
- C、Open the database in RESTRICTED mode
- D、Open the database with the RESETLOGS option
正确答案:D
第10题：
Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11g Release 2)?（） (Choose three.)
- A、Alert log file
- B、Archived redo log files
- C、Control file autobackups
- D、Server Parameter file (SPFILE)
- E、Recovery Manager (RMAN) backup piece
正确答案:B,C,E