Backup And 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?

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

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

Which RMAN command displays the database structure and associated datafiles?

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?

Which THREE are characteristics of Flashback Logs?

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?

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

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

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?

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

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

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 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?

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

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 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?

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

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?

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 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 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 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?

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

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

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?

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 TSPITR (Tablespace Point-in-Time Recovery). What is the purpose of the auxiliary instance?

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?

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

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

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

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?

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

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?

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?

Which THREE operations are automatically performed by RMAN when executing the 'RECOVER TABLE' 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?

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?

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

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?

What is the primary purpose of the Flashback Database feature?

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?

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

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

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

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