Category Archives: Backup and recovery

Backing up tables/tablespaces/databases encrypted with TDE in Oracle 11g

Posted on January 5, 2012 by oracletempspace

In a previous post, I was messing about with TDE (Transparent Data Encryption) in Oracle 11g, and with both the column-level and also tablespace-level variants. While pretty simple to understand and start exploring (make no mistake, there’s much to cover if you … Continue reading →

Posted in Backup and recovery, Database administration, Database security, Oracle 11g Release 2, Oracle errors, Recovery Manager (RMAN), Transparent Data Encryption, Uncategorized | Tagged , , , , , | Leave a comment

Oracle 11g RMAN: Restore SPFILE using AUTOBACKUP with non-default location and non-default name

Posted on June 10, 2011 by oracletempspace

One of the common scenarios for recovering from database failures is the loss of the spfile and/or controlfile, usually following failures on the database storage media (for example a SAN storage failure). Therefore it is very useful to have an … Continue reading →

Posted in Backup and recovery, Oracle 11g Release 2, Recovery Manager (RMAN), Recovery Manager (RMAN) | Tagged , , , | 1 Comment