OCP Backup And Recovery Practice Test 6 — 15 Questions

Question 1

What is the default location for RMAN backups if no FRA is configured?

Accepted Answer

The current working directory of the RMAN session.. If no Fast Recovery Area (FRA) is configured, RMAN backups default to the current working directory of the RMAN session. This means the backup pieces are created in the directory from which the RMAN client was invoked, unless an explicit format or location is specified.

Answer

The system tablespace.

Answer

The database home directory.

Answer

The redo log path.

Question 2

In a multitenant environment, what is the best approach to backup only a specific PDB?

Accepted Answer

BACKUP PLUGGABLE DATABASE pdb_name. The correct RMAN syntax to back up a single pluggable database from the root container is BACKUP PLUGGABLE DATABASE pdb_name. This command must be executed while connected to the root (CDB$ROOT) and targets only the specified PDB's datafiles, control file, and archived logs as applicable. It is the documented, supported way to isolate a PDB backup in a multitenant architecture.

Answer

BACKUP CDB PDB pdb_name

Answer

BACKUP DATABASE PDBNAME

Answer

BACKUP PDB ALL

Question 3

Which THREE are true regarding the use of 'FLASHBACK DATABASE'?

Accepted Answer

It can be performed on a closed database.. It requires FRA, archivelog mode, and flashback logs.

Answer

It deletes all archivelogs.

Answer

It requires the database to be in open state.

Question 4

You are restoring a database and need to use a backup control file. Which clause is mandatory in the recover command?

Accepted Answer

USING BACKUP CONTROLFILE. The 'USING BACKUP CONTROLFILE' clause is required when you are not using the current control file.

Answer

WITH EXTERNAL CONTROLFILE

Answer

RECOVER CONTROLFILE

Answer

USING OLD CONTROLFILE

Question 5

You are performing a cross-platform data migration from a Linux-based Oracle 23ai source database to a Solaris target. You intend to use RMAN CONVERT DATABASE. Which prerequisite must be met to ensure the migration succeeds?

Accepted Answer

The source and target platforms must have the same endian format.. When converting a database using RMAN, the source and target platforms must have the same endian format, or the conversion must be done via transportable tablespaces if the endianness differs. RMAN CONVERT DATABASE requires the platforms to share endianness.

Answer

The source database must use Automatic Storage Management (ASM).

Answer

The target database must be in ARCHIVELOG mode before starting the conversion.

Answer

The source database must be in restricted mode.

Question 6

You are configuring RMAN to store backup metadata in a Recovery Catalog. What is the benefit of using a catalog over the target database control file for long-term backup retention?

Accepted Answer

It supports storing backup metadata for longer than the control_file_record_keep_time initialization parameter.. A recovery catalog provides a persistent repository that is independent of the target database control file, allowing for retention periods longer than the control_file_record_keep_time.

Answer

It allows RMAN to perform backups while the database is in NOARCHIVELOG mode.

Answer

It automatically encrypts all RMAN backup sets.

Answer

It is required for using the RECOVERY WINDOW retention policy.

Question 7

You need to perform a full database restore and recovery. The control file is lost. What is the correct sequence of operations?

Accepted Answer

STARTUP NOMOUNT; RESTORE CONTROLFILE FROM AUTOBACKUP; ALTER DATABASE MOUNT; RESTORE DATABASE; RECOVER DATABASE; ALTER DATABASE OPEN RESETLOGS;. After losing the control file, you must restore it from an autobackup before you can restore the datafiles and perform recovery.

Answer

RESTORE DATABASE; RECOVER DATABASE; ALTER DATABASE OPEN RESETLOGS;

Answer

RESTORE SPFILE; STARTUP MOUNT; RECOVER DATABASE; ALTER DATABASE OPEN;

Answer

FLASHBACK DATABASE TO RESTORE POINT; ALTER DATABASE OPEN;

Question 8

Which THREE operations are automatically performed by RMAN when executing the 'RECOVER TABLE' command?

Accepted Answer

Exporting the recovered table to the target database using Data Pump. RECOVER TABLE is an RMAN command that performs a table-level point-in-time recovery by leveraging an auxiliary instance and a temporary auxiliary destination. Option B is correct because RMAN restores the tablespace(s) containing the target table to an auxiliary location (the auxiliary destination) rather than to the production datafiles. Option D is correct because RMAN automatically creates an auxiliary instance (spawned from the target database) to perform the recovery work. Option A is correct because, after the table is recovered in the auxiliary instance, RMAN uses Data Pump to export the table and then imports it into the target database. Option C is incorrect because RECOVER TABLE does not delete backups older than the restore point; backup retention is governed by the configured retention policy, not by this command. Option E is incorrect because RMAN never automatically converts the database to NOARCHIVELOG mode; ARCHIVELOG mode is required for this operation and is not changed by RECOVER TABLE.

Answer

Automatic deletion of all backups older than the restore point

Answer

Automatic conversion of the database to NOARCHIVELOG mode

Question 9

You need to back up only the archived redo log files that have not yet been backed up, and then delete the input files after the backup completes. Which RMAN command accomplishes this?

Accepted Answer

BACKUP ARCHIVELOG NOT BACKED UP DELETE INPUT;. The requirement is to back up only archived redo log files that have not yet been backed up. RMAN provides the NOT BACKED UP clause specifically for this purpose. Combining it with DELETE INPUT removes the input files after a successful backup. The other options either back up all archived logs or use a time-based filter, which does not guarantee that only unbacked-up logs are processed.

Answer

BACKUP ARCHIVELOG ALL DELETE INPUT;

Answer

