I85PREP
⌘ K
Oracle Database Administration II study materials
Oracle Database Administration II study resources

Oracle Database Administration II practice questions

One question at a time. Build your Oracle Database Administration II understanding.

First 50 of 200 questions. Each one lists the choices, the correct answer, and an explanation. The checker at the top of this page saves progress in this browser when it is available.

Continue in the practice tool above to load more questions, 50 at a time.

Question 1Backup and Recovery: RMAN Configuration and Backup Strategies

In a recovery catalog environment, which RMAN command registers a brand-new target database with the catalog without creating any backup?

  1. CONFIGURE CATALOG
  2. CREATE CATALOG
  3. REGISTER DATABASE Correct answer.
  4. RESYNC CATALOG

Explanation

The REGISTER DATABASE command connects to the target and inserts the database metadata into the recovery catalog so that later backups are recorded there. It does not create a backup; it only enrolls the target. CREATE CATALOG builds the catalog schema itself, not a target registration.

Question 2Backup and Recovery: RMAN Configuration and Backup Strategies

Which retention policy setting lets RMAN decide how many backups to keep based on a time window rather than a fixed count?

  1. CONFIGURE ARCHIVELOG DELETION POLICY
  2. CONFIGURE BACKUP OPTIMIZATION ON
  3. CONFIGURE RETENTION POLICY TO REDUNDANCY n
  4. CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF n DAYS Correct answer.

Explanation

A recovery window retention policy keeps every backup needed to recover the database to any point within the specified number of days. Redundancy is count-based rather than time-based. Backup optimization and archivelog deletion policy address different concerns.

Question 3Backup and Recovery: RMAN Configuration and Backup Strategies

You want RMAN to write image copies of datafiles to a fast recovery area and also create a backup set on tape. Which configuration most directly directs automatic backups to both destinations?

  1. CONFIGURE DEFAULT DEVICE TYPE TO DISK
  2. CONFIGURE BACKUP COPIES FOR DEVICE TYPE DISK TO 2
  3. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2
  4. CONFIGURE CHANNEL DEVICE TYPE sbt PARMS 'ENV=(TAPE)'; CONFIGURE CHANNEL DEVICE TYPE DISK Correct answer.

Explanation

Defining both a disk channel and an sbt channel makes RMAN allocate both device types for a backup, writing to each destination. A single DEFAULT DEVICE TYPE limits automatic allocation to one device. The BACKUP COPIES settings control duplicate copies on the same device type, not different media.

Question 4Backup and Recovery: RMAN Configuration and Backup Strategies

Which RMAN command produces a report of backup files that are no longer needed to satisfy the current retention policy?

  1. REPORT NEED BACKUP
  2. LIST EXPIRED BACKUP
  3. REPORT OBSOLETE Correct answer.
  4. CROSSCHECK BACKUP

Explanation

REPORT OBSOLETE lists backups that fall outside the retention policy and can be deleted. REPORT NEED BACKUP lists files that require a new backup because existing backups are insufficient. LIST EXPIRED and CROSSCHECK deal with missing or out-of-sync backup records.

Question 5Backup and Recovery: RMAN Configuration and Backup Strategies

After a datafile is added to the target database, which action ensures the recovery catalog contains the new file before the next backup?

  1. Run RESYNC CATALOG or let the next backup resynchronize automatically Correct answer.
  2. Drop and re-register the target database
  3. Re-run CREATE CATALOG
  4. Run CROSSCHECK DATAFILE

Explanation

A resynchronization copies control file metadata, including newly added datafiles, into the recovery catalog. RMAN also performs an implicit resync during backup operations. Recreating the catalog or re-registering the database is unnecessary and destructive.

Question 6Backup and Recovery: RMAN Configuration and Backup Strategies

You configure CONFIGURE BACKUP OPTIMIZATION ON. Which backup is most likely to be skipped as a result?

  1. An incremental level 0 backup of a frequently changed tablespace
  2. A full backup of a read-only tablespace already backed up after its last change Correct answer.
  3. A backup of the control file after a structural change
  4. An archived redo log backup of newly archived logs

Explanation

