OCP Backup And Recovery Practice Test 3 — 15 Questions

Question 1

Which TWO commands allow you to check for block corruption in a database?

Accepted Answer

BACKUP VALIDATE DATABASE. Option B, BACKUP VALIDATE DATABASE, is correct because it performs a validation pass over the database files (datafiles, control file, and archived logs) without actually creating backups, detecting physical and logical block corruption via the RMAN validation logic. Option E, ANALYZE TABLE ... VALIDATE STRUCTURE, is correct because it verifies the logical integrity of a table's blocks and indexes, reporting corruption in the specified object. Option A, SELECT * FROM V$LOG, only shows redo log group status and metadata, not block corruption. Option C, ALTER SYSTEM CHECK, is not a valid Oracle command for corruption checking. Option D, RECOVER DATABASE, applies redo to restore consistency but does not itself scan for or report block corruption.

Answer

SELECT * FROM V$LOG

Answer

ALTER SYSTEM CHECK

Answer

RECOVER DATABASE

Question 2

You need to perform a Table Point-in-Time Recovery (TPITR) to restore a table to a state before a mistaken DROP TABLE operation. Which RMAN command performs this operation while minimizing impact to other tablespaces?

Accepted Answer

RECOVER TABLE ... UNTIL SCN ...;. The correct RMAN command for Table Point-in-Time Recovery (TPITR) is RECOVER TABLE ... UNTIL SCN ...;. This command restores a table to a specified SCN by creating an auxiliary instance, recovering the table, and importing it back, while minimizing impact on other tablespaces. It is specifically designed for recovering a table after a mistaken DROP.

Answer

FLASHBACK TABLE ... TO SCN ...;

Answer

IMPORT FROM BACKUPSET ...;

Answer

RESTORE TABLE ... UNTIL SCN ...;

Answer

null

Question 3

A database is configured with a Flash Recovery Area (FRA). You want to ensure that RMAN automatically deletes obsolete backups to reclaim space in the FRA. Which command should you configure?

Accepted Answer

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;. Configuring a retention policy with a recovery window tells RMAN to retain all backups and archived logs needed to recover the database to any point within the last 7 days. RMAN then automatically marks backups outside that window as obsolete, and when the FRA fills up, it deletes obsolete files to reclaim space.

Answer

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '...';

Answer

CONFIGURE CONTROLFILE AUTOBACKUP ON;

Answer

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;

Question 4

You have a standby database and want to use RMAN to offload backups to the standby. Which configuration is required to ensure the primary database recognizes the backups performed on the standby?

Accepted Answer

CONFIGURE CONTROLFILE AUTOBACKUP FOR BACKUP ON STANDBY ON;. To use a standby for backups, you must connect RMAN to the recovery catalog and the standby database, and ensure the configuration includes 'CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY'.

Answer

CONFIGURE CONNECT IDENTIFIER FOR DEFAULT SERVICE TO 'standby_service';

Answer

CONFIGURE BACKUP OPTIMIZATION ON;

Answer

Enable Flashback Database on the primary only.

Question 5

Which RMAN command should you use to verify that all blocks in your database datafiles are free from physical corruption without actually performing a restore?

Accepted Answer

BACKUP VALIDATE DATABASE;. The VALIDATE command checks for physical and logical block corruption in datafiles, control files, and backup sets.

Answer

RECOVER DATABASE TEST;

Answer

CHECK DATAFILES;

Answer

RESTORE DATABASE VALIDATE;

Question 6

Which TWO of the following are valid methods to move a database across platforms using RMAN?

Accepted Answer

Transportable Tablespaces. Option A (Transportable Tablespaces) is correct because RMAN can transport a set of tablespaces between platforms with different endian formats by using CONVERT TABLESPACE, which converts the datafiles to the target platform's byte order before plugging them into the destination database. Option E (RMAN CONVERT DATABASE) is correct because the CONVERT DATABASE command is specifically designed to move an entire database across platforms, generating a converted copy of the datafiles plus a script to create the new database on the target platform. Option B is not a cross-platform method: DUPLICATE ... FROM ACTIVE DATABASE creates a duplicate on the same platform and does not perform endianness conversion. Option C is a logical migration tool (Data Pump) and is not an RMAN method. Option D, BACKUP AS COPY, only produces image copies of files and does not convert them for a different platform.

Answer

RMAN DUPLICATE DATABASE FROM ACTIVE DATABASE

Answer

