单项选择题

You executed the following command in Recovery Manager ……

You executed the following command in Recovery Manager （RMAN）：
RMAN> REPORT NEED BACKUP days 3；
What is the output of this command？（）

A. a list of files that require a backup within three days
B. a list of files requiring more than 3 days of archive logs to apply
C. a list of files that RMAN recommends be backed up only once in every three days，based on low volatility
D. a list of files for which a backup has already been performed in the last three days and which is required to be backed up again based on the high number of transactions performed on them

<上一题目录下一题>

热门试题

多项选择题WhichofthefollowingcannotbeusedasinputtotheSQLTuningAdvisor？（）

A. A single SQL statement provided by a user
B. An existing SQL Tuning Set （STS）
C. A preprocessed Database Replay workload
D. A schema name
E. SQL statement identified in EM as using excessive resources

单项选择题You want to set the following Initialization parameters for your database Instance LOG_ARCHIVE_DEBT_1 = ，，LOCATION= disk1 arch LOG_ARCHIVE_DBST_2 = ，，LOCATION= disk2 arch LOC_ARCHIVB DBST_3 = ，，LOCATION= disk3 arch LOG_ARCHIVE DBST_ = ，，LOCATION= disk3 arch Identify the statement that correctly describes this setting.（）

A. The MANDATORY location must be a flash recovery area.
B. The optional destinations may not use the flash recovery area.
C. This setting is not allowed because the first destination is not set as MANDATORY.
D. The online redo log file is not allowed to be overwritten if the archived log cannot be created in the fourth destination.

多项选择题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