Backup optimization skips files that are identical to an existing backup, such as read-only or offline datafiles unchanged since the last backup. Frequently changed data and newly archived logs still require backup. The control file is always backed up when required.

Question 7Backup and Recovery: RMAN Configuration and Backup Strategies

Which RMAN feature lets you test whether a backup can be restored without actually restoring datafiles to disk?

  1. VALIDATE BACKUP
  2. REPORT SCHEMA
  3. RESTORE ... PREVIEW Correct answer.
  4. CROSSCHECK BACKUP

Explanation

RESTORE ... PREVIEW lists the backups that would be used for a restore without performing it, confirming availability and plan. VALIDATE checks block integrity of backups. CROSSCHECK verifies media existence, and REPORT SCHEMA describes database structure.

Question 8Backup and Recovery: RMAN Configuration and Backup Strategies

Which command configures RMAN to automatically back up the control file and server parameter file whenever a backup or copy of datafile 1 occurs?

  1. CONFIGURE CONTROLFILE AUTOBACKUP ON Correct answer.
  2. BACKUP CURRENT CONTROLFILE
  3. ALTER DATABASE BACKUP CONTROLFILE
  4. CONFIGURE SNAPSHOT CONTROLFILE

Explanation

CONFIGURE CONTROLFILE AUTOBACKUP ON makes RMAN automatically create a control file autobackup after certain operations, including backups that include datafile 1. This enables recovery of the control file and spfile even without a catalog. The other commands are one-time or unrelated actions.

Question 9Backup and Recovery: RMAN Configuration and Backup Strategies

An RMAN backup job fails because the fast recovery area is full. Which configuration change most directly reduces future space pressure from archived logs?

  1. Increase DB_RECOVERY_FILE_DEST_SIZE
  2. Configure a larger REDUNDANCY value
  3. Set BACKUP OPTIMIZATION OFF
  4. Set ARCHIVELOG DELETION POLICY TO BACKED UP 1 TIMES TO DISK Correct answer.

Explanation

An archivelog deletion policy that permits deletion once logs are backed up allows RMAN to remove archived logs from the fast recovery area after they are safely copied. Increasing the area size only postpones the problem. Larger redundancy retains more backups and worsens pressure.

Question 10Backup and Recovery: RMAN Configuration and Backup Strategies

Which RMAN command creates an incremental backup that captures all blocks changed since the most recent level 1 backup?

  1. BACKUP INCREMENTAL LEVEL 0 DATABASE
  2. BACKUP INCREMENTAL LEVEL 1 DATABASE Correct answer.
  3. BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE
  4. BACKUP INCREMENTAL LEVEL 1 DIFFERENTIAL DATABASE

Explanation

A level 1 differential backup, which is the default for level 1, includes blocks changed since the last level 1 or level 0 backup. A cumulative level 1 captures changes since the last level 0. Level 0 is a full baseline backup.

Question 11Backup and Recovery: RMAN Configuration and Backup Strategies

What is the primary benefit of enabling block change tracking for incremental backups?

  1. It allows RMAN to read only changed blocks from a change tracking file instead of scanning all blocks Correct answer.
  2. It reduces the size of archived redo logs
  3. It eliminates the need for a level 0 baseline
  4. It compresses backup sets automatically

Explanation

Block change tracking records which blocks have changed since the last backup, so RMAN can read only those blocks during an incremental backup. This speeds up incremental backups without affecting redo generation or eliminating the baseline.

Question 12Backup and Recovery: RMAN Configuration and Backup Strategies

Which RMAN command verifies that backup pieces recorded in the repository still exist on the media and marks missing ones as expired?

  1. DELETE EXPIRED BACKUP
  2. CROSSCHECK BACKUP Correct answer.
  3. VALIDATE BACKUP
  4. REPORT UNRECOVERABLE

Explanation

CROSSCHECK BACKUP compares repository records with the actual media and marks missing files as expired. DELETE EXPIRED then removes those expired records. VALIDATE checks block integrity of files that are present.

Question 13Backup and Recovery: RMAN Configuration and Backup Strategies

