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 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 options must you configure while performing an automated Tablespace Point-in-Time Recovery (TSPITR) by using Recovery Manager (RMAN)?() A. New channels for restore and recovery tasksB. New name for the data files of the tablespaceC. Auxiliary name for the data files of the tablespaceD. Auxiliary destinations for an auxiliary set of data files

You enable block change tracking. You issue the following command: BACKUP INCREMENTAL LEVEL 0 DATABASE;The next day, you issue the following command:BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;Which statement about the use of the change tracking file is true?()A. RMAN reads the block change tracking file only when it performs the incremental level 0 backup.B. RMAN reads the block change tracking file when it performs both incremental backups.C. RMAN reads the block change tracking file only when it performs the incremental level 1 backup.D. RMAN does not read the block change tracking file when it performs either incremental backup.

Consider the following scenario for your database:Which statement is true regarding the backup of the TOOLS tablespace?() A. The RMAN backup fails because the TOOLS tablespace is read-onlyB. The RMAN skips the backup of the tablespace because backup optimization is enabledC. The RMAN makes backup because optimization can be enabled only for backups to diskD. The RMAN makes the backup because no backup of the tablespace exists within the seven day window

View the Exhibit to examine the error during the database startup.You open an RMAN session for the database instance. To repair the failure, you executed the following as the first command in the RMAN session:RMAN REPAIR FAILURE;Which statement describes the consequence of the command?()A. The command performs the recovery and closes the failures.B. The command only displays the advice and the RMAN script required for repair.C. The command produces an error because the ADVISE FAILURE command has not been executed before the REPAIR FAILURE command.D. The command executes the RMAN script to repair the failure and removes the entry from the Automatic Diagnostic Repository (ADR).

Consider the following scenario for your database:- Backup optimization is enabled in RMAN.- The recovery window is set to 7 days in RMAN.- The most recent backup to disk for the TOOLS tablespace was taken on November 3, 2007.- The TOOLS tablespace is read-only since November 4, 2007.On November 23, 2007, you issue the RMAN command to back up the database to disk.Which statement is true regarding the backup of the TOOLS tablespace?()A. The RMAN backup fails because the TOOLS tablespace is read-onlyB. The RMAN skips the backup of the tablespace because backup optimization is enabledC. The RMAN makes backup because optimization can be enabled only for backups to diskD. The RMAN makes the backup because no backup of the tablespace exists within the seven day window

Which of the following is not an advantage of block media recovery (BMR)?()A、 Reduced MTTR.B、 Datafiles remain offline while corrupt blocks are repaired.C、 Datafiles remain online while corrupt blocks are repaired.D、 A and C

tablespace point-in-time recovery is possible only with RMAN.()A、 TrueB、 False

Consider the following scenario for your database: - Backup optimization is enabled in RMAN. - The recovery window is set to 7 days in RMAN. - The most recent backup to disk for the TOOLS tablespace was taken on November 3, 2007. - The TOOLS tablespace is read-only since November 4, 2007. On November 23, 2007, you issue the RMAN command to back up the database to disk. Which statement is true regarding the backup of the TOOLS tablespace?()A、The RMAN backup fails because the TOOLS tablespace is read-onlyB、The RMAN skips the backup of the tablespace because backup optimization is enabledC、The RMAN makes backup because optimization can be enabled only for backups to diskD、The RMAN makes the backup because no backup of the tablespace exists within the seven day window

To perform a database point-in-time recovery using RMAN, after database restoration, you must ensure that the database is in which of the following states?()A、OPENB、MOUNTC、NOMOUNTD、CLOSE

Which options must you configure while performing an automated Tablespace Point-in-Time Recovery(TSPITR) by using Recovery Manager (RMAN)?()A、New channels for restore and recovery tasksB、New name for the data files of the tablespaceC、Auxiliary name for the data files of the tablespaceD、Auxiliary destinations for an auxiliary set of data files

You executed the following command in Recovery Manager (RMAN) to perform a backup of the DETTBS tablespace: RMAN BACKUP TABLESPACE DETTBS;  Under which conditions would this command execute successfully? ()A、 The database is in NOMOUNT state.B、 The database is in NOARCHIVELOG mode and the tablespace is online.C、 The database is in NOARCHIVELOG mode and the tablespace is offline.D、 The database is in ARCHIVELOG mode and the tablespace is offline.E、 The database is in ARCHIVELOG mode and the tablespace is online.

In Recovery Manager (RMAN), you have set control file autobackup to ON by using the following command: CONFIGURE CONTROLFILE AUTOBACKUP ON; Which two events would cause the control file to be backed up automatically? ()A、 A tablespace is taken offline.B、 The database instance is restarted.C、 A new data file is added to an existing tablespace.D、 A successful backup is recorded in the RMAN repository.E、 The RMAN connection is disconnected from the target database.

You are performing a block media recovery on the tools01.dbf data file in the SALES database using RMAN. Which two statements are correct in this scenario?()A、 You must ensure that the SALES database is mounted or open.B、 You must restore a backup control file to perform a block media recovery.C、 You must take the tools01.dbf data file offline before you start a block media recovery.D、 You must put the database in NOARCHIVELOG mode to perform a block media recovery.E、 You can perform only a complete media recovery of individual blocks, point-in-time recovery of individual data blocks is not supported.

