A. The MANDATORY location must be a flash recovery area……

多项选择题Your database is running In ARCIIIVELOG mode. One of the data files， USBRDATAOI. DBF， in the users tablespace is damaged and you need to recover the file until the point of failure. The backup for the data file is available.  Which three files would be used in the user-managed recovery process performed by the database administrator （DBA）？（）

A. redo logs
B. control file
C. temporary files of temporary tablespace
D. the latest backup of only the damaged data file
E. the latest backup of all the data files In the USERS tablespace

单项选择题You configured the default backup device type as disk for RMAN backups. In your database，because of business requirements，you have to take a simultaneous duplicate backup of the data files when the RMAN BACKUP command is used.  What must you set using the RMAN CONFIGURE command to achieve this？（）

A. MAXSETSIZE TO 2
B. DEVICE TYPE DISK PARALLELISM 2
C. RETENTION POLICY TO REDUNDANCY 2
D. DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2

单项选择题You are using Recovery Manager （RMAN） with a recovery catalog to back up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. Because of media failure， you lost your production database completely along with the recovery catalog database. You want to recover the target database and make it functional. You could consider performing the following steps to accomplish this task：   1） Restore an autobackup of the server parameter file.  2） Restore the control file.  3） Start the target database Instance.  4） Mount the database. 5） Restore the data files.  6） Open the database with the RESETLOGS option.  7） Recover the data files.  8） Set DBID for the target database   Which option illustrates the correct sequence that you must use？（）

A. 8， 1， 3， 2， 4， 5， 7， 6
B. 1， 8， 3， 4， 2， 5， 7， 6
C. 1， 3， 4， 2， 8， 5， 6， 7
D. 1， 3， 2， 4， 6， 5， 7， 8

多项选择题Identitytwoadvantagesofusingarecoverycatalogin-loadofthecontrolFileofthetargetdatabaseRecoveryManager（RMAN）.（）

A. You can use RMAN stored scripts.
B. Recovery is faster if data is stored in catalog in addition to the control file.
C. You can store backup Information of all registered databases in one place.
D. Database backups are automatically deleted when they are older than the specified time period.

单项选择题A database is running In ARCHIVBXXMS mode. It has two online redo log groups and each group has one member.  A LGWR Input output （I O） fells due to permanent media failure that has resulted In the loss of redo log file and the LWGR terminates causing the instance to crash. The steps to recover from the loss of a current redo log group member in the random order are as follow.   1） Restore the corrupted redo log group. 2） Restore from a whole database backup.  3） Perform incomplete recovery.  4） Relocate by renaming the member of the damaged online redo log group to a new location.  5） Open the database with the RESETLOGS option.  6） Restart the database instance.  7） Issue a checkpoint and clear the log.   Identify the option with the correct sequential steps to accomplish the task efficiently（）.

A. 1，3，4，and 5
B. 7，3，4. and 5
C. 2，3，4，and 5
D. 7，4，3，and 5
E. Only 6 is required