nerdexam
Oracle

1Z0-060 · Question #216

In which two scenarios is an RMAN recovery catalog automatically resynchronized? (Choose two.)

The correct answer is A. when a registered database is opened with the RESETLOGS option C. when backup metadata records are aged out of the control file based on the. The RMAN recovery catalog is automatically resynchronized when a registered database opens with RESETLOGS and when control file metadata ages out per the retention policy.

New Features for Availability

Question

In which two scenarios is an RMAN recovery catalog automatically resynchronized? (Choose two.)

Options

  • Awhen a registered database is opened with the RESETLOGS option
  • Bwhen a redo log is archived
  • Cwhen backup metadata records are aged out of the control file based on the
  • Dwhen the backup retention policy configuration is changed for a registered database
  • Ewhen a manual redo log switch is performed

How the community answered

(27 responses)
  • A
    74% (20)
  • B
    4% (1)
  • D
    15% (4)
  • E
    7% (2)

Why each option

The RMAN recovery catalog is automatically resynchronized when a registered database opens with RESETLOGS and when control file metadata ages out per the retention policy.

Awhen a registered database is opened with the RESETLOGS optionCorrect

Opening a database with the RESETLOGS option creates a new database incarnation, and RMAN automatically resynchronizes the recovery catalog to record the new incarnation information along with updated structural and backup metadata.

Bwhen a redo log is archived

Archiving a redo log does not trigger an automatic recovery catalog resynchronization; archived log metadata is recorded in the catalog during subsequent backup operations or an explicit RESYNC CATALOG command.

Cwhen backup metadata records are aged out of the control file based on theCorrect

When RMAN ages out backup metadata records from the control file based on the CONTROL_FILE_RECORD_KEEP_TIME parameter, an automatic resynchronization triggers so that the recovery catalog preserves records before they are purged from the control file.

Dwhen the backup retention policy configuration is changed for a registered database

Changing the backup retention policy configuration does not automatically resynchronize the catalog; a manual RESYNC CATALOG command is required to propagate such configuration changes.

Ewhen a manual redo log switch is performed

A manual redo log switch does not trigger automatic recovery catalog resynchronization; log switches are local, control-file-level events that do not directly cause catalog updates.

Concept tested: RMAN recovery catalog automatic resynchronization triggers

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/managing-recovery-catalog.html

Topics

#RMAN recovery catalog#catalog resynchronization#RESETLOGS#control file aging

Community Discussion

No community discussion yet for this question.

Full 1Z0-060 Practice