OCP-1Z0-053-200题-41题-620_053 to store the backup information of multiple da-CSDN博客

本文深入探讨了如何利用Recovery Manager(RMAN)维护数据库备份信息，强调了在特定场景下使用恢复目录的必要性。包括备份多个数据库、通过特定时间点查询数据文件等关键操作，以及理解恢复目录在长时间存储备份记录中的作用。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

QUESTION 41

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 bythe 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

同620题：http://blog.csdn.net/rlhua/article/details/19166841

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.