Guenadi N Jilevski's Oracle BLOG

Oracle RAC, DG, EBS, DR and HA DBA BLOG

Transportable database and transportable tablespace(s) from backup, Tablespace point in time recovery TSPITR

Transportable database and transportable tablespace(s) from backup, Tablespace point in time recovery TSPITR

Transportable tablespace feature introduced since Oracle 10g allowed a tablespace placed in a read only mode to be transported to another database and plugged in. However system and sysaux tablespaces were not transportable. Transportable database feature allows a database to be transported from one platform to another if the following conditions are met.

  • Both databases are within the list of platforms in v$trasportable_platform
  • Both platforms are with the same byte ordering. This further restricts the list of platforms.

Using the transportable database feature Oracle creates copies of the datafiles and recreates the control file, redo log files and creates the temporary tablespace file.

Transportable tablespace from backup avoids placing a tablespace in read only mode prior to the transportation and uses a backup for this purpose. TSPIRT enable us to recover a tablespace to a point in time in the past. TPSPITR is similar to the transportable tablespace from backup. In both cases an auxiliary instance is created. Using the previous target database backup an auxiliary database instance is created and restored to an auxiliary location and recovered to a point in time in the past. The auxiliary database is opened with reset logs. The tablespace set is exported with transportable tablespace mode and the files are copied to the location in case of transportable tablespace from a backup. In case of a TSPITR the tablespaces from the Auxiliary instance are plugged into the target database. In both cases the auxiliary instance is destroyed automatically upon successful completion.

The article will look at

  • Transportable database.
  • Transportable Tablespace from backup
  • Tablespace point in time Recovery (TSPITR)
    Continue reading

February 12, 2011 Posted by | oracle | 1 Comment