Skip Headers
Oracle® Database Backup and Recovery Advanced User's Guide
10g Release 2 (10.2)

Part Number B14191-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

About Creating Transportable Tablespace Sets from Backup with RMAN

The method of creating transportable tablespace sets described in Oracle Database Administrator's Guide requires that the tablespaces to be transported are opened read-only for the duration of the tablespace transport process.

By contrast, when RMAN creates transportable tablespace sets from backup, it does not need access to the live datafiles from the tablespaces to be transported. This eliminates the need to put the tablespace in read-only mode. As a result, database availability is improved, especially for large tablespaces, because the tablespaces to be transported can remain open for writes during the process, and because putting a tablespace into read-only mode can take a long time, depending upon current database activity.

Using RMAN for creating a transportable tablespace set also enables you to specify a target point in time, SCN or restore point during your recovery window and transport the data as it stood at that time rather than as it stands at the time of the TRANSPORT TABLESPACE. If, for example, your backup retention policy guarantees a one week recovery window, and you want to create transportable tablespaces for reporting based upon the contents of your database on the last day of the month, you can use RMAN to do so at any time during the first week of the next month.

The RMAN TRANSPORT TABLESPACE command is used to create transportable tablespace sets from RMAN backups.


Note:

Even if RMAN is not used for backups of the database, the RMAN TRANSPORT TABLESPACE command can still be used to create transportable tablespace sets. However, you must have datafile copies from before the desired SCN for the transportable tablespace set, and you must prepare for TRANSPORT TABLESPACE by using the RMAN CATALOG command to record the datafile copies and archived log files needed for the operation in the RMAN repository. Once RMAN has a record of all needed backups and logs, it can perform TRANSPORT TABLESPACE. See Oracle Database Backup and Recovery Basics for details on using CATALOG.


See also:

Oracle Database Backup and Recovery Reference. for reference information on the TRANSPORT TABLESPACE command