多选题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 r

题目
多选题
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.

参考答案和解析
正确答案: D,A
解析: 暂无解析
如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

Indentify two advantages of using recovery catalog instead of the control file of the database in RecoveryManager (RMAN).()(Choose two.)

A. You can use RMAN stored scripts

B. Recovery is faster if data is stored in catalog in addition to the control file

C. You can store backup information of all registered databases in one place

D. Database backups are automatically deleted when they are older than the specified time period


参考答案:A, C

第2题:

Which of the following statements is NOT true about RMAN?()

  • A、It improves usability by enabling you to reuse the scripts to perform recovery operations.
  • B、It detects block corruption while restoration and recovery operations.
  • C、It enables you to perform block media recovery.
  • D、It is capable to recover through unrecoverable operations, with only full database backups.

正确答案:A

第3题:

Indentify two advantages of using recovery catalog instead of the control file of the database in Recovery Manager (RMAN)?()

A. You can use RMAN stored scripts

B. Recovery is faster if data is stored in catalog in addition to the control file

C. You can store backup information of all registered databases in one place

D. Database backups are automatically deleted when they are older than the specified time period


参考答案:A, C

第4题:

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

正确答案:C,D

第5题:

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.

正确答案:D

第6题:

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


参考答案:C, D

第7题:

Identity two advantages of using a recovery catalog in-load of the control File of the target database Recovery Manager (RMAN).()

  • A、 You can use RMAN stored scripts.
  • B、 Recovery is faster if data is stored in catalog in addition to the control file.
  • C、 You can store backup Information of all registered databases in one place.
  • D、 Database backups are automatically deleted when they are older than the specified time period.

正确答案:A,C

第8题:

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


参考答案:C, D

第9题:

Your database is open and running in ARCHIVELOG mode. You take RMAN full backups every Sunday night. On Monday morning, while querying the user1.employees table, you receive the following error message:  01578: ORACLE data block corrupted (file # 5, block # 51) ORA-01110: data file 5:  ’/u01/app/oracle/oradata/orcl/example01.dbf’  You need to rectify the corruption while ensuring the following: The data file should remain online.  The mean time to recover (MTTR) should be minimal.  You are not using a backup control file, and all the archived logs are accessible.   Which option would you choose?()

  • A、flash back the corrupted blocks
  • B、use the DBMS_REPAIR package
  • C、use the RMAN TSPITR command
  • D、use the RMAN BLOCKRECOVER command
  • E、use the RESTORE DATABASE and RECOVER DATABASE commands
  • F、investigate the time at which the corruption occurred and perform a point-in-time recovery

正确答案:D

第10题:

You work as a database administrator at Certkiller .com. Your database is open and running in ARCHIVELOGmode. You take RMANfull backups every Sunday night. On Monday morning, while querying the user1.employeestable, you receive the following error message:  01578: ORACLE data block corrupted (file # 5, block # 51)  ORA-01110: data file 5:’/u01/app/oracle/oradata/orcl/example01.dbf’  You need to rectify the corruption while ensuring the following:  The data file should remain online.  The mean time to recover (MTTR) should be minimal.  You are not using a backup control file and all the archived logs are accessible.  Which option would you choose?()

  • A、 flash back the corrupted blocks
  • B、 use the DBMS_REPAIR package
  • C、 use the RMAN TSPITR command
  • D、 use the RMAN BLOCKRECOVER command
  • E、 use the RESTORE DATABASE and RECOVER DATABASE commands
  • F、 investigate the time at which the corruption occurred and perform a point-in-time recovery

正确答案:D

更多相关问题