Oracle Database 12c - Backup and Recovery: Duplicating Databases and Tuning RMAN


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level


Overview/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.

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

Prerequisites
None

Expected Duration (hours)
1.7

Lesson Objectives

Oracle Database 12c - Backup and Recovery: Duplicating Databases and Tuning RMAN

  • 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
  • duplicate a database
  • 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
  • troubleshoot and tune RMAN

    • Course Number:
    od_bkpr_a07_it_enus

    Expertise Level
    Intermediate