OCP Backup And Recovery Practice Test 5 — 15 Questions

Question 1

What happens if a block is marked as corrupt during an RMAN backup?

Accepted Answer

The information is recorded in the V$DATABASE_BLOCK_CORRUPTION view.. RMAN writes the corruption information to V$DATABASE_BLOCK_CORRUPTION but continues the backup unless the number of errors exceeds MAXCORRUPT.

Answer

The backup terminates immediately.

Answer

The backup is marked as 'failed' in the recovery catalog.

Answer

The corrupt blocks are repaired automatically.

Question 2

Which TWO statements are true regarding the use of a Recovery Catalog?

Accepted Answer

It can be used to store backup scripts.. Option A is correct because the RMAN recovery catalog can store backup scripts (persistent named scripts) that can be executed against registered target databases, allowing centralized script management. Option D is correct because a single recovery catalog schema can register multiple target databases and store their backup metadata, including backup sets, image copies, archived logs, and datafile information. Option B is incorrect because RMAN can perform backups using only the target database control file as the repository; the recovery catalog is optional. Option C is incorrect because the recovery catalog resides in a separate database (or schema), not inside the target database, to protect metadata if the target is lost. Option E is incorrect because control file autobackups are still recommended and can be used even with a recovery catalog, especially to recover the catalog or when the catalog is unavailable.

Answer

It is required to perform RMAN backups.

Answer

It is physically located inside the target database.

Answer

It eliminates the need for control file autobackups.

Question 3

How do you check the status of all current RMAN backup jobs?

Accepted Answer

SELECT * FROM V$RMAN_STATUS. V$RMAN_STATUS provides the most comprehensive view of backup job history and status.

Answer

SHOW ALL

Answer

LIST JOB SUMMARY

Answer

REPORT SCHEMA

Question 4

You are performing a TSPITR (Tablespace Point-in-Time Recovery). What is the purpose of the auxiliary instance?

Accepted Answer

To perform the recovery of the target tablespaces.. The auxiliary instance is used to restore and recover the target tablespaces to the desired point in time before exporting the data back to the primary database.

Answer

To act as a standby database.

Answer

To host the recovery catalog.

Answer

To manage the control file backups.

Question 5

You are performing an RMAN duplicate database operation. What is the benefit of using the 'FROM ACTIVE DATABASE' clause?

Accepted Answer

It is faster than restoring from backup.. It duplicates the database directly from the source without requiring a backup set to be restored first.

Answer

It requires less network bandwidth.

Answer

It does not require a connection to the target.

Answer

It creates a backup of the source during duplication.

Question 6

Which THREE are characteristics of Flashback Logs?

Accepted Answer

They are stored in the Fast Recovery Area (FRA).. Option A is correct because Flashback Database logs are written to the Fast Recovery Area (FRA), configured via DB_RECOVERY_FILE_DEST, which is the required storage location for flashback logs. Option C is correct because flashback logs operate in a circular fashion: as space in the FRA is consumed, older flashback logs are automatically reused or overwritten, so the flashback retention window is bounded by available FRA space. Option E is correct because flashback logs are the core mechanism of Flashback Database, allowing the database to be reverted to a prior point in time (for example, via FLASHBACK DATABASE TO TIMESTAMP or TO SCN) without restoring backups. Option B is not correct because flashback logs are managed automatically by the database and are not backed up with RMAN; RMAN backs up datafiles, archived redo logs, and control files, not flashback logs. Option D is not correct because flashback logs store before-images of changed data blocks, not redo information; redo information is contained in the online and archived redo logs.

Answer

They are backed up using RMAN.

Answer

They contain redo information.

Question 7

If you are in ARCHIVELOG mode, what is the primary benefit of having a multiplexed control file?

Accepted Answer

Redundancy against disk failure.. In ARCHIVELOG mode, a multiplexed control file provides redundancy against disk failure by maintaining multiple copies of the control file on different disks. If one copy becomes corrupted or a disk fails, the database can use another copy to continue operations, ensuring high availability and preventing downtime.

Answer

Faster backup performance.

Answer

Ability to perform point-in-time recovery.

Answer

Automatic database tuning.

Question 8

Which RMAN command displays the database structure and associated datafiles?

Accepted Answer

REPORT SCHEMA. REPORT SCHEMA shows the layout of the database and its datafiles.

Answer

DESCRIBE DATABASE

