Which three features are provided by Recovery Manager and NOT provided by user-managed backup and recovery？（）A、Online backups.B、Skipping unused block. C、Partial database backups.D、Incremental block-level backup.E、Detection of corrupted blocks during backup.
Which three features are provided by Recovery Manager and NOT provided by user-managed backup and recovery？（）
- A、Online backups.
- B、Skipping unused block.
- C、Partial database backups.
- D、Incremental block-level backup.
- E、Detection of corrupted blocks during backup.
相关考题：
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 corrupted-The 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 normallyB. Restore the latest whole backup, perform incomplete recovery, and open the database with the RESETLOGS optionC. Restore the latest backups control file, perform complete recovery, and open the database with the RESETLOGS optionD. Restore the latest backup control file, perform incomplete recovery using backup control file, and open the database with the RESETLOG option
You work as a database administrator for Supportcenter.cn. You are using Recovery Manager （RMAN） to perform backups in your databases. Which four backup operations can be performed using RMAN？（）A、A backup of the target database when it is mountedB、A backup of online redo log files when the database is openC、A backup of only used data blocks in the file beingbeingbackup upD、A backup of online， read/write data files when the database is openE、A backup of only those data blocks that have changed since a previous backupF、A backup of online， read/write data files when the database is in the NOMOUNT state.
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
While working on the database， you receive the following error： 01578： ORACLE data block corrupted （file# 6， block # 54） ORA-01110 ： data file 6： ’u01/oracle/oradata/data1.dbf’ You decide to recover the corrupted data block by using the Block Media Recovery feature. Which option is NOT a disadvantage of using block media recovery？（）A、 Block Media Recovery must be used with RMAN.B、 You must perform complete recovery of individual blocks.C、 You must have a full RMAN backup， not an incremental backup.D、 You must use the DBVERIFY utility before using the Block Media Recovery feature.
Management has decided that the database must be available 24 hours a day， 7 days a week. Given this requirement， which type of backup is required？（）A、user-managed backups.B、partial database backups.C、consistent database backups.D、inconsistent database backups.
You execute the following Recovery Manager （RMAN） commands in he following order： BACKUP VALIDATE DATABAE RECOVER CORRUPTION LIST； Which two tasks are performed by these commands？（） A、 Repair the corrupted blocks. If any. In the backup createdB、 Populate VSCOPV_CORRUPTION with names of files that have corrupted blocksC、 Back up the database after checking whether array of the files have corrupted blocksD、 Discover any corrupt blocks that are viewable with the VSDATABASE_BI-OCK_CORBUPTION viewE、 Repair all corrupted blocks that have been logged in the VSDATABASE_BLOCK_ CORRUPTION
You performed an incremental level 0 backup of a database: RMAN BACKUP INCREMENTAL LEVEL 0 DATABASE; To enable block change tracking after the incremental level 0 backup, you issued this command: SQL ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE ‘ /mydir/rman_change_track.f’; To perform an incremental level 1 cumulative backup, you issued this command: RMAN BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE; Which three statements are true?（）A、Backup change tracking will sometimes reduce I/O performed during cumulative incremental backups.B、The change tracking file must always be backed up when you perform a full database backup.C、Block change tracking will always reduce I/O performed during cumulative incremental backups.D、More than one database block may be read by an incremental backup for a change made to a single block.E、The incremental level 1 backup that immediately follows the enabling of block change tracking will not read the change tracking file to discover changed blocks.
On which three can you use Recovery Manager （RMAN） to perform incremental backup？（）A、data filesB、control filesC、tablespacesD、password fileE、parameter fileF、whole databaseG、flashback log fileH、archived log filesI、change tracking file
Which of the following statement is incorrect regarding RMAN？（）A、It detects corrupt blocks.B、It performs only offline database backups.C、It omits empty blocks during backups.D、It performs tablespace point-in-time recovery （TSPITR）.
Which two are characteristics of user-managed backup and recovery operations？（）A、Recovery is initiated using SQL*Plus.B、Database files are backed up using SQL commands.C、Database files are backed up with Recovery Manager.D、Database files are restored using Recovery Manager.E、Database files are backed up using operating system commands.
Which files are required for a full recovery of the database in ARCHIVELOG mode？（）A、 Database datafilesB、 Online redo logsC、 Archived redo logsD、 Backup control fileE、 Control file from a backup
You work as a database administrator for Certkiller .com. According to your backup strategy， you performed an incremental level 0 backup of your database. Which statement regarding this backup is true？（）A、The backup is similar to image copy.B、The backup contains all used data blocks.C、The backup contains only unused data blocks.D、The backup contains all data blocks changed since the last incremental level 1 backup.
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.
Which two statements are true about Block Media Recovery （BMR）？（）A、 BMR increases the Mean Time To Recover （MTTR）.B、 BMR can only be implemented using Recovery Manager （RMAN）.C、 The blocks that need to be recovered are accessible during BMR.D、 BMR cannot be performed using cumulative incremental backups.E、 The datafile must be restored if most of the blocks in the datafile are corrupt.
For an incomplete recovery， which four backup types can be used by Recovery Manager （RMAN） to restore data files？（）A、 RMAN image copies.B、 RMAN database backups.C、 RMAN tablespace backups.D、 User-managed backups placed in the flash recovery area.E、 User-managed backups that have been cataloged with RMAN.F、 User-managed data file backups for which the pull path name is specified.
As a result of a media failure， the current online redo log group is corrupted. The database crashes， as the current online group is inaccessible. Which type of incomplete recovery are you most likely to perform？ （）A、Cancel-basedB、Recovery using a backup control fileC、Time-basedD、Change-based
What are the two advantages of RMAN Block Media Recovery （BMR） over file-level recovery？（）A、 BMR lowers the mean time to recover （MTTR）.B、 BMR supports point-in-time recovery of individual data blocks.C、 BMR enables you to use incremental backups for block recovery.D、 BMR enables recovery even when the database is not mounted or open.E、 BMR enables you to use proxy backups to perform block media recovery.F、 BMR enables increased availability of data during recovery because the data file requires a recovery can remain online.
According to your backup strategy， you performed an incremental level 0 backup of your database. Which statement regarding this backup is true？（）A、The backup is similar to image copy.B、The backup contains all used data blocks.C、The backup contains only unused data blocks.D、The backup contains all data blocks changed since the last incremental level 1 backup.
多选题You work as a database administrator for Supportcenter.cn. You are using Recovery Manager （RMAN） to perform backups in your databases. Which four backup operations can be performed using RMAN？（）AA backup of the target database when it is mountedBA backup of online redo log files when the database is openCA backup of only used data blocks in the file beingbeingbackup upDA backup of online， read/write data files when the database is openEA backup of only those data blocks that have changed since a previous backupFA backup of online， read/write data files when the database is in the NOMOUNT state.
多选题Which two statements are true about Block Media Recovery （BMR）？（）ABMR increases the Mean Time To Recover （MTTR）.BBMR can only be implemented using Recovery Manager （RMAN）.CThe blocks that need to be recovered are accessible during BMR.DBMR cannot be performed using cumulative incremental backups.EThe datafile must be restored if most of the blocks in the datafile are corrupt.
单选题As a result of a media failure， the current online redo log group is corrupted. The database crashes， as the current online group is inaccessible. Which type of incomplete recovery are you most likely to perform？ （）ACancel-basedBRecovery using a backup control fileCTime-basedDChange-based
单选题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 corrupted -The 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?（）ARestore the latest whole backup, perform complete recovery, and open the database normallyBRestore the latest whole backup, perform incomplete recovery, and open the database with the RESETLOGS optionCRestore the latest backups control file, perform complete recovery, and open the database with the RESETLOGS optionDRestore the latest backup control file, perform incomplete recovery using backup control file, and open the database with the RESETLOG option
多选题On which three can you use Recovery Manager （RMAN） to perform incremental backup？（）Adata filesBcontrol filesCtablespacesDpassword fileEparameter fileFwhole databaseGflashback log fileHarchived log filesIchange tracking file
多选题Which three features are provided by Recovery Manager and NOT provided by user-managed backup and recovery？（）AOnline backups.BSkipping unused block.CPartial database backups.DIncremental block-level backup.EDetection of corrupted blocks during backup.
单选题According to your backup strategy， you performed an incremental level 0 backup of your database. Which statement regarding this backup is true？（）AThe backup is similar to image copy.BThe backup contains all used data blocks.CThe backup contains only unused data blocks.DThe backup contains all data blocks changed since the last incremental level 1 backup.
单选题You work as a database administrator for Certkiller .com. According to your backup strategy， you performed an incremental level 0 backup of your database. Which statement regarding this backup is true？（）AThe backup is similar to image copy.BThe backup contains all used data blocks.CThe backup contains only unused data blocks.DThe backup contains all data blocks changed since the last incremental level 1 backup.
多选题What are the two advantages of RMAN Block Media Recovery （BMR） over file-level recovery？（）ABMR lowers the mean time to recover （MTTR）.BBMR supports point-in-time recovery of individual data blocks.CBMR enables you to use incremental backups for block recovery.DBMR enables recovery even when the database is not mounted or open.EBMR enables you to use proxy backups to perform block media recovery.FBMR enables increased availability of data during recovery because the data file requires a recovery can remain online.