OCP CBT Question 644

Please solve the following question.

A user accidentally dropped a critical table in the `FINANCE` tablespace at 10:00 AM. You need to recover only this tablespace to 09:50 AM, minimizing impact on other tablespaces, which are perfectly fine and actively used. The database is in ARCHIVELOG mode. Which RMAN feature should you use, and what is its primary requirement?

The FINANCE tablespace is comprised of finance01.dbf. The database is currently open. The drop operation occurred at SCN 1234567 (equivalent to 10:00 AM). You need to recover to SCN 1234500 (equivalent to 09:50 AM).

Tablespace Point-in-Time Recovery (TSPITR); it requires an auxiliary instance.

Complete Database Recovery; it requires a full database restore.

Block Media Recovery (BMR); it requires the database to be in NOARCHIVELOG mode.

Data file Recovery; it allows recovery of the data file while the database is open.