nerdexam
Oracle

1Z0-052 · Question #55

View the Exhibit to examine the output for the CROSSCHECK BACKUP command. Which statement is true about the output of the command?

The correct answer is B. The backup piece is expired because the operating-system file was not found. RMAN CROSSCHECK verifies the physical existence of backup pieces; a piece is marked EXPIRED when the underlying OS file cannot be found at the recorded location.

Performing Backup and Recovery

Question

View the Exhibit to examine the output for the CROSSCHECK BACKUP command. Which statement is true about the output of the command?

Exhibit

1Z0-052 question #55 exhibit

Options

  • AThe backup piece is expired as the new backup is available
  • BThe backup piece is expired because the operating-system file was not found
  • CThe backup piece is expired because the retention period for the backup has expired
  • DThe backup piece is expired because the backup set to which it belongs is not complete

How the community answered

(42 responses)
  • A
    2% (1)
  • B
    88% (37)
  • C
    5% (2)
  • D
    5% (2)

Why each option

RMAN CROSSCHECK verifies the physical existence of backup pieces; a piece is marked EXPIRED when the underlying OS file cannot be found at the recorded location.

AThe backup piece is expired as the new backup is available

CROSSCHECK does not evaluate whether a newer backup supersedes an older one - that is a function of the retention policy applied via REPORT OBSOLETE or DELETE OBSOLETE.

BThe backup piece is expired because the operating-system file was not foundCorrect

During CROSSCHECK BACKUP, RMAN queries the OS file system or media manager to confirm each backup piece physically exists at its registered path. If the file has been deleted, moved, or is otherwise inaccessible outside of RMAN, Oracle marks the repository record EXPIRED to indicate the piece is no longer available for restore.

CThe backup piece is expired because the retention period for the backup has expired

Retention period expiration is assessed by the configured retention policy (recovery window or redundancy), not by the CROSSCHECK command, which only tests physical accessibility.

DThe backup piece is expired because the backup set to which it belongs is not complete

An incomplete backup set would affect restorability but CROSSCHECK marks a piece EXPIRED solely based on whether the file is accessible, not on the completeness status of the parent backup set.

Concept tested: RMAN CROSSCHECK and EXPIRED backup piece status

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/maintaining-rman-backups.html

Topics

#RMAN#CROSSCHECK BACKUP#backup piece#expired backup

Community Discussion

No community discussion yet for this question.

Full 1Z0-052 Practice