OCP Backup And Recovery — 30 Questions

Question 1

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 2

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 3

You need to perform a table-level point-in-time recovery. Which RMAN command syntax is correct?

Accepted Answer

RECOVER TABLE HR.EMPLOYEES UNTIL SCN 12345;. RECOVER TABLE ... UNTIL SCN is the syntax for table-level recovery.

Answer

RESTORE TABLE ...

Answer

FLASHBACK TABLE ...

Answer

IMPORT TABLE ...

Question 4

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 CONFIGURE ARCHIVELOG BACKUP COPIED command with the TO DEVICE TYPE and num_copies parameters defines the retention policy for archived logs.

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 5

Which TWO RMAN settings significantly improve performance during backup operations on an Exadata system?

Accepted Answer

CONFIGURE BACKUP OPTIMIZATION ON;. Backup optimization and parallelism settings directly impact throughput on high-performance storage.

Answer

CONFIGURE CHANNEL ... RATE 10M;

Answer

CONFIGURE MAXSETSIZE UNLIMITED;

Answer

CONFIGURE CONTROLFILE AUTOBACKUP OFF;

Question 6

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 7

You are migrating an Oracle 23ai database to a different platform with different endianness. Which RMAN command is used to convert the datafiles to the target platform format?

Accepted Answer

RMAN> CONVERT DATAFILE '...' TO PLATFORM '...' FROM PLATFORM '...';. The CONVERT DATAFILE command is required when the source and destination platforms have different endian formats.

Answer

RMAN> CONVERT DATABASE ON TARGET PLATFORM;

Answer

RMAN> RESTORE DATAFILE FROM PLATFORM;

Answer

ALTER DATABASE CONVERT TO PLATFORM;

Question 8

You are performing a cross-platform transportable tablespace migration from Linux to Windows. Which RMAN command is required to convert the datafiles for the destination platform?

Accepted Answer

CONVERT TABLESPACE ... TO PLATFORM 'Microsoft Windows x86 64-bit';. The CONVERT TABLESPACE command is used to change the endian format for cross-platform migrations.

Answer

ALTER TABLESPACE ... CONVERT;

Answer

RMAN TRANSPORT ...

Answer

RMAN COPY ...

Question 9

Your database is in ARCHIVELOG mode. You accidentally dropped a critical tablespace and need to perform a Tablespace Point-in-Time Recovery (TSPITR). What is the primary requirement for the auxiliary instance during this process?

Accepted Answer

The auxiliary instance must have enough disk space to hold the tablespace being recovered.. TSPITR requires an auxiliary instance to recover the tablespace to the desired point in time before importing it back to the target database.

Answer

The auxiliary instance must have the same DBID as the target database.

Answer

The auxiliary instance must be configured with a separate ORACLE_HOME.

Answer

The auxiliary instance must be started in NOMOUNT mode manually by the DBA.

Question 10

Which TWO actions are required to enable Flashback Database on a production environment?

Accepted Answer

Ensure the database is in ARCHIVELOG mode.. Flashback Database requires the database to be in ARCHIVELOG mode and the recovery area to be configured.

Answer

Restart the database in UPGRADE mode.

Answer

Set DB_RECOVERY_FILE_DEST_SIZE to zero.

Answer

Drop all existing restore points.

Question 11

Which THREE features are required for using Flashback Database?

Accepted Answer

A Fast Recovery Area (FRA) must be configured.. Flashback Database requires the recovery area, flashback logs, and the database to be in ARCHIVELOG mode.

Answer

The database must be in NOARCHIVELOG mode.

Answer

The database must be a standby.

Question 12

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 13

Which TWO RMAN configurations are recommended to optimize backup performance in a high-transaction environment?

Accepted Answer

CONFIGURE DEVICE TYPE DISK PARALLELISM 4;. Parallelism and block change tracking are primary performance tuners.

Answer

CONFIGURE COMPRESSION ALGORITHM 'MEDIUM';

Answer

CONFIGURE MAXSETSIZE TO 10G;

Answer

CONFIGURE CONTROLFILE AUTOBACKUP OFF;

Question 14

You are configuring a RMAN backup strategy for a multitenant container database (CDB) and want to ensure that a backup of the root container also includes all PDBs. Which configuration command achieves this automatically?

Accepted Answer

BACKUP DATABASE. The 'CONFIGURE PDB BACKUP OPTIMIZATION ON' command is not for this, but 'CONFIGURE BACKUP OPTIMIZATION ON' is standard. Specifically, 'BACKUP DATABASE' in a CDB context handles all PDBs unless excluded.

Answer

CONFIGURE INCLUDE PDB BACKUP ON

Answer

CONFIGURE CDB BACKUP ALL ON

Answer

BACKUP CONTAINER ALL

Question 15

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 16

Which THREE conditions must be met to perform a successful RMAN cross-platform transportable tablespace migration?

Accepted Answer

The RMAN CONVERT command must be used if endianness differs.. The databases must be at compatible levels, endian formats must be checked, and the tablespace must be read-only.

Answer

The source platform must be the same endian as the target.

Answer

The source and destination databases must have the same DBID.

Question 17

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. Datafiles in a platform with different endianness must be converted using the CONVERT command to be readable by the target instance.

Answer

Redo log files

Answer

Parameter files

Answer

Control files

Question 18

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.. Row movement must be enabled for the table to move rows back to their original IDs, and flashback must be enabled.

Answer

The table must have a Primary Key.

Answer

The database must be in ARCHIVELOG mode.

Answer

The Recycle Bin must be disabled.

Question 19

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

Accepted Answer

The output file is an exact image copy of the datafile.. A backup copy is a direct image copy, not an RMAN backup set, and is stored as an exact bit-for-bit file.

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 20

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