OCP Backup And Recovery Practice Test 2 — 15 Questions

Question 1

Which configuration parameter determines the maximum size of a backup piece?

Accepted Answer

CONFIGURE MAXSETSIZE. CONFIGURE MAXSETSIZE is the parameter used to cap the size of a backup set.

Answer

CONFIGURE MAXPIECESIZE

Answer

SET BACKUPPIECE SIZE

Answer

CONFIGURE CHANNEL MAXSIZE

Question 2

Which TWO of the following are valid RMAN retention policies?

Accepted Answer

CONFIGURE RETENTION POLICY TO REDUNDANCY 3;. Option A is correct because RMAN supports a redundancy-based retention policy, and the syntax CONFIGURE RETENTION POLICY TO REDUNDANCY 3; keeps three complete backups of each datafile, making it a valid policy. Option C is correct because RMAN also supports a recovery window-based retention policy, and CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS; retains backups needed to recover to any point within the last seven days. Option B is invalid because RMAN does not accept a raw size value such as 100GB as a retention policy; space-based retention is not a supported RMAN retention policy type. Option D is invalid because NONE is not a valid retention policy clause in this form; to disable retention, you would use CONFIGURE RETENTION POLICY TO NONE only if supported, but here it is not the correct RMAN syntax for a valid policy. Option E is invalid because INFINITE is not a valid RMAN retention policy keyword; RMAN does not support CONFIGURE RETENTION POLICY TO INFINITE.

Answer

CONFIGURE RETENTION POLICY TO 100GB;

Answer

CONFIGURE RETENTION POLICY TO NONE;

Answer

CONFIGURE RETENTION POLICY TO INFINITE;

Question 3

Which THREE steps are involved in an RMAN-based cross-platform migration of a data file using CONVERT?

Accepted Answer

Transport the converted file to the target.. The RMAN cross-platform migration workflow starts by creating an image copy of the data file with BACKUP AS COPY (option C), because CONVERT operates on backup pieces or image copies rather than on live data files. Next, CONVERT DATAFILE is run on the source (option D) to translate the file's byte ordering to match the target platform's endian format, producing a converted copy. The converted file is then transported to the target (option B), typically via OS utilities, where it can be cataloged and plugged in. Option A is wrong because RECOVER DATABASE is not part of the conversion process and would not be run on the source for this migration. Option E is wrong because disabling ARCHIVELOG mode on the target is neither required nor advisable for a cross-platform transportable migration.

Answer

Run the RECOVER DATABASE command on the source.

Answer

Disable Archivelog mode on the target.

Question 4

Which TWO of the following are valid RMAN backup types?

Accepted Answer

Cumulative. Full and incremental are the standard types.

Answer

Sequential

Answer

Transactional

Question 5

What command would you use to list all backups associated with a particular database in the recovery catalog?

Accepted Answer

LIST BACKUP. LIST BACKUP is the standard command for this.

Answer

REPORT BACKUP

Answer

SHOW BACKUP

Answer

DISPLAY BACKUP

Question 6

You are performing a cross-platform data migration. The source is Linux and the destination is Windows. Which RMAN tool do you use to convert the datafiles?

Accepted Answer

RMAN CONVERT. The CONVERT command is used for cross-platform endianness issues.

Answer

RMAN IMPORT

Answer

RMAN TRANSPORT

Answer

RMAN MIGRATION

Question 7

Which THREE tasks are required when preparing for a database recovery using a new control file?

Accepted Answer

Perform RECOVER DATABASE USING BACKUP CONTROLFILE.. When preparing for a database recovery using a new control file, you must first restore the control file from a backup (C), because the recovery will be driven by that restored control file rather than the current one. Next, you must mount the database (B) so that the control file is read and the instance can access the datafiles and redo logs needed for recovery. Then you must perform RECOVER DATABASE USING BACKUP CONTROLFILE (A), which is the specific recovery command that uses the restored control file and applies redo/archived logs to bring the datafiles to a consistent state. Deleting all existing archivelogs (D) is not a required preparation step and would actually remove redo needed for recovery, and opening the database with RESETLOGS (E) is a post-recovery action, not a preparation task.

Answer

Delete all existing archivelogs.

Answer

Open the database resetlogs.

