Backup And Recovery

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?

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?

What is the primary purpose of the Flashback Database feature?

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?

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?

A user accidentally dropped a critical table. You decide to use Flashback Table. What is the mandatory prerequisite before this command can execute?

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

Which RMAN command should you use to verify that your backup pieces are not corrupted?

Which command is used to delete backups that are no longer needed based on the current retention policy?

What happens if a block is marked as corrupt during an RMAN backup?

Which TWO statements are true regarding the use of a Recovery Catalog?

How do you check the status of all current RMAN backup jobs?

You are performing a TSPITR (Tablespace Point-in-Time Recovery). What is the purpose of the auxiliary instance?

You are performing an RMAN duplicate database operation. What is the benefit of using the 'FROM ACTIVE DATABASE' clause?

Which THREE are characteristics of Flashback Logs?

If you are in ARCHIVELOG mode, what is the primary benefit of having a multiplexed control file?

Which RMAN command displays the database structure and associated datafiles?

You want to backup the control file automatically whenever a change is made to the database structure. Which command do you use?

You are performing a tablespace recovery. What is the first thing that must happen to the tablespace before recovery can start?

What is the primary function of the RMAN 'SWITCH' command?

You have a standby database and want to offload backups to it. What is the recommended way to register the standby's backups in the recovery catalog?

Which THREE pieces of information are needed to restore a database to a specific point-in-time using RMAN?

Which TWO of the following are benefits of using an RMAN recovery catalog?

You are using RMAN to backup a database. What does the 'COMPRESS' clause in the backup command do?

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

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

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

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

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?

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?

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

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

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?

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?

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?

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?

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?

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?

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?

Your Oracle 23ai database is running in ARCHIVELOG mode. You have configured RMAN backups to a tape library using a media manager. You need to restore and recover a data file that was corrupted due to a hardware failure. The data file is currently offline. Which RMAN command should you use to restore and recover the data file?

You manage an Oracle 23ai database backed up nightly with RMAN to a fast recovery area. Management asks you to configure RMAN so that a backup of the database, archived logs, and control file runs every night automatically and redundant backups are removed. Which RMAN feature is designed to persist this backup policy across all sessions without manually typing the commands each night?

You are recovering an Oracle 23ai database after a disk failure. You restored the data files and control file from an RMAN backup, but the redo needed to complete recovery is partly on archived logs that were written to the fast recovery area. Which RMAN command most directly applies all available archived redo logs and incremental backups to bring the restored files to a consistent state?

Your Oracle 23ai database writes archived redo logs to a fast recovery area that is nearly full. You need to free space immediately without compromising recoverability, and you have already taken a full backup that includes the archived logs. Which action is most appropriate?

You are the DBA for an Oracle 23ai database. You have configured a recovery catalog and registered the database. You need to perform a point-in-time recovery of the database to a time before a user error occurred. You have a full backup from last night and all archived redo logs. Which RMAN command sequence should you use to perform the recovery?

Your Oracle 23ai database is in NOARCHIVELOG mode. A user reports that a critical table was accidentally modified, and you want to restore the database to a point before the change. What is the primary limitation you face?

You are using RMAN to back up your Oracle 23ai database. You want to ensure that RMAN automatically backs up the control file and server parameter file (SPFILE) whenever a backup is taken. Which RMAN configuration command should you use?

Your Oracle 23ai database is in ARCHIVELOG mode. A user accidentally dropped a table in the SALES schema. You want to recover the table using Flashback Drop. However, the recycle bin for the tablespace was purged. What is the most efficient way to recover the table using RMAN?