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


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