OCP CBT Question 524

Please solve the following question.

You are a DBA for a critical production database. The database suffered a complete data file loss for the `SALES_DATA` tablespace due to a storage failure. The `SALES_DATA` tablespace contains large, active tables. You have identified that the last successful RMAN full database backup was taken 24 hours ago, and all archived redo logs are available since then. You also have an incremental backup strategy, but the latest incremental backup was corrupted. Which is the most efficient RMAN strategy to recover the `SALES_DATA` tablespace, ensuring minimal downtime for other tablespaces?

sql-- Scenario:-- - Database is in ARCHIVELOG mode.-- - Control file and online redo logs are intact.-- - Data files for SALES_DATA tablespace are physically deleted/corrupted.-- - Last full backup: 24 hours ago.-- - All archived redo logs since full backup are available.-- - Latest incremental backup: Corrupted and unusable.

Shut down the entire database, restore the full database backup, and then perform complete recovery.

Take the SALES_DATA tablespace offline, restore the data files for SALES_DATA from the last full backup, and then perform point-in-time recovery for only that tablespace.

Take the SALES_DATA tablespace offline, restore the data files for SALES_DATA from the last full backup, and then perform complete recovery applying all available archived redo logs.

Perform a DBPITR (Database Point-In-Time Recovery) to a time just before the failure.