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?
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?
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?
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?
You are performing a cross-platform data migration. The source is Linux and the destination is Windows. Which RMAN tool do you use to convert the datafiles?
You need to perform a Table Point-in-Time Recovery (TPITR) to restore a table to a state before a mistaken DROP TABLE operation. Which RMAN command performs this operation while minimizing impact to other tablespaces?
A database is configured with a Flash Recovery Area (FRA). You want to ensure that RMAN automatically deletes obsolete backups to reclaim space in the FRA. Which command should you configure?
You have a standby database and want to use RMAN to offload backups to the standby. Which configuration is required to ensure the primary database recognizes the backups performed on the standby?
Which RMAN command should you use to verify that all blocks in your database datafiles are free from physical corruption without actually performing a restore?
You are the DBA for a production Oracle 23ai database running in ARCHIVELOG mode. A developer accidentally ran a DELETE without a WHERE clause against the SALES table at 10:15 AM, and the commit was issued immediately. The table is 50 GB and resides in a locally managed tablespace with automatic segment space management. You need to recover the table to its state just before the delete with minimal impact on the rest of the database. Which action should you take?
Your Oracle 23ai database uses a Fast Recovery Area (FRA) with a size of 200 GB. You configured RMAN to create backups with the command BACKUP DATABASE PLUS ARCHIVELOG. After several days, you notice that the FRA is nearly full and RMAN backups are failing with ORA-19809. You need to ensure that RMAN automatically deletes obsolete backups and archived logs to free space, while retaining the recovery window of 7 days. Which action should you take?
A production Oracle 23ai database uses a fast recovery area (FRA) with 200 GB capacity. During a full RMAN backup, the FRA becomes full and the backup fails with ORA-19809. You need to ensure that future backups do not fail due to FRA space pressure, while retaining the ability to restore to any point in the last 14 days. Which action best meets these requirements?
Your database is running in ARCHIVELOG mode with a fast recovery area. A data file in the USERS tablespace is corrupted. You have a full backup from last night and all archived logs since then. You want to restore and recover only that data file while the database remains open. Which RMAN command sequence should you use?
Your Oracle 23ai database is in NOARCHIVELOG mode. You perform a full RMAN backup every night. During the day, a user accidentally drops a table. You need to recover the table to its state just before the drop. Which statement is true about your recovery options?
You are managing a production Oracle 23ai database. You need to configure RMAN to automatically create a backup of the control file and server parameter file (SPFILE) whenever a backup of data file 1 is performed. Which two RMAN configuration commands achieve this? (Choose two.)
You are planning a backup strategy for an Oracle 23ai database. You want to use RMAN incremental backups to reduce backup time and space. Which two statements are true regarding incremental backups? (Choose two.)
Your Oracle 23ai database uses a fast recovery area with ARCHIVELOG mode enabled. You want to validate that your most recent full database backup can actually be used for a restore without overwriting any current database files or applying redo. Which two RMAN operations accomplish a non-destructive validation of the backup? (Choose two.)
You are the DBA for an Oracle 23ai database in ARCHIVELOG mode with a fast recovery area configured. A user accidentally truncates a critical table in the HR schema. You have a full RMAN backup from last night. You want to recover the table to its state just before the truncate, without affecting other objects in the tablespace. Which RMAN command should you use?
Your Oracle 23ai production database uses a fast recovery area and RMAN backups to disk. A junior DBA accidentally deleted several archived redo log files that have not yet been backed up. You need to recover the database to the point just before the deletion. Which two actions must you perform? (Choose two.)
You are the DBA of an Oracle 23ai database in ARCHIVELOG mode. A media failure destroyed the disk containing the SYSTEM tablespace data file. You have a full RMAN backup and all archived redo logs. The database instance is still running but the SYSTEM tablespace is offline. You need to restore and recover the SYSTEM tablespace while the database remains open. Which RMAN command sequence accomplishes this?
Your Oracle 23ai database is in ARCHIVELOG mode. A user accidentally dropped a table in the HR schema two hours ago, and the undo retention window has already passed. You have a full backup from last night and all archived redo logs since then. You want to recover just that table without affecting any other objects in the database. Which RMAN feature should you use?
Your Oracle 23ai database uses a fast recovery area (FRA) with a size of 100 GB. You configured RMAN to create image copies of data files in the FRA. Over time, the FRA becomes full, and RMAN backups start failing with ORA-19809: limit exceeded for recovery files. You need to resolve this issue without losing any backups required for recovery. Which action should you take?
Your Oracle 23ai database runs in NOARCHIVELOG mode. A user drops a critical table by mistake at 10:00, and you have a consistent RMAN backup taken at 02:00 that same day. You need to recover the dropped table with minimal impact on the rest of the database. Which approach is valid?
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?
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?
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 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?