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.
Learning Objectives
Transporting Data
- 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
Practice: Performing Data Transport
- transport data, databases, and tablespaces in a given scenario
Tablespace Point-in-Time Recovery
- 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
Table Recovery
- describe table recovery
- identify the steps to perform table recovery
- recover a table from a backup using RMAN
Practice: Performing TSPITR and Table Recovery
- perform TSPITR and table recovery in a given scenario