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

最新推荐文章于 2023-03-10 11:19:59 发布

原创最新推荐文章于 2023-03-10 11:19:59 发布 · 7.5k 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

收录于

OCP-1Z0-053

本文探讨了在使用Recovery Manager (RMAN)进行数据库备份时，为何必须使用恢复目录。主要阐述了两个关键场景：一是存储多个数据库的备份信息；二是通过AT子句使用REPORT SCHEMA命令列出特定时间点的数据文件。通过实例展示了如何利用恢复目录实现高效备份管理。

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

Answer: AD

答案解析：

参考：http://docs.oracle.com/cd/E11882_01/backup.112/e10643/rcmsynta2006.htm#RCMRF90281

题中意在比较控制文件和恢复目录，指出两个必须只用恢复目录的场景：

A，可以存储多个数据库的备份信息，恢复目录可以做到，控制文件只能记录一个数据库的备份信息

D，atClause：

This subclause specifies a point in time as a time, SCN, or log sequence number. You must be connected to a recovery catalog when issuing a REPORT SCHEMAcommand with an AT clause.

atClause

This subclause specifies a point in time as a time, SCN, or log sequence number. You must be connected to a recovery catalog when issuing a REPORT SCHEMAcommand with an AT clause.

Syntax Element	Description
`AT SCN` `integer`	Specifies an SCN.
`AT SEQUENCE` `integer`	Specifies a log sequence number. The integer indicates the time when the specified log was first opened.
`THREAD` `integer`	Specifies a redo `THREAD` number. The integer indicates the time when the thread was first opened.
`AT TIME` `'date_string'`	Specifies a date (see Example 3-14). The `NLS_LANG` and `NLS_DATE_FORMAT` environment variables specify the format for the time.