Course details

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