You want RMAN to keep three full backups of the database and delete older ones automatically. Which configuration achieves this?

  1. CONFIGURE RETENTION POLICY TO REDUNDANCY 3 Correct answer.
  2. CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 3 DAYS
  3. CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY
  4. CONFIGURE BACKUP COPIES FOR DEVICE TYPE DISK TO 3

Explanation

REDUNDANCY 3 keeps three backups of each file and makes older ones obsolete. A recovery window of three days is time-based, not count-based. BACKUP COPIES creates multiple copies in a single backup operation, which is a different concept.

Question 14Backup and Recovery: RMAN Configuration and Backup Strategies

Which statement about RMAN persistent configuration settings is correct?

  1. They are lost when the instance restarts
  2. They are stored in the target database control file and optionally in the recovery catalog Correct answer.
  3. They are stored only in the server parameter file
  4. They can be set only at session level with SET

Explanation

CONFIGURE settings are persistent and stored in the target control file, and they are also stored in the recovery catalog when one is used. Session-level SET commands apply only to the current job. The SPFILE does not hold RMAN configuration.

Question 15Backup and Recovery: RMAN Configuration and Backup Strategies

Which command displays all current RMAN persistent configuration settings for the target database?

  1. SHOW ALL Correct answer.
  2. SHOW CONFIGURATION
  3. REPORT CONFIGURATION
  4. LIST CONFIGURATION

Explanation

SHOW ALL displays every persistent configuration setting, including defaults. Individual settings can be viewed with SHOW followed by the parameter name. The other forms are not valid RMAN commands for this purpose.

Question 16Backup and Recovery: RMAN Configuration and Backup Strategies

A backup set is created with CONFIGURE COMPRESSION ALGORITHM 'MEDIUM'. Which statement best describes the effect?

  1. Backup pieces are compressed using the medium compression level for supported backup types Correct answer.
  2. The backup is compressed only if the database is in ARCHIVELOG mode
  3. Compression applies only to archived redo log backups
  4. Only image copies are compressed

Explanation

The compression algorithm configuration sets the compression level used when RMAN creates compressed backup sets. It applies to backup sets for supported file types, not to image copies. Archivelog mode does not determine whether compression is applied.

Question 17Backup and Recovery: RMAN Configuration and Backup Strategies

Which RMAN command creates a backup of the database plus archived logs and then deletes the input archived logs after the backup succeeds?

  1. BACKUP DATABASE ARCHIVELOG ALL
  2. BACKUP ARCHIVELOG ALL DELETE ALL INPUT
  3. BACKUP DATABASE PLUS ARCHIVELOG
  4. BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT Correct answer.

Explanation

BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT backs up the database and archived logs and removes the input archived logs after a successful backup. Without DELETE INPUT, logs remain on disk. DELETE ALL INPUT removes logs from all destinations.

Question 18Backup and Recovery: RMAN Configuration and Backup Strategies

Which RMAN command generates a script that can be used to recreate the control file?

  1. RESTORE CONTROLFILE FROM AUTOBACKUP
  2. BACKUP CURRENT CONTROLFILE
  3. ALTER DATABASE BACKUP CONTROLFILE TO TRACE Correct answer.
  4. REPORT SCHEMA

Explanation

ALTER DATABASE BACKUP CONTROLFILE TO TRACE writes a SQL script to the trace directory that can recreate the control file. BACKUP CURRENT CONTROLFILE creates an RMAN backup, not a trace script. RESTORE CONTROLFILE recovers a control file.

Question 19Backup and Recovery: RMAN Configuration and Backup Strategies

Which configuration determines the directory where RMAN writes backup pieces when no channel is explicitly allocated?

  1. CONFIGURE DEFAULT DEVICE TYPE
  2. DB_RECOVERY_FILE_DEST
  3. CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT Correct answer.
  4. CONFIGURE BACKUP TYPE

Explanation

When no channel is allocated, RMAN uses configured default channels, and the FORMAT clause on a configured disk channel specifies the output location and naming. DB_RECOVERY_FILE_DEST is used only if no format or other destination is configured. DEFAULT DEVICE TYPE selects the device class, not the directory.

