Oracle RMAN Transport Tablespace Backup Limitations
Oracle RMAN backup of transportable tablespace has a number of limitations for Oracle 10g. Oracle Transportable Tablespace allow for the efficient movement of large volumes of data between Oracle databases. On the whole this works well and once setup is far more efficient data than processing through database links.
What probably is not widely known is that Oracle RMAN in Oracle Database 10gR2 seems to have some difficulty with backup of a plugged in read only tablespace (the default state for a tablespace that is plugged in using transport tablespace).
There are two issues with using Oracle RMAN for backup on 10g when you have plugged in read only tablespace’s that have not been set to read write:
- RMAN will not backup the datafile’s for the plugged in tablespace.
- RMAN will not report the datafile’s as part of the ‘report need backup’ or ‘restore database preview check read only’ commands either.