nerdexam
Oracle

1Z0-062 · Question #306

You are using RMAN to back up your database. All the data files are in read/write mode. Examine the RMAN configuration parameters: Which two statements are true about a whole consistent backup of a da

The correct answer is B. The database instance must be shut down to take the backup. E. The system Change Number (SCN) is the same for all the data files in the backup.. A whole consistent backup in ARCHIVELOG mode requires the database instance to be shut down cleanly to ensure all data files reflect the same System Change Number (SCN).

Performing Backup and Recovery

Question

You are using RMAN to back up your database. All the data files are in read/write mode. Examine the RMAN configuration parameters:

Which two statements are true about a whole consistent backup of a database running in ARCHIVELOG mode? (Choose two.)

Exhibit

1Z0-062 question #306 exhibit

Options

  • AThe backup can be used as an incremental level 0 backup.
  • BThe database instance must be shut down to take the backup.
  • CThe database must be in MOUNT state to take the backup.
  • DThe backup consists of blocks that have been formatted.
  • EThe system Change Number (SCN) is the same for all the data files in the backup.

How the community answered

(42 responses)
  • A
    12% (5)
  • B
    81% (34)
  • C
    2% (1)
  • D
    5% (2)

Why each option

A whole consistent backup in ARCHIVELOG mode requires the database instance to be shut down cleanly to ensure all data files reflect the same System Change Number (SCN).

AThe backup can be used as an incremental level 0 backup.

While a whole consistent backup can logically serve as a base for subsequent incremental backups, stating it 'can be used as an incremental level 0 backup' does not fully capture its defining characteristic regarding consistency.

BThe database instance must be shut down to take the backup.Correct

A whole consistent backup requires the database to be shut down cleanly (e.g., using SHUTDOWN NORMAL, IMMEDIATE, or TRANSACTIONAL) before the backup begins, ensuring a consistent state at the time of backup.

CThe database must be in MOUNT state to take the backup.

The database must be in a 'closed' or 'shut down' state for a consistent backup, though RMAN typically operates with the database in the MOUNT state to access control file information.

DThe backup consists of blocks that have been formatted.

All RMAN backups generally consist of blocks that have been formatted and contain data, but this is a general characteristic of RMAN backups, not a specific defining truth unique to a whole consistent backup.

EThe system Change Number (SCN) is the same for all the data files in the backup.Correct

For a consistent backup, all data files are written to disk at the same logical point in time, meaning they all share an identical System Change Number (SCN) which represents this consistent state.

Concept tested: RMAN consistent backup and database states

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/rman-backup-types.html#GUID-BC320078-E169-42F3-9D09-2166F5310F0B

Topics

#RMAN backup#consistent backup#ARCHIVELOG mode#SCN

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice