I have this scenario that DBA dropped the tablespace TEST which in important for application. We can recover with RMAN back up. But last backup done at 12:30 and tablespace is dropped at 13:30. Lot of transaction happen in between.
How to recover those transactions to that tablespace? How about flashback?
Can we use flashback to recover the droped tablespace?
Kindly share your views here, thanks in advance.