OCP-1Z0-053-V13.02-193题

最新推荐文章于 2016-11-24 16:11:02 发布

原创最新推荐文章于 2016-11-24 16:11:02 发布 · 7.7k 阅读

CC 4.0 BY-SA版权

870 篇文章

订阅专栏

796 篇文章

订阅专栏

本文详细介绍了Oracle RMAN工具中的恢复命令用途，包括如何使用它进行数据库完整恢复、点时刻恢复、增量备份应用及损坏数据块修复等。此外还解释了RMAN在恢复过程中选择增量备份集和归档重做日志文件的顺序。

193.What is the purpose of the recover command? (Choose all that apply.)

A. Recover database datafiles from physical disk backup sets.

B. Recover required incremental backups from physical disk backup sets.

C. Recover required archived redo logs from physical disk backup sets.

D. Apply incremental backups to recover the database.

E. Apply archived redo logs to recover the database.

Answer: BCDE

答案解析：

A答案为restore命令。

Purpose

Use the RECOVER command to perform one of the following distinct tasks:

Perform complete recovery of the whole database or one or more restored data files
Perform point-in-time recovery of a database (DBPITR) or tablespace (TSPITR)
Apply incremental backups to a data file image copy (not a restored data file) to roll it forward in time
Recover a corrupt data block or set of data blocks within a data file

Incremental Backups and Archived Redo Log Files

Except for RECOVER BLOCK, RMAN can use both incremental backups and archived redo log files for recovery. RMAN uses the following search order:
1. Incremental backup sets on disk or tape
2. Archived redo log files on disk
3. Archived redo log backups on disk
4. Archived redo log backup sets on tape
When RMAN chooses a destination to restore archived redo log files, it uses the following order of precedence:
1. SET ARCHIVELOG DESTINATION
2. The LOG_ARCHIVE_DEST_n parameter whose value is set to LOCATION=USE_DB_RECOVERY_FILE_DEST
3. LOG_ARCHIVE_DEST_1
RMAN can apply incremental backups to data files that were not restored from an incremental backup. If overlapping levels of incremental backup exist, then RMAN automatically chooses the level covering the longest period of time.