Your data recovery strategy must meet the following requirements： Back up all data files and folders in C：\Data.  Restore individual files and folders in C：\Data.  Ensure that data is backed up to and restored from external media.  What should you do？（）

相似题目

• Which three activities are supported by the Data Recovery Advisor?（）

  A . Advising on block checksum failures B . Advising on inaccessible control files C . Advising on inaccessible block change tracking files D . Advising on empty password files E . Advising on invalid block header field value

  查看最佳答案

• 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.

  查看最佳答案

• A data file become corrupted in your database due to bad sectors on the disk. Because of corruption， you lost all the important tables in that data file. Which method would you use for recovery？（）

  A .  Flash back all the tables in the data file， one by one. B .  Restore the data file to a new location and perform a media recovery. C .  Flash back the database， there is no need to restore the data file. D .  Restore the data file from the most recent backup and flash the database.

  查看最佳答案

• Which three data components are needed for point-in-time recovery?（）

  A . The error log B . The backup log C . The general query log D . Binary logs E . The data backup F . Configuration file

  查看最佳答案

• Which  kinds of failures make the Data Recovery Advisor （DRA） generate a manual checklist？（）

  A . Failure when no standby database is configured B . Failure because a data file is renamed accidentally C . Failure that requires no archive logs to be applied for recovery D . Failure due to loss of connectivity-for example， an unplugged disk cable

  查看最佳答案

• Which options would you consider while configuring a flash recovery area fast recovery area in 11g Release 2 for your production database that is running in ARCHIVELOG mode？（） 

  A .  Setting the FAST_START_MTTR_TARGET to set the mean time to recover B .  Setting the RECOVERY_PARALLELISM parameter to twice the number of CPUs C .  Using the DB_RECOVERY_FILE_DEST parameter to set the location for flash recovery area D .  Using the DB_RECOVERY_FILE_DEST_SIZE parameter to define the disk space limit for the recovery files created in the flash recovery area

  查看最佳答案

• Identify the two tablespaces whose data files are so critical that only a closed recovery is possible.（）

  A . SYSAUX B . TOOLS C . UNDO D . INDEX E . SYSTEM F . USERS G . TEMP

  查看最佳答案

• 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 full path name is specified

  查看最佳答案

• Which two activities are NOT supported by the Data Recovery Advisor DRA（）

  A . Recover from failures in the RAC environment. B . Diagnose and repair a data file corruption online. C . Diagnose and repair a data file corruption offline. D . Diagnose and repair failures on a standby database

  查看最佳答案

• Which options would you consider while configuring a flash recovery area (fast recovery area in 11g Release 2) for your production database that is running in ARCHIVELOG mode?（）

  A . Setting the FAST_START_MTTR_TARGET to set the mean time to recover B . Setting the RECOVERY_PARALLELISM parameter to twice the number of CPUs C . Using the DB_RECOVERY_FILE_DEST parameter to set the location for flash recovery area D . Using the DB_RECOVERY_FILE_DEST_SIZE parameter to define the disk space limit for the recovery files created in the flash recovery area

  查看最佳答案

• Rate your level of proficiency with managing and implementing disaster recovery. （）

  A . Very High B . High C . Moderate D . Low E . Very Low

  查看最佳答案

• Which two kinds of failures make the Data Recovery Advisor (DRA)generate a manual checklist? （）

  A . failures because a data file is renamed by error B . failures when no standby database is configured C . failures that require no archive logs to be applied for recovery D . failures due to loss of connectivity-for example, an unplugged disk cable

  查看最佳答案

• You need to test your disaster recovery solution.  Which role should you transfer to the disaster recovery location during the test？（）

  A .  RID master B .  Schema master C .  PDC emulator master D .  Domain naming master

  查看最佳答案

• A financial customer has three data centers that are four kilometers apart. Their SAP application data needs to be kept synchronized within 10 milliseconds.  Which solution satisfies the customer’s recovery time objective（）

  A . DS8700 systems at each site running Metro Mirror B . DS8700 systems at each site running Global Mirror C . DS5300 systems at each site running Global Mirror D . XIV systems at each site running Remote Mirroring

  查看最佳答案

• 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 need to test your disaster recovery solution. Which role should you transfer to the disaster recovery location during the test?（）

  A . RID master B . Schema master C . PDC emulator master D . Domain naming master

  查看最佳答案

• Data files of which three tablespaces can be recovered by performing an open recovery？（）

  A . TEMP B . UNDO C . INDEX D . SYSAUX E . SYSTEM

  查看最佳答案

• 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

  查看最佳答案

• Which two activities are NOT supported by the Data Recovery Advisor?（）

  A . Diagnose and repair a data file corruption offline. B . Diagnose and repair a data file corruption online. C . Diagnose and repair failures on a standby database. D . Recover from failures in the Real Application Cluster (RAC) environment.

  查看最佳答案

• 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.

  查看最佳答案

• A data file became corrupted in your database due to bad sectors on the disk. Because of corruption， you lost all the important tables in that data file. Which method would you use for recovery？（）

  A . flash back all the tables in the data file， one by one B . restore the data file to a new location and perform a media recovery C . flash back the database; there is no need to restore the data file D . restore the data file from the most recent backup and flash back the database

  查看最佳答案

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

  You are using Recovery Manager (RMAN) with a recovery catalog to back up your production database. Thebackups 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 consider performing the following steps to accomplish the task:1) Restore an autobackup of the server parameter file.2) Restore the control file3) Start the target database instance4) Mount the database5) Restore the data files6) Open the database with RESETLOGS option7) Recover the data files8) Set DBID for the target databaseWhich 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

  查看最佳答案

• In your database, the flash recovery area （FRA) is configured as the default for RMAN back

  In your database, the flash recovery area (FRA) is configured as the default for RMAN backups. You executed the following commands to configure the settings in RMAN:Which statement is true about the outcome？（） <img src='https://img2.soutiyun.com/ask/uploadfile/2019-03-27/4f3f38f4fa50f6813beecdb37f5e123f.jpg' /> A. Only one channel is allocated and the backup is created in the flash recovery area B. Only one channel is allocated and the backup is created in the destination specified for channel C. Two channels are allocated and backup sets are created in the destinations specified for channels 1 and 2 D. Three channels are allocated and backup sets are created in the destinations specified for channels 1, 2, and FRA

  查看最佳答案