Question 20Backup and Recovery: RMAN Configuration and Backup Strategies

Which RMAN command reports which datafiles need a new backup because their existing backups are older than the retention policy requires?

  1. REPORT UNRECOVERABLE
  2. LIST BACKUP SUMMARY
  3. REPORT OBSOLETE
  4. REPORT NEED BACKUP Correct answer.

Explanation

REPORT NEED BACKUP lists files that require a new backup to satisfy the retention policy, based on changes or age. REPORT OBSOLETE lists backups that can be deleted. LIST BACKUP SUMMARY and REPORT UNRECOVERABLE serve different diagnostic purposes.

Question 21Backup and Recovery: RMAN Configuration and Backup Strategies

After you change the retention policy from redundancy to a recovery window, which command removes backups that are now obsolete?

  1. DELETE OBSOLETE Correct answer.
  2. DELETE BACKUP ALL
  3. DELETE EXPIRED
  4. CROSSCHECK BACKUP

Explanation

DELETE OBSOLETE removes backups and archived logs that are no longer required by the current retention policy. DELETE EXPIRED removes records for files already missing from media. CROSSCHECK only updates status, and DELETE BACKUP ALL removes everything.

Question 22Backup and Recovery: RMAN Configuration and Backup Strategies

Which statement about encrypted RMAN backups using transparent encryption with a wallet is correct?

  1. Encryption prevents RMAN from compressing backup sets
  2. The wallet must be open for RMAN to create or restore encrypted backups Correct answer.
  3. The wallet is needed only when a recovery catalog is used
  4. The wallet is required only for tape backups

Explanation

With transparent encryption, the master key is stored in an Oracle wallet, and the wallet must be open so RMAN can access the key for backup or restore. Tape usage and catalog usage do not change this requirement. Compression can still be applied to encrypted backups.

Question 23Backup and Recovery: RMAN Configuration and Backup Strategies

Which RMAN command is used to create a duplicate copy of a database for testing from an existing backup?

  1. RESTORE DATABASE TO testdb
  2. CLONE DATABASE testdb
  3. CREATE DATABASE testdb AS COPY
  4. DUPLICATE TARGET DATABASE TO testdb Correct answer.

Explanation

DUPLICATE TARGET DATABASE TO testdb creates a database copy using backups or active files, depending on the options used. RESTORE DATABASE restores to the same database identity. CREATE DATABASE AS COPY and CLONE DATABASE are not valid RMAN commands.

Question 24Backup and Recovery: RMAN Configuration and Backup Strategies

Which configuration allows RMAN to use a snapshot control file when backing up a database in a RAC environment?

  1. CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/backup/%U'
  2. CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/shared/snapcf.ctl' Correct answer.
  3. CONFIGURE BACKUP OPTIMIZATION ON
  4. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/backup/%F'

Explanation

The snapshot control file must reside on a shared location accessible to all RAC instances, and its name and path are set with CONFIGURE SNAPSHOT CONTROLFILE NAME. The other settings control autobackup naming, channel output format, and optimization, none of which place the snapshot control file.

Question 25Backup and Recovery: RMAN Configuration and Backup Strategies

Which RMAN command removes records of expired backups from the recovery catalog and control file?

  1. LIST EXPIRED BACKUP
  2. DELETE OBSOLETE
  3. DELETE EXPIRED BACKUP Correct answer.
  4. CROSSCHECK BACKUP

Explanation

DELETE EXPIRED BACKUP purges repository records that CROSSCHECK has marked as expired because the files are missing. CROSSCHECK only marks them expired. DELETE OBSOLETE removes policy-obsolete backups, and LIST EXPIRED only reports them.

Question 26Backup and Recovery: RMAN Configuration and Backup Strategies

Which RMAN command assigns a persistent channel configuration so that every backup and restore operation uses the same disk destination without repeating ALLOCATE CHANNEL in each job?

  1. SET CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u01/rman/%F'
  2. CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/u01/rman/%U' Correct answer.
  3. CONFIGURE DEFAULT DEVICE TYPE TO DISK
  4. BACKUP DATABASE FORMAT '/u01/rman/%U'

Explanation