BACKUP ARCHIVELOG ALL DELETE ALL INPUT;

Answer

BACKUP ARCHIVELOG FROM TIME 'SYSDATE-1' DELETE INPUT;

Question 10

You are administering an Oracle 23ai database in ARCHIVELOG mode. A data block in a frequently updated table is logically corrupted. You want to repair only that block while the database remains open and users continue to access other parts of the table. Which RMAN command should you use?

Accepted Answer

RECOVER DATAFILE 5 BLOCK 1234;. Block-level recovery with RECOVER DATAFILE ... BLOCK ... is designed to repair individual corrupt blocks online. It restores the block from a backup and applies archived redo to make it consistent, all while the database is open. The other commands either recover too much, revert the whole database, or only diagnose the problem. This makes block-level recovery the precise solution for the scenario.

Answer

FLASHBACK DATABASE TO BEFORE CORRUPTION;

Answer

VALIDATE DATAFILE 5;

Answer

RECOVER DATAFILE 5;

Question 11

You are configuring RMAN to use a media manager for tape backups. Which component must be installed and configured on the database server to enable RMAN to communicate with the media manager?

Accepted Answer

Media Management Library (MML) provided by the media manager vendor. To use RMAN with a media manager for tape backups, the media manager vendor must provide a Media Management Library (MML) that implements the Oracle SBT (System Backup to Tape) API. This library is installed on the database server and referenced by Oracle. Without it, RMAN cannot send commands to the tape subsystem. Other components like OSB, Data Guard broker, or a recovery catalog are not required for this specific integration.

Answer

Oracle Secure Backup (OSB) client

Answer

Oracle Recovery Manager (RMAN) catalog database

Answer

Oracle Data Guard broker

Question 12

You are configuring RMAN backups for an Oracle 23ai database. You want to ensure that RMAN automatically deletes archived redo logs from the fast recovery area after they have been backed up to tape and are no longer needed for recovery. Which command should you execute?

Accepted Answer

CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 1 TIMES TO 'SBT_TAPE';. The ARCHIVELOG DELETION POLICY determines when RMAN can delete archived redo logs from the FRA. Setting it to BACKED UP 1 TIMES TO 'SBT_TAPE' ensures that logs are only deleted after they are backed up to tape. This prevents premature deletion and frees FRA space automatically. The other options either set retention for backups, perform a one-time deletion, or optimize backups without addressing log deletion.

Answer

CONFIGURE BACKUP OPTIMIZATION ON;

Answer

BACKUP ARCHIVELOG ALL DELETE INPUT;

Answer

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 14 DAYS;

Question 13

You need to perform an incomplete recovery of your Oracle 23ai database to a specific SCN. The database is in ARCHIVELOG mode. Which RMAN command sequence correctly performs this recovery?

Accepted Answer

STARTUP MOUNT; RESTORE DATABASE; RECOVER DATABASE UNTIL SCN 123456; ALTER DATABASE OPEN RESETLOGS;. Incomplete recovery to a specific SCN requires the database to be mounted, data files restored from backup, recovery up to the target SCN, and then opened with RESETLOGS. The RESETLOGS operation is mandatory after any incomplete recovery to reset the online redo logs and create a new database incarnation. Omitting RESTORE or using NOMOUNT would fail, and opening without RESETLOGS is not permitted.

Answer

STARTUP NOMOUNT; RESTORE DATABASE; RECOVER DATABASE UNTIL SCN 123456; ALTER DATABASE OPEN RESETLOGS;

Answer

STARTUP MOUNT; RECOVER DATABASE UNTIL SCN 123456; ALTER DATABASE OPEN;

Answer

STARTUP MOUNT; RESTORE DATABASE; RECOVER DATABASE UNTIL SCN 123456; ALTER DATABASE OPEN;

Question 14

Your Oracle 23ai production database runs in ARCHIVELOG mode with a fast recovery area configured. A media failure destroys the disk holding data file 7 of the SALES tablespace, but the control file and all archived redo logs remain intact. You still have the original data file header information available. Which RMAN command restores data file 7 and then applies only the redo needed to make it consistent, without restoring the entire database?

Accepted Answer

RESTORE DATAFILE 7; then RECOVER DATAFILE 7;. Restoring a single data file requires first bringing back the physical file from a backup, then applying redo to synchronize it with the rest of the database. Because the control file survived, RMAN retains the metadata needed to identify the correct backup and the recovery SCN. This granular approach avoids a full database restore and shortens the outage.

Answer

RESTORE DATABASE; then RECOVER DATABASE;

Answer

RECOVER DATAFILE 7; only, without a preceding RESTORE

Answer

SWITCH DATAFILE 7 TO COPY; then RECOVER DATAFILE 7;

Question 15

You are the DBA for an Oracle 23ai database running in ARCHIVELOG mode with a fast recovery area configured. A user reports that a query against the SALES table returns ORA-01578: ORACLE data block corrupted (file # 7, block # 1482). You want RMAN to repair only the affected block using a backup while the database remains open. Which command should you execute?

Accepted Answer

RECOVER DATAFILE 7 BLOCK 1482;. Block media recovery with RECOVER DATAFILE ... BLOCK ... is designed precisely for isolated corruption reported by ORA-01578 while the database stays open. It restores and recovers only the damaged block from RMAN backups, keeping the rest of the data file online. Validation and whole-file restore/recover are either non-repairing or unnecessarily disruptive for a single corrupt block.

Answer

RESTORE DATAFILE 7 BLOCK 1482;

Answer

RECOVER DATAFILE 7;

Answer

VALIDATE DATAFILE 7;