Data Pump Export/Import with Full Database mode

Answer

RMAN BACKUP AS COPY

Question 7

Which THREE components are included in an RMAN 'BACKUP DATABASE' command if not explicitly excluded?

Accepted Answer

Control File. In RMAN, a BACKUP DATABASE command by default includes all datafiles (option E), since the database itself consists of the datafiles belonging to the target database, and these are the primary objects being backed up. The control file (option A) is also included automatically because RMAN needs the control file to record backup metadata and it is essential for recovery. The SPFILE (option C) is likewise included by default, as RMAN backs up the server parameter file to preserve instance configuration for restore and recovery. Temporary tablespace files (option B) are not backed up because they contain no permanent data and are recreated at instance startup, and redo logs (option D) are not included in a BACKUP DATABASE command since they are protected separately through archived redo log backups or by using BACKUP ARCHIVELOG.

Answer

Temporary Tablespace

Answer

Redo Logs

Question 8

You are the DBA for a production Oracle 23ai database running in ARCHIVELOG mode. A developer accidentally ran a DELETE without a WHERE clause against the SALES table at 10:15 AM, and the commit was issued immediately. The table is 50 GB and resides in a locally managed tablespace with automatic segment space management. You need to recover the table to its state just before the delete with minimal impact on the rest of the database. Which action should you take?

Accepted Answer

Use RMAN RECOVER TABLE sales UNTIL TIME "TO_DATE('2025-03-18 10:14:00','YYYY-MM-DD HH24:MI:SS')" AUXILIARY DESTINATION '/u01/aux';. RMAN RECOVER TABLE is designed for point-in-time recovery of a single table or partition without affecting the rest of the database. It uses an auxiliary instance to restore and recover a copy of the datafiles to the specified point in time, then extracts the table and imports it. This method does not depend on undo retention and works for large tables, making it ideal for the accidental DELETE scenario.

Answer

Perform a Database Point-in-Time Recovery (DBPITR) of the entire database to 10:14 AM.

Answer

Use FLASHBACK TABLE sales TO TIMESTAMP ... to revert the table in place.

Answer

Use Flashback Drop to restore the table from the recycle bin.

Question 9

Your Oracle 23ai database uses a Fast Recovery Area (FRA) with a size of 200 GB. You configured RMAN to create backups with the command BACKUP DATABASE PLUS ARCHIVELOG. After several days, you notice that the FRA is nearly full and RMAN backups are failing with ORA-19809. You need to ensure that RMAN automatically deletes obsolete backups and archived logs to free space, while retaining the recovery window of 7 days. Which action should you take?

Accepted Answer

Set the RMAN retention policy to a recovery window of 7 days and run DELETE OBSOLETE;. The correct approach is to ensure a retention policy is in place and then delete obsolete backups. Setting RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS defines what must be kept. Running DELETE OBSOLETE removes all backups and archived logs that are no longer required for that window, freeing space in the FRA. This resolves the ORA-19809 error and prevents future space issues when combined with regular maintenance.

Answer

Increase the size of the Fast Recovery Area by setting DB_RECOVERY_FILE_DEST_SIZE to a larger value.

Answer

Configure the RMAN retention policy to a recovery window of 7 days and enable automatic backup deletion by setting the configuration parameter BACKUP OPTIMIZATION ON.

Answer

Set the RMAN configuration parameter RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS and run CROSSCHECK BACKUP; DELETE EXPIRED BACKUP;

Question 10

A production Oracle 23ai database uses a fast recovery area (FRA) with 200 GB capacity. During a full RMAN backup, the FRA becomes full and the backup fails with ORA-19809. You need to ensure that future backups do not fail due to FRA space pressure, while retaining the ability to restore to any point in the last 14 days. Which action best meets these requirements?

Accepted Answer

Increase the DB_RECOVERY_FILE_DEST_SIZE parameter to accommodate 14 days of backups.. The FRA full error occurs when the space used exceeds DB_RECOVERY_FILE_DEST_SIZE. Increasing this limit allows RMAN to store the required backups and archived logs for the 14-day window. Other options either shrink retention, remove the FRA, or optimize performance without solving the space constraint. The correct action directly resolves the space pressure while preserving recoverability.

Answer

Set the RMAN retention policy to REDUNDANCY 1 and run CROSSCHECK.

Answer

Enable block change tracking and run an incremental backup.

Answer

Configure a second backup destination on a different file system and remove the FRA.

