nerdexam
Oracle

1Z0-032 · Question #49

You are using Recovery Manager (RMAN) to back up your production database at regular intervals. On Monday morning, the database administrator asks you to execute the following set of commands: RMAN>…

The correct answer is A. to identify the backups that no longer exist in a media and remove them from the RMAN repository. See the full explanation below for the reasoning.

Question

You are using Recovery Manager (RMAN) to back up your production database at regular intervals. On Monday morning, the database administrator asks you to execute the following set of commands:

RMAN> CROSSCHECK BACKUPSET OF DATABASE; RMAN> DELETE NOPROMPT EXPIRED BACKUP; What could be the reason to execute these commands?

Options

  • Ato identify the backups that no longer exist in a media and remove them from the RMAN repository
  • Bto identify obsolete backup sets, mark them as EXPIRED and then remove them from the RMAN repository
  • Cto identify the backups that are no longer required for a recovery and remove them from the RMAN repository
  • Dto identify the backups of archived redo log files that have been used to recover a data file and remove them

How the community answered

(40 responses)
  • A
    78% (31)
  • B
    13% (5)
  • C
    3% (1)
  • D
    8% (3)

Community Discussion

No community discussion yet for this question.

Full 1Z0-032 Practice