11g Release 2 Tablespace Point In Time Recovery – recover from dropped tablespace

Posted by Gavin Soorma
On November 27, 2009
0 Comments

One of the good new features in 11g Release 2 is that it enables us to recover from a case of a dropped tablespace. TSPITR (tablespace point in time recovery) has been around in earlier releases, but we could not recover a dropped tablespace. What 11gR2 does is that it peforms a fully automated RMAN […]

Posted by Gavin Soorma
On November 20, 2009
0 Comments

We can use the RMAN RESTORE VALIDATE command to check and verify the integrity of the backups which are stored on tapes or disk as well. A point to keep in mind is that the RESTORE DATABASE VALIDATE command will only check for the datafile backups and will not check for either the archivelog of […]

Posted by Gavin Soorma
On November 6, 2009
1 Comments

Businesses are increasingly realizing the immense value that historical data can provide to help them understand market trends and customer behaviour as well. Further, many regulatory and compliance policies like SOX and BASEL-2 mandate retention of historical data. Until now, this unfortunately involved application rewrites,administration overheads or costly third-party software solutions. Total Recall or the […]

News

11g Release 2 Tablespace Point In Time Recovery – recover from dropped tablespace

RMAN Restore Validate Examples

11g Flashback Data Archive – Part One