nerdexam
Oracle

1Z0-083 · Question #27

You have configured RMAN SBT channels to write backups to media. You then take an RMAN backup by using this command: Which three are true? (Choose three.)

The correct answer is B. The data file backups in the self-contained archive backup are not considered obsolete for two D. The SPFILE is included in the self-contaied archival backup. E. The control file is included in the self-contained archival backup. The restore point is a label for the SCN to which this archival backup can be restored and recovered , and is captured just after the data file backups complete. (F is wrong) Normal restore points are retained in the database for at least the number of days specified for the…

Perform Advanced RMAN Concepts

Question

You have configured RMAN SBT channels to write backups to media. You then take an RMAN backup by using this command:

Which three are true? (Choose three.)

Options

  • AThe restore point is a label for the system change number (SCN) that will be saved two years
  • BThe data file backups in the self-contained archive backup are not considered obsolete for two
  • CAll archive logs created after this backup are kept for two years.
  • DThe SPFILE is included in the self-contaied archival backup.
  • EThe control file is included in the self-contained archival backup.
  • FThe restore point is a label for the system change number (SCN) before the archival backup was

How the community answered

(32 responses)
  • A
    9% (3)
  • B
    81% (26)
  • C
    3% (1)
  • F
    6% (2)

Explanation

The restore point is a label for the SCN to which this archival backup can be restored and recovered , and is captured just after the data file backups complete. (F is wrong) Normal restore points are retained in the database for at least the number of days specified for the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter (A incorrect) - The control file autobackup that RMAN automatically makes when you use the backup .. keep command has a copy of the restore point (and also the spfile D and E are correct) KEEP - Specifies the backup as an archival backup, which is a self-contained backup that is exempt from the configured retention policy. UNTIL TIME - Specifies the time until which the backup or copy must be kept (B correct) https://docs.oracle.com/cd/E18283_01/server.112/e17118/statements_6011.htm

Topics

#RMAN archival backup#restore points#self-contained backup#SBT channels

Community Discussion

No community discussion yet for this question.

Full 1Z0-083 Practice