多选题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?()AYou must ensure that the SALES database is mounted or open.BYou must restore a backup con

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

如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

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

第2题:

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

第3题:

You want to take a complete database backup using RMAN. The backup should consist only the used blocks from your database.Which two statements are true about this backup operation?()

A. Backup compression should be enabled

B. Parallelism for the channel should be set to 2

C. All the files must be backed up as backup sets

D. The backup may be stored either on disk or on media with media manager


参考答案:D, E

第4题:

To enable faster incremental backups, you enabled block change tracking for the database.Which two statements are true about the block change tracking file?()

  • A、Multiple change tracking files can be created for a database.
  • B、The change tracking file must be created after the first level 0 backup.
  • C、RMAN does not support backup and recovery of the change tracking file.
  • D、The database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations.

正确答案: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 want to take a complete database backup using RMAN. The backup should consist only the used blocks from your database.Which two statements are true about this backup operation? ()(Choose two.)

A. Backup compression should be enabled

B. Parallelism for the channel should be set to 2

C. All the files must be backed up as backup sets

D. The backup may be stored either on disk or on media with media manager


参考答案:C, D

第7题:

To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the database in backup mode:   SQL> ALTER TABLESPACE users BEGIN BACKUP;   While copying the file to the backup destination a power outage caused the instance to te minate abnormally.  Which statement is true about the next database startup and the USERS tablespace?()  

  • A、 The database will open,and the tablespace automatically comes out of the backup mode.
  • B、 The database will be mounted,and recovery must be performed on the USERS tablespace.
  • C、 The database will be mounted,and data files in the USERS tablespace must be taken out of the backup mode.
  • D、 The database will not be mounted,and you must restore all the data files for the USERS tablespace from the backup,and perform recovery.

正确答案:C

第8题:

To enable faster incremental backups, you enabled block change tracking for the database.Which two statements are true about the block change tracking file?()

A. Multiple change tracking files can be created for a database.

B. The change tracking file must be created after the first level 0 backup.

C. RMAN does not support backup and recovery of the change tracking file.

D. The database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations.


参考答案:C, D

第9题:

In Recovery Manager (RMAN), you are taking image copies of the data files of your production database and rolling them forward at regular intervals. You attempt to restart your database. After a regular maintenance task, you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the data file by using the image copy. Because a media failure caused the data file to be damaged, you want to place the d ata file in a different location while restoring the file. Which option must you consider for this task?()

  • A、using only the RMAN SWITCH command to set the new location for the data file
  • B、placing the database in the MOUNT state for the restore and recovery operations.
  • C、using an RMAN RUN block with the SET NEWNAME and then the SWITCH command.
  • D、configuring two channels: one for the restore operation and the other for the recovery operation

正确答案:C

第10题:

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

更多相关问题