You are using Recovery Manager （RMAN) with a recovery catalog to back up your production d

相似题目

• You are using Oracle Database 10g. You performed an incomplete recovery of your database and opened the database with the RESETLOGS option.  What is the effect of opening the database with the RESETLOGS option？ （）

  A . This operation resets the SCN for the database. B . This operation creates a new incarnation of the database. C . This operation moves all the redo log files to a different location. D . This operation deletes the old redo log files and creates new redo log files. E . This operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.

  查看最佳答案

• 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 are using Oracle Database 10g. You performed an incomplete recovery of your database and opened the database with the RESETLOGS option. What is the effect of opening the database with the RESETLOGS option？ （）

  A .  This operation resets the SCN for the database. B .  This operation creates a new incarnation of the database. C .  This operation moves all the redo log files to a different location. D .  This operation deletes the old redo log files and creates new redo log files. E .  This operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.

  查看最佳答案

• You are maintaining the database in Oracle10g. You are performing an incomplete recovery by using RMAN because an important table， EMPLOYEE， is dropped and purged from the Recycle Bin. Which statement is NOT true regarding an incomplete recovery？（）

  A .  The target database must be in the MOUNT mode to ensure restoration of the datafiles. B .  You can restore the datafiles from the backup by using the RMAN utility only if the backups were taken using the RMAN utility. C .  The control file must be recreated. D .  The database must be opened with the RESETLOGS option.

  查看最佳答案

• You are performing a database recovery because a user’s schema is dropped. While performing the recovery， you use the UNTIL SEQUENCE clause. Which type of database recovery are you performing？（）

  A .  user managed complete recovery B .  user managed incomplete recovery C .  RMAN-based complete recovery D .  RMAN-based incomplete recovery

  查看最佳答案

• You are using the control file to maintain information about the database backups that are being performed by Recovery Manager (RMAN). Identify two scenarios is which you must have a recovery catalog.（）

  A . To store the backup information of multiple database B . To restrict the amount of space that is used by the backups C . To maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIME parameter. D . To list the data files that were in a target database at a given time by using the AT option of REPORT SCHEMA command.

  查看最佳答案

• You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup？（）

  A .  online redo log files B .  alert log files C .  control file D .  datafiles associated with the SYSTEM tablespace

  查看最佳答案

• You performed a backup of the flash recovery area by using the following command for the first time： RMAN> BACKUP RECOVERY AREA;  Which files in the flash recovery area are backed up？（）

  A . flashback logs B . current control file C . control file autobackups D . incremental backup set

  查看最佳答案

• You lost the index tablespace in your database. You are not able to use tablespace point-in-time recovery on the index tablespace. What could be the reason for this？（）

  A .  The index tablespace contains bitmap indexes. B .  The index tablespace contains more than one data file. C .  The index tablespace supports only complete recovery. D .  The index tablespace is not a dictionary-managed tablespace. E .  There is a dependency relationship between a table and its indexes.

  查看最佳答案

• You are using Recovery wizard for performing incomplete recovery. Which of the following object types is NOT available in the Perform Recovery ：Type screen？（）

  A .  Whole database B .  Tablespaces C .  Datafiles D .  Archive logs E .  Redo log

  查看最佳答案

• You are using the control file to maintain information about the database backups that are being performed by Recovery Manager (RMAN).Identify two scenarios is which you must have a recovery catalog. （）(Choose two.)

  A . To store the backup information of multiple database B . To restrict the amount of space that is used by the backups C . To maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIME parameter. D . To list the data files that were in a target database at a given time by using the AT option of REPORT SCHEMA command.

  查看最佳答案

• You are using Recovery Manager (RMAN) to perform backups. In which three situations would you perform a compressed backup?（）

  A . You are backing up to tape and your tape device performs its own compression. B . You are making image copies, and you have not enabled tablespace compression. C . You are using disk-based backups and disk space in your Flash Recovery Area, or other disk-based backup destinations are limited. D . You are performing your backups to some device over a network where reduced network bandwidth is more important than CPU usage. E . You are using some archival backup media, such as CD or DVD, where reducing backup sizes saves media costs and archival storage.

  查看最佳答案

