nerdexam
Oracle

1Z0-034 · Question #75

Identify two options that Oracle recommends while configuring the backup and recovery environment for your recovery catalog. (Choose two.)

The correct answer is A. configuring control file autobackup to be ON D. setting the retention policy to a REDUNDANCY value greater than 1. Configuring the Recovery Catalog Database When you use a recovery catalog, RMAN requires that you maintain a recovery catalog schema. The recovery catalog is stored in the default tablespace of the schema. The SYS user cannot be the owner of the recovery catalog. Decide which…

Backup and Recovery

Question

Identify two options that Oracle recommends while configuring the backup and recovery environment for your recovery catalog. (Choose two.)

Options

  • Aconfiguring control file autobackup to be ON
  • Bbacking up data filed only and not the archived redo log files
  • Crunning the recovery catalog database in NOARCHIVELOG mode.
  • Dsetting the retention policy to a REDUNDANCY value greater than 1
  • Ebacking up the recovery catalog to the same disk as that of the target database

How the community answered

(35 responses)
  • A
    74% (26)
  • B
    14% (5)
  • C
    9% (3)
  • E
    3% (1)

Explanation

Configuring the Recovery Catalog Database When you use a recovery catalog, RMAN requires that you maintain a recovery catalog schema. The recovery catalog is stored in the default tablespace of the schema. The SYS user cannot be the owner of the recovery catalog. Decide which database you will use to install the recovery catalog schema, and also how you will back up this database. Also, decide whether to operate the catalog database in ARCHIVELOG mode, which is recommended. Note: Do not use the target database to be backed up as the database for the recovery catalog. The recovery catalog must be protected if the target database is lost.

Topics

#recovery catalog#control file autobackup#retention policy#RMAN configuration

Community Discussion

No community discussion yet for this question.

Full 1Z0-034 Practice