OCP Backup And Recovery Practice Test 4 — 15 Questions

Question 1

You are the DBA for an Oracle 23ai database in ARCHIVELOG mode with a fast recovery area configured. A user accidentally truncates a critical table in the HR schema. You have a full RMAN backup from last night. You want to recover the table to its state just before the truncate, without affecting other objects in the tablespace. Which RMAN command should you use?

Choose an answer to begin — your selection is scored in the full session.

Accepted Answer

RECOVER TABLE hr.employees UNTIL TIME '2025-03-18 09:30:00';. The RECOVER TABLE command in Oracle 23ai enables recovery of a single table to a specified point in time using an auxiliary instance and Data Pump export/import. It is the correct method for recovering from a TRUNCATE without impacting other objects. The other options either are invalid syntax or affect more data than necessary.

Answer

RESTORE TABLE hr.employees UNTIL TIME '2025-03-18 09:30:00';

Answer

RECOVER DATAFILE 7 UNTIL TIME '2025-03-18 09:30:00';

Answer

FLASHBACK TABLE hr.employees TO BEFORE TRUNCATE;

Question 2

Your Oracle 23ai production database uses a fast recovery area and RMAN backups to disk. A junior DBA accidentally deleted several archived redo log files that have not yet been backed up. You need to recover the database to the point just before the deletion. Which two actions must you perform? (Choose two.)

Accepted Answer

Perform an incomplete recovery using the most recent control file autobackup and the remaining archived logs.. With archived logs deleted before being backed up, that redo is irrecoverable, so the database cannot be recovered to the exact pre-deletion point. The viable path is incomplete recovery using the most recent control file autobackup and the surviving archived logs, recovering only to the last available log. Restoring nonexistent logs or relying on flashback is not possible.

Answer

Use FLASHBACK DATABASE to rewind the database to the SCN before the deletion.

Answer

Restore the missing archived redo log files from an RMAN backup and use them during recovery.

Answer

Re-create the database from the last full backup because redo gaps always require a full rebuild.

Question 3

You are the DBA of an Oracle 23ai database in ARCHIVELOG mode. A media failure destroyed the disk containing the SYSTEM tablespace data file. You have a full RMAN backup and all archived redo logs. The database instance is still running but the SYSTEM tablespace is offline. You need to restore and recover the SYSTEM tablespace while the database remains open. Which RMAN command sequence accomplishes this?

Accepted Answer

RESTORE TABLESPACE system; RECOVER TABLESPACE system;. The RESTORE TABLESPACE and RECOVER TABLESPACE commands allow recovery of the SYSTEM tablespace while the database is open, as long as the data file is offline. This minimizes downtime. The other options either require an outage, attempt invalid offline operations, or use data file-level commands that are not permitted for SYSTEM in an open database.

Answer

RESTORE DATAFILE 1; RECOVER DATAFILE 1;

Answer

SHUTDOWN IMMEDIATE; STARTUP MOUNT; RESTORE TABLESPACE system; RECOVER TABLESPACE system; ALTER DATABASE OPEN;

Answer

ALTER DATABASE DATAFILE 1 OFFLINE; RESTORE DATAFILE 1; RECOVER DATAFILE 1; ALTER DATABASE DATAFILE 1 ONLINE;

Question 4

Your Oracle 23ai database is in ARCHIVELOG mode. A user accidentally dropped a table in the HR schema two hours ago, and the undo retention window has already passed. You have a full backup from last night and all archived redo logs since then. You want to recover just that table without affecting any other objects in the database. Which RMAN feature should you use?

Accepted Answer

Table Point-in-Time Recovery using RECOVER TABLE ... UNTIL TIME. Table Point-in-Time Recovery is the correct mechanism because it recovers a single table to a past time using backups and archived redo, without disturbing the rest of the database. It leverages an auxiliary instance and Data Pump to extract and reimport the table. Other options either affect the whole database or depend on the recycle bin, which is unavailable here.

Answer

RESTORE TABLE hr.employees; then RECOVER TABLE hr.employees;

Answer

FLASHBACK TABLE hr.employees TO BEFORE DROP;

Answer

FLASHBACK DATABASE TO TIMESTAMP;

Question 5

Your Oracle 23ai database uses a fast recovery area (FRA) with a size of 100 GB. You configured RMAN to create image copies of data files in the FRA. Over time, the FRA becomes full, and RMAN backups start failing with ORA-19809: limit exceeded for recovery files. You need to resolve this issue without losing any backups required for recovery. Which action should you take?

Accepted Answer

Increase the DB_RECOVERY_FILE_DEST_SIZE parameter to accommodate the image copies.. The ORA-19809 error indicates that the fast recovery area has reached its size limit. The correct resolution is to increase DB_RECOVERY_FILE_DEST_SIZE, which dynamically expands the FRA without removing any files. Other options either do not free space, require downtime, or are invalid while the FRA is in use.

Answer

Run CROSSCHECK and DELETE EXPIRED BACKUP to remove obsolete backups.

Answer

Set the DB_RECOVERY_FILE_DEST parameter to a new directory with more space.

Answer

Change the backup destination to a different location outside the FRA.

Question 6

Your Oracle 23ai database runs in NOARCHIVELOG mode. A user drops a critical table by mistake at 10:00, and you have a consistent RMAN backup taken at 02:00 that same day. You need to recover the dropped table with minimal impact on the rest of the database. Which approach is valid?

