OCP Backup And Recovery — 15 Questions

Question 1

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 2

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 3

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 4

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 5

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 6

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 7

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 8

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 9

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 10

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 11

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 12

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 13

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 14

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 15

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.