CONFIGURE CHANNEL persists channel attributes, including the FORMAT used for output file names, so subsequent jobs automatically use that disk destination. The setting is stored in the target control file and applies to every job until it is changed or cleared.

Question 27Backup and Recovery: RMAN Configuration and Backup Strategies

You want RMAN to write a backup of the database to disk and simultaneously send the same backup set to a tape library, with each channel producing its own copy. Which command structure achieves this?

  1. BACKUP DATABASE PLUS ARCHIVELOG;
  2. BACKUP DATABASE COPIES 2; Correct answer.
  3. CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
  4. BACKUP DATABASE; then BACKUP BACKUPSET ALL;

Explanation

The COPIES clause tells RMAN to produce multiple identical copies of each backup piece within the same job, one per allocated channel. It requires at least two channels, for example a disk channel and an SBT channel, so each copy lands on different media.

Question 28Backup and Recovery: RMAN Configuration and Backup Strategies

A database runs in ARCHIVELOG mode and you issue BACKUP DATABASE PLUS ARCHIVELOG. In what order does RMAN normally perform the work?

  1. It switches the logfile, backs up the archived logs, backs up the datafiles, then switches again and backs up the newly archived logs. Correct answer.
  2. It backs up the archived logs, then the datafiles, then switches the log and backs up the remaining archived logs.
  3. It backs up only the datafiles and leaves archived logs to the next job.
  4. It backs up the datafiles first, then switches and backs up archived logs, then backs up the control file.

Explanation

PLUS ARCHIVELOG brackets the datafile backup: RMAN first archives the current log, backs up the archived logs, then backs up the datafiles, and finally archives and backs up logs generated during the backup. This ordering yields a consistent recoverable set even while the database is open.

Question 29Backup and Recovery: RMAN Configuration and Backup Strategies

You need a backup of the database that can be used immediately as a fully independent copy on the same host without performing a restore. Which RMAN operation produces this?

  1. BACKUP DATABASE INCREMENTAL LEVEL 0;
  2. BACKUP DATABASE VALIDATE;
  3. BACKUP DATABASE COPY;
  4. DUPLICATE DATABASE ... TO ...; Correct answer.

Explanation

DUPLICATE creates a new database from backups, producing a ready-to-open copy rather than a backup set that still needs restoring. It can target the same host with a different DB_NAME and directory layout.

Question 30Backup and Recovery: RMAN Configuration and Backup Strategies

You configure CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY and run DELETE ARCHIVELOG ALL on the primary. Which behavior should you expect?

  1. Archived logs are deleted only after they have been applied on every mandatory remote standby destination. Correct answer.
  2. All archived logs on the primary are deleted regardless of whether a standby has consumed them.
  3. The command fails because a deletion policy cannot be combined with an explicit DELETE ARCHIVELOG command.
  4. Archived logs are deleted only after they are backed up at least once by RMAN.

Explanation

Without ALL, APPLIED ON STANDBY requires redo application at all mandatory remote standby destinations before archived logs become eligible for deletion. DELETE ARCHIVELOG ALL honors this policy; the ALL in the DELETE command does not expand the policy to optional standby destinations.

Question 31Backup and Recovery: Restore and Recovery Operations

A data file belonging to the USERS tablespace is accidentally deleted while the database is open. You have a full backup plus archived redo logs and the control file is intact. Which RMAN command performs the minimal recovery needed to bring the tablespace back online?

  1. RESTORE TABLESPACE users; RECOVER TABLESPACE users; Correct answer.
  2. RESTORE DATAFILE 7; RECOVER DATAFILE 7;
  3. RECOVER DATAFILE 7; only
  4. RESTORE DATABASE; RECOVER DATABASE;

Explanation

Tablespace point-in-time style recovery at the tablespace level is supported when the database is open and the tablespace is taken offline; RMAN restores only the data files of that tablespace and applies redo to them. A tablespace-level RESTORE followed by RECOVER is the minimal unit that returns the whole tablespace consistently. Restoring the whole database is unnecessary and would require a mount state.

Question 32Backup and Recovery: Restore and Recovery Operations

