OCP CBT Question 573

Please solve the following question.

You have a large production database and need to recover a single tablespace, `HR_DATA`, to a point in time 24 hours ago due to a logical corruption that only affected data within this tablespace. All other tablespaces must remain at the current point in time. The database is in ARCHIVELOG mode, and you have RMAN backups. Which RMAN command is most appropriate for this scenario?

sql-- Database name: PRODDB-- Tablespace: HR_DATA-- Desired recovery point: 24 hours ago.-- Other tablespaces must be unaffected.-- Flashback Database is NOT suitable for this specific scenario (e.g., due to required recovery time differences).

sqlRMAN> RECOVER TABLESPACE HR_DATA UNTIL TIME 'SYSDATE - 1/24' AUXILIARY DESTINATION '/u02/aux_recovery';

sqlRMAN> SHUTDOWN IMMEDIATE;RMAN> STARTUP MOUNT;RMAN> RESTORE TABLESPACE HR_DATA UNTIL TIME 'SYSDATE - 1/24';RMAN> RECOVER TABLESPACE HR_DATA UNTIL TIME 'SYSDATE - 1/24';RMAN> ALTER DATABASE OPEN RESETLOGS;

sqlRMAN> RECOVER DATAFILE (SELECT NAME FROM V$DATAFILE WHERE TS# = (SELECT TS# FROM V$TABLESPACE WHERE NAME = 'HR_DATA')) UNTIL TIME 'SYSDATE - 1/24';

sqlRMAN> RESTORE DATABASE UNTIL TIME 'SYSDATE - 1/24';RMAN> RECOVER DATABASE UNTIL TIME 'SYSDATE - 1/24';RMAN> ALTER DATABASE OPEN RESETLOGS;