Oracle Database 12c - Backup and Recovery: Transporting Data and Performing PITR

Target Audience
Expected Duration
Lesson Objectives
Course Number
Expertise Level

Using Data Transport, a feature in Oracle Database 12c, tablespace can be transported to other databases on the same or different platforms. It also enables the transportation of full databases. Another feature of Oracle Database 12c is Point-in-Time Recovery. This enables the recovery of one or more objects, for example tablespaces, to an earlier time without affecting other objects within the database. Point-in-Time Recovery can be performed at three levels: Tablespace, Table, and Database. This course will discuss and demonstrate how to perform data transportation and Point-in-Time Recovery. This course is one of a series in the Skillsoft learning path that helps prepare the learner for the Backup and Recovery portion of the Oracle exam 1Z0-063, Oracle Database 12c: Advanced Administration.

Target Audience
Database administrators, support engineers, technical administrators, and data warehouse administrators who wish to develop appropriate strategies for backup, restore, and recovery procedures


Expected Duration (hours)

Lesson Objectives

Oracle Database 12c - Backup and Recovery: Transporting Data and Performing PITR

  • start the course
  • describe how data can be transported
  • determine the endian format of a platform and the use of the RMAN convert command
  • describe the steps to transport data with backup sets and data files
  • describe the procedure used to transport a database
  • perform database transportation
  • perform database transportation using backup sets
  • perform tablespace transportation
  • transport data, databases, and tablespaces in a given scenario
  • identify when Tablespace Point-in-Time Recovery can be used
  • identify the Tablespace Point-in-Time Recovery architecture
  • prepare for Point-in-Time Recovery
  • perform fully automated Tablespace Point-in-Time Recovery
  • perform TSPITR using an RMAN-Managed Auxiliary instance and your own auxiliary instance
  • troubleshoot RMAN Tablespace Point-in-Time Recovery
  • describe table recovery
  • identify the steps to perform table recovery
  • recover a table from a backup using RMAN
  • perform TSPITR and table recovery in a given scenario
  • Course Number:

    Expertise Level