Which view should you query to determine which archived redo log sequence is required to recover a specific data file to the current SCN?

  1. V$BACKUP_REDOLOG
  2. V$RECOVER_FILE Correct answer.
  3. V$LOG_HISTORY
  4. V$DATAFILE_HEADER

Explanation

V$RECOVER_FILE lists data files that require media recovery and shows the error and the SCN at which recovery must start, which lets you reason about which archived logs are needed. V$DATAFILE_HEADER shows header status and checkpoint information but not the recovery requirement per file. V$LOG_HISTORY and V$BACKUP_REDOLOG list log history and backed-up logs, not the files needing recovery.

Question 33Backup and Recovery: Restore and Recovery Operations

You issue RECOVER DATABASE and Oracle returns ORA-00279 asking for archived log sequence 145, but that log was never archived because the archive destination filled. What is the correct action?

  1. Restore an older backup and perform incomplete recovery to a point before sequence 145.
  2. Supply the online redo log containing sequence 145 with the RECOVER command if it is still available. Correct answer.
  3. Delete the data file and recreate the tablespace from export.
  4. Cancel recovery and open the database with RESETLOGS immediately.

Explanation

If an archived log is missing but the corresponding online redo log still exists and has not been overwritten, RMAN can apply it by specifying the log sequence during recovery. This avoids losing committed transactions that are present only in online redo logs. Only when no copy of the redo exists must you fall back to incomplete recovery.

Question 34Backup and Recovery: Restore and Recovery Operations

What is the primary purpose of the RECOVER ... TEST clause during media recovery?

  1. It performs recovery in parallel across all channels.
  2. It reports which redo logs would be read without applying them. Correct answer.
  3. It validates the backup piece checksums before restoring.
  4. It applies redo to a shadow copy of the data files.

Explanation

RECOVER TEST performs a trial run that reads the required backups and redo and reports what would be used, without modifying data files. It is used to verify that all necessary archived logs exist before committing to a real recovery. It does not apply redo or change file contents.

Question 35Backup and Recovery: Restore and Recovery Operations

A block corruption is reported in data file 4, block 128, and you have a physical backup. Which RMAN command repairs only the affected block while the database remains open?

  1. RECOVER DATAFILE 4 BLOCK 128;
  2. VALIDATE DATAFILE 4 BLOCK 128;
  3. BLOCKRECOVER DATAFILE 4 BLOCK 128; Correct answer.
  4. RESTORE DATAFILE 4; RECOVER DATAFILE 4;

Explanation

BLOCKRECOVER uses the block media recovery feature to restore and recover a single corrupted block from a backup while the rest of the data file and database stay online. It is the least intrusive repair for isolated block corruption. Full data file restore is unnecessary when only one block is damaged.

Question 36Backup and Recovery: Restore and Recovery Operations

Which statement about point-in-time recovery using RMAN is correct?

  1. It requires the database to be opened with RESETLOGS after recovery completes. Correct answer.
  2. It can only be performed to an SCN, never to a timestamp.
  3. It automatically deletes archived logs generated after the target time.
  4. It must always recover the entire database to the end of redo.

Explanation

Any incomplete recovery, including point-in-time recovery, must be followed by opening the database with RESETLOGS because the redo stream is reset and a new incarnation begins. RMAN supports SET UNTIL TIME, SCN, SEQUENCE, and RESTORE POINT targets. Logs after the target are not automatically deleted.

Question 37Backup and Recovery: Restore and Recovery Operations

During restore you receive RMAN-06023 (no backup or copy of the file found). The backup exists on tape but the channel is configured for disk only. What is the most direct fix?

  1. Run CROSSCHECK and then DELETE EXPIRED.
  2. Set DB_RECOVERY_FILE_DEST to the tape location.
  3. Recreate the control file with CATALOG START WITH.
  4. Allocate a channel of type SBT and rerun the restore. Correct answer.

Explanation

RMAN can only read backups through channels of the appropriate device type. If the backup resides on tape, a channel of type SBT must be allocated so RMAN can access the media manager. Disk-only channels cannot see tape backups regardless of catalog entries.

