• Online, Self-Paced
Course Description

Oracle Database 12c allows for the duplication of a database. This can be useful for numerous reasons, including for implementing a testing environment or for doing recovery operations. To duplicate a database there are various steps you need to complete to first prepare the environment when the database will be duplicated to and then the RMAN DUPLICATE command can be used. As with any tool or feature that using resources RMAN can have performance issues. These issues need to be identified and then corrected based on performance issues that was detected. Oracle Database 12c provides tools and features to do this task. This course will discuss and show how to duplicate a database as well as how to troubleshoot and tune RMAN. 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

Duplicating Databases

  • start the course
  • identify the difference techniques that can be used to duplicate a database
  • identify the difference between the push and pull methods for duplicating a database
  • identify the techniques for duplicating a database from backup
  • identify how to create a parameter file for the auxiliary instance
  • identify how to use the SET NEWNAME clause
  • identify how to start the auxiliary database and allocate auxiliary channels
  • identify the steps performed by RMAN when the duplicate command is executed
  • identify the different options that can be used with the duplicate command
  • perform the steps to duplicate a database

Practice: Performing Database Duplication

  • duplicate a database

Troubleshooting and Tuning RMAN

  • interpret RMAN messages and error stacks
  • understand how RMAN commands are processed
  • identify if there is a problem with RMAN performance
  • diagnose performance bottleneck read operations
  • diagnose performance bottleneck write operations
  • use dynamic views to determine if there is a performance issue
  • diagnose asynchronous and synchronous I/O bottlenecks
  • identify the steps to tune backup performance
  • configure parallelization of backup sets
  • set the large_pool_size parameter
  • configure RMAN multiplexing
  • identify the best practices for restore and recovery performance

Practice: Troubleshooting and Tuning RMAN

  • troubleshoot and tune RMAN

Framework Connections

The materials within this course focus on the NICE Framework Task, Knowledge, and Skill statements identified within the indicated NICE Framework component(s):

Specialty Areas

  • Data Administration