Backup And Recovery

You need to perform a table-level point-in-time recovery. Which RMAN command syntax is correct?

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 TWO RMAN settings significantly improve performance during backup operations on an Exadata system?

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

Which TWO actions are required to enable Flashback Database on a production environment?

Which THREE features are required for using Flashback Database?

What is the primary purpose of the Flashback Database feature?

Which TWO RMAN configurations are recommended to optimize backup performance in a high-transaction environment?

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

Which THREE conditions must be met to perform a successful RMAN cross-platform transportable tablespace migration?

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 THREE tasks are performed by the 'RECOVER' command during a data file restore?

You want to perform a point-in-time recovery to a specific timestamp. Which RMAN command is used to set the target time?

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 THREE of the following are prerequisites for performing an RMAN backup to an Oracle Cloud Infrastructure (OCI) Object Storage bucket?

You are using Block Change Tracking (BCT). Where is the BCT file stored?

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

You want to perform a backup that excludes tablespaces that are read-only. Which command should you use?

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

Which configuration parameter determines the maximum size of a backup piece?

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

Which TWO of the following are valid RMAN retention policies?

Which THREE steps are involved in an RMAN-based cross-platform migration of a data file using CONVERT?

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?

What command would you use to list all backups associated with a particular database in the recovery catalog?

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

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 are using RMAN to backup a database. What does the 'COMPRESS' clause in the backup command do?

Which THREE tasks are required when preparing for a database recovery using a new control file?

Which TWO conditions are required for Block Change Tracking (BCT) to be effective?

Which RMAN configuration must be set to ensure that backups are automatically deleted when they are no longer needed?

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

Which RMAN command allows you to verify that all database files are present and accessible without performing a full backup?

Which RMAN command is used to start an RMAN session?

Which THREE actions are performed during the 'RESTORE DATABASE' command?

You want to clear all configured RMAN settings back to their default values. Which command do you use?

What is the purpose of the 'REPORT OBSOLETE' command?

Which TWO commands allow you to check for block corruption in a database?

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 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 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 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 need to perform a full database restore and recovery. The control file is lost. What is the correct sequence of operations?

Which TWO of the following are valid methods to move a database across platforms using RMAN?

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

Which THREE components are included in an RMAN 'BACKUP DATABASE' command if not explicitly excluded?