Daily Archives: April 21, 2013

POINT IN TIME RECOVERY via RMAN


Scenario:   DBA dropped the tablespace TEST which is important for application.   Requirement:   We need to restore the database before the TEST tablespace was dropped.     Solution:     SQL> drop tablespace test including contents and datafiles; Tablespace dropped.   DBA realized the mistake;   He will refer alert log for the […]