Accepted Answer

Use RMAN table recovery (RECOVER TABLE) on a restored auxiliary instance and export the table.. RMAN table recovery creates an auxiliary instance, restores the backup, recovers to the point before the drop, and exports the table with Data Pump. This restores the dropped table without affecting the production database. In NOARCHIVELOG mode, flashback and point-in-time roll-forward are unavailable, so the backup-based table recovery is the valid path.

Answer

Perform a full database restore and incomplete recovery to 10:00 using archived logs.

Answer

Restore the data file containing the table and perform block media recovery on the affected blocks.

Answer

Use FLASHBACK TABLE on the dropped table in the production database.

Question 7

You need to ensure that RMAN automatically deletes archived redo logs after they have been backed up twice to tape. Which configuration command should you use?

Accepted Answer

CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO DEVICE TYPE SBT;. The correct RMAN syntax to automatically delete archived redo logs after they have been backed up a specified number of times to a device type is 'CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP n TIMES TO DEVICE TYPE <device>'. This policy tells RMAN to delete archived logs once the specified redundancy to the given device (SBT = tape) is satisfied.

Answer

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 2 DAYS;

Answer

SET ARCHIVELOG DELETION POLICY TO 2 COPIES;

Answer

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;

Question 8

You are configuring a recovery catalog in Oracle 23ai. Which command must you execute first to ensure the catalog is ready to register the target database?

Accepted Answer

CREATE CATALOG;. The CREATE CATALOG command must be executed to initialize the schema before registration.

Answer

REGISTER DATABASE;

Answer

CONNECT CATALOG;

Answer

UPGRADE CATALOG;

Question 9

What is the primary purpose of the Flashback Database feature?

Accepted Answer

To revert the entire database to a point in time. Flashback Database allows you to return the entire database to a previous point in time without restoring from a backup.

Answer

To restore individual corrupted datafiles

Answer

To recover dropped tables

Answer

To undo a specific transaction

Question 10

You are investigating an RMAN backup failure. The log indicates that RMAN is unable to access the recovery area. Which view should you query to check the current space usage of the Fast Recovery Area?

Accepted Answer

V$RECOVERY_FILE_DEST. V$RECOVERY_FILE_DEST provides the directory, space limit, and space used for the FRA.

Answer

V$FLASHBACK_DATABASE_LOG

Answer

V$DATABASE_BLOCK_CORRUPTION

Answer

V$RMAN_STATUS

Question 11

You are performing a cross-platform data migration using RMAN CONVERT. The destination platform has different endianness. Which file type must be converted before it can be transported?

Accepted Answer

Datafiles. When performing cross-platform transport with different endianness, datafiles must be converted using RMAN CONVERT because their internal block structure is byte-order dependent. Redo logs, control files, and parameter files are not transported across platforms in this manner; they are either recreated or are platform-independent text/binary structures that do not require endian conversion for the transport workflow.

Answer

Redo log files

Answer

Parameter files

Answer

Control files

Question 12

A user accidentally dropped a critical table. You decide to use Flashback Table. What is the mandatory prerequisite before this command can execute?

Accepted Answer

Row movement must be enabled on the table.. To use Flashback Table, row movement must be enabled on the table because the operation may change the physical rowids of rows as it restores the table to a previous point in time. This is a mandatory prerequisite. Without row movement enabled, the flashback operation will fail.

Answer

The table must have a Primary Key.

Answer

The database must be in ARCHIVELOG mode.

Answer

The Recycle Bin must be disabled.

Question 13

Which TWO actions occur during a RMAN 'BACKUP AS COPY' operation?

Accepted Answer

The output file is an exact image copy of the datafile.. Option B is correct because RMAN 'BACKUP AS COPY' produces an image copy, which is a byte-for-byte duplicate of the datafile, including its block structure and headers, rather than a proprietary backup piece. Option C is correct because an image copy is a usable datafile in its own right; it can be brought online or referenced directly (for example, via SWITCH DATAFILE ... TO COPY) without first performing an RMAN RESTORE, since no conversion from backup format is needed. Option A is incorrect because compression into a single backup piece describes a backup set, not an image copy, which is a one-to-one file copy. Option D is incorrect because the RMAN proprietary backup format applies to backup sets, whereas an image copy is an exact OS-level copy of the file. Option E is incorrect because encryption is not automatic; it must be explicitly enabled via configuration or the ENCRYPTION clause.

Answer

Datafiles are compressed into a single backup piece.

Answer

The backup is stored in the RMAN proprietary backup format.

Answer

The backup is automatically encrypted.

Question 14

Which RMAN command should you use to verify that your backup pieces are not corrupted?

Accepted Answer

VALIDATE BACKUPSET. VALIDATE BACKUPSET checks the integrity of the backup pieces.

Answer

LIST BACKUP

Answer

CROSSCHECK BACKUP

Answer

RESTORE DATABASE VALIDATE

Question 15

Which command is used to delete backups that are no longer needed based on the current retention policy?

Accepted Answer

DELETE OBSOLETE. DELETE OBSOLETE is the command to purge backups exceeding the retention policy.

Answer

DROP BACKUP

Answer

PURGE BACKUPS

Answer

DELETE BACKUP