Monthly Archives: April 2013

RMAN recovery through RESETLOGS


Prior to Oracle 10g, the redo log files generated after opening the database with RESETLOGS could not be used with the backups taken before the RESETLOGS was performed.   Therefore, whenever a resetlogs was done, it was important to take an immediate full database backup, since all previous backups became invalid.   Just to recap, […]

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 […]