Question 38Backup and Recovery: Restore and Recovery Operations

What does the RMAN command RESTORE DATABASE VALIDATE accomplish?

  1. It reads the backups and verifies they can be restored without writing data files. Correct answer.
  2. It restores the database and opens it read-only for verification.
  3. It compares data file contents to the control file checksums.
  4. It performs a full recovery to the current SCN in a clone directory.

Explanation

RESTORE ... VALIDATE reads backup pieces and checks their integrity and availability, confirming that a restore would succeed, but it does not actually write data files. It is a rehearsal used to prove backup usability. No recovery or open is performed.

Question 39Backup and Recovery: Restore and Recovery Operations

You must recover a dropped table named ORDERS that was dropped two hours ago, without affecting other objects. Which capability is designed for this?

  1. Flashback Database to a restore point before the drop.
  2. Flashback Table using the recycle bin. Correct answer.
  3. Use BLOCKRECOVER on the ORDERS segment.
  4. Restore and recover the whole database to two hours ago.

Explanation

FLASHBACK TABLE ... TO BEFORE DROP uses the recycle bin to reinstate a dropped table and its dependent objects without a full restore. It is the least disruptive option when the object is still in the recycle bin. The other methods affect broader scope or address different problems.

Question 40Backup and Recovery: Restore and Recovery Operations

Which prerequisite is required before you can use FLASHBACK DATABASE?

  1. The recycle bin must be enabled for all users.
  2. A guaranteed restore point must exist for every tablespace.
  3. The database must be in NOARCHIVELOG mode with a recent full backup.
  4. The database must be in ARCHIVELOG mode. Correct answer.

Explanation

ARCHIVELOG mode is required for Flashback Database. Ordinary flashback logging supports rewinding within the available flashback history, but a guaranteed restore point can retain the information needed to return to that point even when ordinary flashback logging is off.

Question 41Backup and Recovery: Restore and Recovery Operations

After an incomplete recovery to SCN 5000 you open with RESETLOGS. What happens to the previous incarnation's archived logs in the RMAN repository?

  1. They are automatically deleted from disk and catalog.
  2. They remain cataloged and are associated with the prior incarnation. Correct answer.
  3. They are renamed with a new thread number.
  4. They are marked EXPIRED and unusable.

Explanation

RESETLOGS creates a new incarnation, and archived logs from before the reset remain cataloged but are tied to the earlier incarnation. This lets you perform recovery across incarnations if needed. They are not deleted or marked expired by the reset itself.

Question 42Backup and Recovery: Restore and Recovery Operations

What is the effect of the NOREDO option in RESTORE DATABASE?

  1. It restores only data files that were backed up after the last log switch.
  2. It prevents RMAN from reading the control file autobackup.
  3. It restores data files but skips applying archived redo during the restore phase. Correct answer.
  4. It restores the database without validating backup checksums.

Explanation

RESTORE ... NOREDO restores data files and does not apply redo while restoring, which is appropriate when you plan to perform recovery separately or when the backup already includes the needed redo application step. It is distinct from RECOVER, which applies redo. It does not filter files or skip validation.

Question 43Backup and Recovery: Restore and Recovery Operations

A tablespace was dropped and its data files removed, but you have a backup. Which recovery approach restores just that tablespace into the current database?

  1. Restore the control file autobackup and open with RESETLOGS.
  2. FLASHBACK TABLE on every object in the tablespace.
  3. Full database restore to a prior SCN.
  4. Tablespace point-in-time recovery using an auxiliary instance. Correct answer.

Explanation

Tablespace point-in-time recovery uses an auxiliary instance to recover the tablespace to a chosen time and then transports its data files back into the production database. This isolates the operation to the affected tablespace. Full database recovery and flashback table do not fit this scenario.

Question 44Backup and Recovery: Restore and Recovery Operations

Which command displays the SCN and time to which each data file has been recovered, helping confirm recovery completeness?

  1. LIST BACKUP SUMMARY
  2. REPORT SCHEMA
  3. V$DATAFILE_HEADER Correct answer.
  4. V$RMAN_STATUS

Explanation