Answer

LIST SCHEMA

Answer

SHOW SCHEMA

Question 9

You want to backup the control file automatically whenever a change is made to the database structure. Which command do you use?

Accepted Answer

CONFIGURE CONTROLFILE AUTOBACKUP ON. CONFIGURE CONTROLFILE AUTOBACKUP ON is the correct RMAN command to enable automatic control file and SPFILE backups whenever the database structure changes or a backup is performed. This setting is persistent in the RMAN configuration and ensures the control file is backed up to the configured autobackup location (FRA or a specified format).

Answer

BACKUP CONTROLFILE ON

Answer

ALTER SYSTEM SET CONTROLFILE_AUTOBACKUP=TRUE

Answer

SET CONTROLFILE AUTOBACKUP ON

Question 10

You are performing a tablespace recovery. What is the first thing that must happen to the tablespace before recovery can start?

Accepted Answer

The tablespace must be taken offline.. The tablespace must be taken offline to perform recovery on its constituent datafiles.

Answer

The tablespace must be set to read-only.

Answer

The database must be shut down.

Answer

The database must be in restricted mode.

Question 11

What is the primary function of the RMAN 'SWITCH' command?

Accepted Answer

To update the control file to point to a new datafile copy.. The RMAN SWITCH command updates the recovery catalog and/or target control file so that the datafile entry points to a newly created copy (typically produced by BACKUP AS COPY or a restore to a new location). It does not move data itself — it repoints metadata. This is commonly used after restoring a datafile copy to a new path, allowing the database to use the copy without renaming at the OS level.

Answer

To move the database to a new server.

Answer

To switch between primary and standby.

Answer

To switch the log file.

Question 12

You have a standby database and want to offload backups to it. What is the recommended way to register the standby's backups in the recovery catalog?

Accepted Answer

Connect RMAN to the standby and the catalog.. The standby database should be connected to the recovery catalog to register its own backups.

Answer

Run the register command on the primary.

Answer

Export the primary catalog metadata to the standby.

Answer

Use the import command in RMAN.

Question 13

Which THREE pieces of information are needed to restore a database to a specific point-in-time using RMAN?

Accepted Answer

The DBID of the database.. Option C is correct because RMAN must identify which database to restore, and the DBID is required when using a control file backup or when the target database is not mounted, since RMAN needs it to locate the correct backup pieces and catalog entries. Option D is correct because a valid control file backup (or a recovery catalog) is needed to supply the metadata about backups, datafiles, and archived redo logs required to perform the point-in-time restore and recovery. Option E is correct because point-in-time recovery requires an explicit target, specified as a timestamp (SET UNTIL TIME) or an SCN (SET UNTIL SCN), to determine how far to apply redo and where to stop recovery. Option A is not required because RMAN authentication uses OS or password authentication for the session, but the operating system password itself is not part of the restore specification. Option B is not required because the current SPFILE is not needed to perform a point-in-time restore; RMAN can start the instance with a dummy parameter file or the existing SPFILE, and the SPFILE is not one of the three essential pieces of information for the restore operation.

Answer

The operating system password.

Answer

The current SPFILE.

Question 14

Which TWO of the following are benefits of using an RMAN recovery catalog?

Accepted Answer

Stores backup metadata for multiple databases.. Option A is correct because an RMAN recovery catalog is a separate schema (typically in an Oracle database) that can store backup metadata for multiple target databases, unlike the control file which is per-database. Option E is correct because the recovery catalog retains RMAN metadata indefinitely, allowing backup history to be preserved far longer than the control file's limited retention (governed by CONTROL_FILE_RECORD_KEEP_TIME), which is essential for long-term restore and reporting needs. Options B, C, and D are incorrect: the catalog does not perform encryption (that is done via RMAN encryption settings or wallet), does not remove the need for archived redo logs (required for consistent backups and point-in-time recovery), and does not improve database performance since it is only a metadata repository.

Answer

Automatically encrypts all backups.

Answer

Eliminates the need for archivelogs.

Answer

Provides faster database performance.

Question 15

You are using RMAN to backup a database. What does the 'COMPRESS' clause in the backup command do?

Accepted Answer

It reduces the backup size.. The 'COMPRESS' clause reduces the size of the backup pieces by applying compression, saving storage space.

Answer

It validates the backup.

Answer

It encrypts the backup.

Answer

It speeds up the backup.