Question 8

Which TWO conditions are required for Block Change Tracking (BCT) to be effective?

Accepted Answer

Block Change Tracking must be enabled.. Option A is correct because Block Change Tracking only provides any benefit when the BCT feature itself has been explicitly enabled, e.g., with ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE 'path', which starts the CTWR background process writing change data to the change-tracking file. Option B is correct because BCT exists specifically to accelerate incremental backups: the change-tracking file records which blocks changed since the last backup, letting RMAN read only those blocks instead of scanning every block of every datafile during a level 1 incremental backup. Option C is wrong because restricted mode merely limits which sessions can connect and has no relationship to change tracking. Option D is wrong because ARCHIVELOG mode is required for online/hot backups and media recovery, not for BCT to function; BCT works in NOARCHIVELOG mode as well. Option E is wrong because Flashback Database is a separate feature that uses flashback logs and is unrelated to the change-tracking file used by incremental backups.

Answer

The database must be in restricted mode.

Answer

The database must be in ARCHIVELOG mode.

Answer

Flashback Database must be enabled.

Question 9

Which RMAN configuration must be set to ensure that backups are automatically deleted when they are no longer needed?

Accepted Answer

CONFIGURE RETENTION POLICY. CONFIGURE RETENTION POLICY defines the criteria for what is obsolete.

Answer

CONFIGURE AUTO DELETE ON

Answer

SET RETENTION POLICY

Answer

CONFIGURE OBSOLETE ON

Question 10

Which RMAN command allows you to verify that all database files are present and accessible without performing a full backup?

Accepted Answer

CROSSCHECK. CROSSCHECK verifies the status of files in the catalog against the physical files on disk.

Answer

REPORT NEED BACKUP

Answer

LIST FILE

Answer

VALIDATE DATABASE

Question 11

Which RMAN command is used to start an RMAN session?

Accepted Answer

rman target /. The 'rman' command is invoked from the operating system prompt to start the tool.

Answer

run rman

Answer

start rman

Answer

sqlplus rman

Question 12

Which THREE actions are performed during the 'RESTORE DATABASE' command?

Accepted Answer

Restoring datafiles to the disk.. Option A is correct because RESTORE DATABASE is the RMAN phase that reads backup pieces and writes the datafile image copies/backupsets back to their target locations on disk, physically recreating the datafiles. Option B is correct because during restore RMAN updates the control file (or recovery catalog) with the new datafile names/locations and checkpoint information so the repository reflects the restored files. Option D is correct because RMAN validates the backup pieces it reads during restore, checking block headers/checksums and backup metadata to ensure the pieces are usable before writing them out. Option C is not part of RESTORE DATABASE; opening with RESETLOGS is a separate step performed by ALTER DATABASE OPEN RESETLOGS after RECOVER DATABASE. Option E is not part of RESTORE DATABASE either; media recovery is the separate RECOVER DATABASE operation that applies redo/archived logs to make the restored files consistent.

Answer

Opening the database with RESETLOGS.

Answer

Performing media recovery.

Question 13

You want to clear all configured RMAN settings back to their default values. Which command do you use?

Accepted Answer

CONFIGURE [parameter] CLEAR. The RMAN command 'CONFIGURE [parameter] CLEAR' resets the specified configuration parameter back to its default value. For example, 'CONFIGURE RETENTION POLICY CLEAR' restores the default retention policy. This is the documented, supported way to remove a custom RMAN configuration and revert to defaults.

Answer

DELETE CONFIGURATION

Answer

RESET ALL

Answer

CONFIGURE ALL CLEAR

Question 14

When performing a cross-platform transportable tablespace migration, which package is used to check for compatibility and estimate the sizes?

Accepted Answer

DBMS_TTS. DBMS_TDP is not the tool; DBMS_TTS is used for transportable tablespaces.

Answer

DBMS_REPAIR

Answer

DBMS_TRANSPORT

Answer

DBMS_MIGRATION

Question 15

What is the purpose of the 'REPORT OBSOLETE' command?

Accepted Answer

To list backups that exceed the retention policy.. It identifies backups that are no longer needed based on the retention policy.

Answer

To identify corrupted backups.

Answer

To show the status of the FRA.

Answer

To delete old backups.