V$DATAFILE_HEADER exposes each data file's checkpoint SCN and checkpoint time, which reflect how far the file has been recovered. Comparing these values across files confirms consistency. REPORT SCHEMA and LIST BACKUP describe structure and backups, not per-file recovery state.

Question 45Backup and Recovery: Restore and Recovery Operations

You are performing recovery and RMAN requests archived log sequence 210, which exists in the fast recovery area but was deleted. A backup of that log exists. What should RMAN do automatically when the catalog is intact?

  1. Skip sequence 210 and apply later logs.
  2. Restore the archived log from backup and continue recovery. Correct answer.
  3. Abort recovery and require a manual restore.
  4. Open the database with RESETLOGS at sequence 209.

Explanation

When the RMAN repository knows about a backup of the requested archived log, RMAN automatically restores that log and continues recovery without operator intervention. This is a core benefit of using a recovery catalog or control file repository. It does not silently skip redo, which would corrupt consistency.

Question 46Backup and Recovery: Restore and Recovery Operations

What does the RECOVER DATABASE USING BACKUP CONTROLFILE command do?

  1. It creates a new control file from the data file headers.
  2. It restores the control file from backup and then recovers the database.
  3. It applies redo while treating the backup control file as authoritative for file locations. Correct answer.
  4. It recovers only the control file to its latest SCN.

Explanation

USING BACKUP CONTROLFILE tells recovery to use the restored backup control file, which may reference older file names and paths, as the source of truth while applying redo. This is common after restoring a control file that predates file renames. It does not rebuild the control file from data file headers.

Question 47Backup and Recovery: Restore and Recovery Operations

Which parameter must be set so that RMAN can automatically manage the fast recovery area during restore and recovery?

  1. LOG_ARCHIVE_DEST_1 only
  2. DB_RECOVERY_FILE_DEST and DB_RECOVERY_FILE_DEST_SIZE Correct answer.
  3. DB_CREATE_FILE_DEST
  4. CONTROL_FILE_RECORD_KEEP_TIME

Explanation

The fast recovery area is defined by DB_RECOVERY_FILE_DEST (location) and DB_RECOVERY_FILE_DEST_SIZE (quota). RMAN uses this area to stage backups and archived logs during restore and recovery. The other parameters serve different purposes.

Question 48Backup and Recovery: Restore and Recovery Operations

After restoring a data file from a backup taken before a data file resize, recovery fails with a file size error. What is the correct resolution?

  1. Restore a newer backup of the data file that matches the current size.
  2. Open the database with RESETLOGS to bypass the size check.
  3. Delete the data file and let recovery recreate it.
  4. Use ALTER DATABASE DATAFILE ... RESIZE before recovery to match the recorded size. Correct answer.

Explanation

When a restored file is smaller than the size recorded in the control file, resizing it to the recorded size allows redo that extends the file to apply. This preserves the redo chain. Restoring a different backup may not solve the mismatch and loses recovery points.

Question 49Backup and Recovery: Restore and Recovery Operations

Which RMAN feature lets you recover a single pluggable database to a past point in time without affecting other PDBs in a multitenant container database?

  1. BLOCKRECOVER across all PDB data files.
  2. PDB point-in-time recovery using an auxiliary instance. Correct answer.
  3. FLASHBACK DATABASE on the root container only.
  4. Full CDB restore to the target SCN.

Explanation

PDB point-in-time recovery recovers one pluggable database to a chosen time using an auxiliary instance and then plugs it back in, leaving other PDBs untouched. It isolates recovery scope to the affected PDB. Full CDB restore and root-only flashback affect the whole container.

Question 50Backup and Recovery: Restore and Recovery Operations

What is the role of the DBMS_RCVMAN package during RMAN recovery operations?

  1. It encrypts backup pieces.
  2. It schedules automatic backups.
  3. It compiles PL/SQL recovery procedures.
  4. It manages the RMAN recovery catalog schema and metadata. Correct answer.

Explanation

DBMS_RCVMAN is the package that maintains and queries the recovery catalog, storing metadata about backups, copies, and incarnations. RMAN uses it to determine what backups are available for restore. It does not schedule jobs or encrypt backups.