Question 11

Your database is running in ARCHIVELOG mode with a fast recovery area. A data file in the USERS tablespace is corrupted. You have a full backup from last night and all archived logs since then. You want to restore and recover only that data file while the database remains open. Which RMAN command sequence should you use?

Accepted Answer

RESTORE DATAFILE 4; RECOVER DATAFILE 4;. To recover a single corrupted data file while the database remains open, the data file must be taken offline. Then RESTORE DATAFILE and RECOVER DATAFILE can be executed for that specific file. This minimizes impact and downtime. Restoring the entire database or tablespace is overkill and requires more downtime. SWITCH DATAFILE is for renaming or moving files, not for restoring corrupted files.

Answer

SWITCH DATAFILE 4; RECOVER DATAFILE 4;

Answer

RESTORE TABLESPACE USERS; RECOVER TABLESPACE USERS;

Answer

RESTORE DATABASE; RECOVER DATABASE;

Question 12

Your Oracle 23ai database is in NOARCHIVELOG mode. You perform a full RMAN backup every night. During the day, a user accidentally drops a table. You need to recover the table to its state just before the drop. Which statement is true about your recovery options?

Accepted Answer

You can use FLASHBACK TABLE to recover the table if flashback is enabled and the undo retention is sufficient.. In NOARCHIVELOG mode, point-in-time recovery and RMAN RECOVER TABLE are not possible because they require archived logs. The only way to recover a dropped table without a full restore is FLASHBACK TABLE, provided undo data is available. This operation uses the undo tablespace to reconstruct the table. Therefore, the correct option is the one that mentions FLASHBACK TABLE with sufficient undo retention.

Answer

You can restore the datafile containing the table from the backup and perform media recovery.

Answer

You can use RMAN RECOVER TABLE to recover the table from the backup.

Answer

You can use FLASHBACK DATABASE to revert the entire database to before the drop.

Question 13

You are managing a production Oracle 23ai database. You need to configure RMAN to automatically create a backup of the control file and server parameter file (SPFILE) whenever a backup of data file 1 is performed. Which two RMAN configuration commands achieve this? (Choose two.)

Accepted Answer

CONFIGURE CONTROLFILE AUTOBACKUP ON;. To automatically back up the control file and SPFILE with data file 1 backups, you must enable CONTROLFILE AUTOBACKUP and specify a format for the autobackup pieces. The format ensures the backups are written to a known location. The other options affect optimization, retention, or parallelism, but do not control automatic control file and SPFILE backups.

Answer

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;

Answer

CONFIGURE BACKUP OPTIMIZATION ON;

Answer

CONFIGURE DEVICE TYPE DISK PARALLELISM 2;

Question 14

You are planning a backup strategy for an Oracle 23ai database. You want to use RMAN incremental backups to reduce backup time and space. Which two statements are true regarding incremental backups? (Choose two.)

Accepted Answer

A cumulative level 1 incremental backup includes all blocks changed since the last level 0 backup.. Incremental backups can be level 0 or level 1. Level 1 backups are either differential or cumulative. Cumulative level 1 backups include all blocks changed since the last level 0, while differential include changes since the last level 1 or level 0. Block change tracking is optional but improves performance. Incremental backups are possible in NOARCHIVELOG mode. Therefore, the true statements are about the types of level 1 backups and the definition of cumulative level 1.

Answer

Block change tracking must be enabled to perform incremental backups.

Answer

Incremental backups can only be taken when the database is in ARCHIVELOG mode.

Answer

A level 0 incremental backup includes all blocks that have ever been used and is equivalent to a full backup.

Question 15

Your Oracle 23ai database uses a fast recovery area with ARCHIVELOG mode enabled. You want to validate that your most recent full database backup can actually be used for a restore without overwriting any current database files or applying redo. Which two RMAN operations accomplish a non-destructive validation of the backup? (Choose two.)

Accepted Answer

RESTORE DATABASE VALIDATE;. Both RESTORE DATABASE VALIDATE and BACKUP VALIDATE DATABASE read backup contents to confirm integrity and restorability without writing files or applying redo. They differ in focus: one simulates the restore path, the other validates blocks and backup metadata. Together they give confidence that a real restore would succeed while leaving the live database untouched.

Answer

VALIDATE BACKUP OF DATABASE;

Answer

CROSSCHECK BACKUP;

Answer

RESTORE DATABASE; then RECOVER DATABASE;