• 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 mounted B . A backup of online redo log files when the database is open C . A backup of only used data blocks in the file beingbeingbackup up D . A backup of online， read/write data files when the database is open E . A backup of only those data blocks that have changed since a previous backup F . A backup of online， read/write data files when the database is in the NOMOUNT state.

  查看最佳答案

• What RMAN command must you use before you can back up a database using the recovery catalog？（）

  A .  create catalog B .  install database C .  catalog database D .  merge Catalog with database E .  register database

  查看最佳答案

• You need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN).Which two are the prerequisites to perform this operation？（）

  A . You must configure block change tracking file B . You must have first level 1 backups for RMAN to restore blocks C . You must ensure that the SALES database is mounted or open D . You must have full or level 0 backups for RMAN to restore blocks E . You must take the tools01.dbf data file offline before you start a block media recovery

  查看最佳答案

• Identify two situations in which you can use Data Recovery Advisor for recovery.（） 

  A .  The user has dropped an important table that needs to be recovered. B .  The database files are corrupted when the database is open. C .  You are not able to start up the database instance because the required database files are missing. D .  The archived log files are missing for which backup is not available.

  查看最佳答案

• You use a recovery catalog for maintaining your database backups.You execute the following command:$rman TARGET / CATALOG rman / cat@catdbRMAN > BACKUP VALIDATE DATABASE ARCHIVELOG ALL;Which two statements are true?（）

  A . Corrupted blocks, if any, are repaired. B . Checks are performed for physical corruptions. C . Checks are performed for logical corruptions. D . Checks are performed to confirm whether all database files exist in correct locations E . Backup sets containing both data files and archive logs are created.

  查看最佳答案

• You are performing a block media recovery on the tools01.dbf data file in the SALES database by 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 need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN). Which two are the prerequisites to perform this operation? （）(Choose two)

  A . You must configure block change tracking file B . You must have first level 1 backups for RMAN to restore blocks C . You must ensure that the SALES database is mounted or open D . You must have full or level 0 backups for RMAN to restore blocks E . You must take the tools01.dbf data file offline before you start a block media recovery

  查看最佳答案

• Identify two situations in which you can use Data Recovery Advisor for recovery. （）(Choose two.)

  A . The user has dropped an important table that needs to be recovered. B . The database files are corrupted when the database is open. C . You are not able to start up the database instance because the required database files are missing. D . The archived log files are missing for which backup is not available.

  查看最佳答案

• Which commands are used for RMAN database recovery？（）

  A .  restore B .  repair C .  copy D .  recover E .  replace

  查看最佳答案

• You are using Oracle Database 10g. You performed an  incomplete recovery of your database and opened the database with the RESETLOGS option.  What is the effect of opening the database with the RESETLOGS option？（）

  A . This operation resets the SCN for the database. B . This operation creates a new incarnation of the database. C . This operation moves all the redo log files to a different location. D . This operation deletes the old redo log files and creates new redo log files. E . This operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.

  查看最佳答案

• You are performing an incomplete recovery because some important tables have been dropped and purged from the Recycle Bin. Which clause can you NOT use to perform the incomplete recovery by using the RMAN utility？（）

  A .  UNTIL CANCEL B .  UNTIL SCN C .  UNTIL SEQUENCE D .  UNTIL TIME

  查看最佳答案

• You are using the Block Media Recovery feature to recover the blocks that are marked corrupt since the last backup. Which view will you query to display information about the data blocks that are marked corrupt since the last backup？（）

  A .  V$BACKUP_CORRUPTION B .  V$COPY_CORRUPTION C .  V$DATABASE_BLOCK_CORRUPTION D .  RC_BACKUP_CORRUPTION

  查看最佳答案