You execute the following RMAN commands in the order shown below:  BACKUP VALIDATE DATABASE;  BLOCKRECOVER CORRUPTION LIST;  What will these commands do?()A、create a backup of the database and recover all corrupted blocks found in the backupB、run a backup validation and list all the logically corrupt blocks as well as physically corrupt blocks in the databaseC、run a backup validation to populate V$COPY_CORRUPTION view, and then list any corrupt blocks recorded in the viewD、run a backup validation to populate V$DATABASE_BLOCK_CORRUPTION view, and then repair any corrupt blocks recorded in the viewE、run a backup validation, repair any corrupt blocks found during the validation process, and then update V$DATABASE_BLOCK_CORRUPTION view to indicate which corrupt blocks have been repaired

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.

You enable block change tracking. You issue the following command: BACKUP INCREMENTAL LEVEL 0 DATABASE; The next day, you issue the following command: BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE; Which statement about the use of the change tracking file is true?()A、RMAN reads the block change tracking file only when it performs the incremental level 0 backup.B、RMAN reads the block change tracking file when it performs both incremental backups.C、RMAN reads the block change tracking file only when it performs the incremental level 1 backup.D、RMAN does not read the block change tracking file when it performs either incremental backup.

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.

Youre performing tablespace point-in-time recovery on a tablespace called USERS. If an object in that tablespace has a foreign key constraint owned by another object in the INDEX_TBS  which statement is true?()  A、 You cannot perform the TSPITR with the constraints enabled.B、 You must perform the TSPITR recovery of both tablespaces for it to be successful.C、 You can perform TSPITR only on the USERS tablespace.D、 RMAN will determine if the INDEX_TBS tablespace must also be duplicated and will duplicate it automatically.E、 The TSPITR will only be successful if the constraint is enabled.

You execute the following RMAN command in the order shown below: BACKUP VALIDATE DATABASE; BLOCKRECOVER CORRUPTION LIST; What will these commands do?()A、 Create a backup of the database and recover all corrupted blocks found in the backup.B、 Run a backup validation and list all the logically corrupt blocks as well as physically corrupt blocks in the database.C、 Run a backup validation to populate V$COPY_CORRUPTION view, and then list any corrupt blocks recorded in the view.D、 Run a backup validation to populate V$DATABASE_BLOCK_CORRUPTION view, and then repair any corrupt blocks recorded in the view.E、 Run a backup validation, repair any corrupt blocks found during the validation process, and then update V$DATABASE_BLOCK_CORRUPTION view to indicate which corrupt blocks have been repaired.

Users complain SQL statements using a particular index fail. Using DBVERIFY, you find that two separate blocks in the index have become corrupt. The database data files for user data and index are very large.  What is the least disruptive recover strategy available in Oracle9i?()A、Rebuild the index using the online option. B、Take the individual data file offline (not the whole tablespace), restore and recover the data file from backup with RMAN, then set the data file online again. C、Without setting the individual data file offline, use RMAN with Block Media Recovery to restore and recover only those blocks. D、Take the individual data file (not the whole tablespace) offline, use RMAN with Block Media Recovery to restore and recover only those blocks, then set the data file online again.

When running the tablespace point-in-time command   recover tablespace users until time ,,10/06/2008:22:42:00 auxiliary destination ,,c:/oracle/auxiliary; you receive the following error:  RMAN-00571: ===========================================================  RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS  =============== RMAN-00571:  ===========================================================  RMAN-03002: failure of recover command at 10/08/2008 16:00:30  RMAN-20202: Tablespace not found in the recovery catalog  RMAN-06019: could not translate tablespace name "USERS"   What is the likely cause of the error?()A、 The database is in ARCHIVELOG mode.B、 There is not a current backup of the database available.C、 The USERS tablespace has dependent objects in other tablespaces and can not be a part of a TSPITR alone.D、 The USERS tablespace is not eligible for TSPITR because it has invalid objects.E、 The recover tablespace command is incorrect and generates the error.

单选题Which of the following is not an advantage of block media recovery (BMR)?()A Reduced MTTR.B Datafiles remain offline while corrupt blocks are repaired.C Datafiles remain online while corrupt blocks are repaired.D A and C

单选题tablespace point-in-time recovery is possible only with RMAN.()A TrueB False

单选题Which of the following statement is incorrect regarding RMAN?()AIt detects corrupt blocks.BIt performs only offline database backups.CIt omits empty blocks during backups.DIt performs tablespace point-in-time recovery (TSPITR).

多选题You executed the following command in Recovery Manager (RMAN) to perform a backup of the DETTBS tablespace:  RMAN BACKUP TABLESPACE DETTBS;  Under which conditions would this command execute successfully? ()AThe database is in NOMOUNT state.BThe database is in ARCHIVELOG mode and the tablespace is online.CThe database is in ARCHIVELOG mode and the tablespace is offline.DThe database is in NOARCHIVELOG mode and the tablespace is online.EThe database is in NOARCHIVELOG mode and the tablespace is offline.

单选题You enable block change tracking. You issue the following command: BACKUP INCREMENTAL LEVEL 0 DATABASE; The next day, you issue the following command: BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE; Which statement about the use of the change tracking file is true?()ARMAN reads the block change tracking file only when it performs the incremental level 0 backup.BRMAN reads the block change tracking file when it performs both incremental backups.CRMAN reads the block change tracking file only when it performs the incremental level 1 backup.DRMAN does not read the block change tracking file when it performs either incremental backup.