Oracle Database: Backup and Recovery Workshop Quiz Questions and Answers

Failure recovery and media recovery fall under ___________

Answer :
  • System recovery

In log based recovery, the log is sequence of ___________

Answer :
  • Records

The enrolling of a database in a recovery catalogue is called ___________

Answer :
  • Registration

___________systems typically allows to replace failed disks without stopping access to the system.

Answer :
  • RAID

Block Media Recovery is not possible in 12c Database.

Answer :
  • False

RMAN configuration settings can be changed dynamically without any db restart

Answer :
  • True

Examine the steps to configure Oracle Secure Backup (OSB) for use with RMAN: 1. Create media families for data files and archived redo log files. 2. Configure database backup storage selectors or RMAN media management parameters. 3. Create an OSB user preauthorized for RMAN operations. 4. Configure RMAN Access to the OSB SBT. 5. Disable Non-Uniform Memory Access (NUMA) awareness by setting the ob_ignore_numa parameter to 0. Identify the steps in the correct order.

Answer :
  • 4, 3, 1, 2, 5

Examine the RMAN command: RMAN> SET ENCRYPTION IDENTIFIED BY ON FOR ALL TABLESPACES; RMAN> BACKUP DATABASE PLUS ARCHIVELOG; Which type of encryption is used for the backup performed by using this command?

Answer :
  • password-mode encryption

Your production database is running in archivelog mode. You use RMAN with a recovery catalog to back up your database to media and the database is uniquely identified in the recovery catalog. You want to create a test database from the production database and allow the production database to remain open during the duplicate process. You restore the database backups to a new host with the same directory structure as the production database and want to use the recovery catalog for future backups after the database is successfully restored to the new host. How would you achieve this?

Answer :
  • by using the RMAN DUPLICATE command with NOFILENAMECHECK to recover the database to the new host

In Oracle Database 19c ‘Snapshot too old’ error are associated with which component tuning.

Answer :
  • UNDO