OCP Backup & Recovery 2

Question 1

Which RMAN command is used to validate a backup without actually restoring it?

Accepted Answer

RESTORE DATABASE VALIDATE

Answer

RESTORE DATABASE VALIDATE checks whether RMAN has the necessary backups to restore the database without actually writing any files.

Question 2

What happens to a tablespace that is taken offline with the NORMAL option before a backup?

Accepted Answer

A checkpoint is issued and the tablespace needs no recovery when brought back online

Answer

OFFLINE NORMAL forces a checkpoint so the datafiles are consistent and no recovery is required when the tablespace is brought back online.

Question 3

In RMAN, which retention policy setting ensures backups are kept until they are no longer needed to recover the database to any point in the last 7 days?

Accepted Answer

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS

Answer

RECOVERY WINDOW OF N DAYS keeps backups needed to restore the database to any point within the last N days.

Question 4

Which view shows the status of RMAN backup jobs currently running?

Accepted Answer

V$SESSION_LONGOPS

Answer

V$SESSION_LONGOPS tracks long-running operations including RMAN backup and restore jobs, showing estimated time remaining.

Question 5

What is the purpose of the RMAN CATALOG command when used with a recovery catalog?

Accepted Answer

Registers an RMAN backup file not previously known to the catalog

Answer

CATALOG registers backup files or copies with the recovery catalog so RMAN is aware of them for future restore operations.

(OCP) Oracle Certified Professional Practice Test

(OCP) Oracle Certified Professional Practice Test

OCP Backup & Recovery 2