Type
Virtual
Classroom ILT
Skill Level

Available dates
Learning Path
Virtual
Duration
1 Day

TYPE
Virtual
Classroom ILT
LEARNING PATH
SKILL LEVEL

DURATION
AVAILABLE DATES
Introduction:
This course takes the database administrator beyond the basic tasks covered in the first workshop. The student begins by gaining a much deeper understanding of possibly the most important job of a DBA – backup and recovery. The concepts and architecture that support backup and recovery, along with the steps of how to carry it out in various ways and situations, are covered in detail. This includes how to define and test your own backup and recovery scenarios. Also, the DBA learns how to manage memory effectively and how to perform some performance evaluation and tuning tasks, including using some of the advisors. All types of flashback technologies, scheduling jobs inside and outside of the database, and controlling system resource usage are also covered. Participants will learn to how to automate DBA tasks with the Scheduler, diagnose and repair data failures with Flashback technology, manage space to optimize database storage and to be able to respond to growing space requirements, monitor and manage major database components, and secure the availability of your database by appropriate backup and recovery strategies. This course counts towards the Hands-on course requirement for the Oracle Database 11g Administrator Certification. Only instructor-led in class or instructor-led online formats of this course will meet the Certification hands-on Requirement. Self Study CD-Rom and Knowledge Center courses DO NOT meet the Hands-on Requirement.
Audience profile:
Database Administrators, Support Staff, Technical Administrators and Technical Consultants
Pre-requisites:
Before attending this course, students must have:
- A thorough working knowledge of the SQL language
- Know how to use PL/SQL packages Oracle requires and recommends that delegates have attended the following course prior to attending this course.
- Required Course: D50102GC20 Oracle Database 11g: Administration Workshop I DBA
Course objectives
After completing this course, students will be able to:
- Back and recover a database (and its parts) with RMAN (command-line and Enterprise Manager)
- Use flashback technology to view past states of data and to revert either objects or the entire database back to a past state
- Use an appropriate and flexible memory configuration for your database
- Identify burdensome database sessions and poorly performing SQL
- Configure the Oracle Database for optimal recovery
- Configure the database instance such that resources are appropriately allocated among sessions and tasks
- Schedule jobs to run inside or outside of the database
- Use compression to optimize database storage and duplicate a database
Lesson 1: Core Concepts and Tools of the Oracle Database
This lesson reviews the Oracle Database architecture with ASM and provides an overview of the technical environment for this course. In this way, core concepts and DBA tools are introduced. Lessons: |
|
|
|
|
|
Lesson 2: Configuring for Recoverability
This lesson explains the configuring of an Oracle Database for recoverability through the use of RMAN, the FRA, retention policies, database archive modes, and the multiplexing of database archive logs. Lessons: |
|
|
|
|
|
|
|
|
|
|
|
Lesson 3: Using the RMAN Recovery Catalog
This lesson describes the use of a recovery catalog in the management of database backups. Delegates will learn how to create, configure and maintain a RMAN recovery catalog. Lessons: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Lesson 4: Configuring Backup Settings
This lesson demonstrates the use of Enterprise Manager to apply configuration changes to the backup settings such as autobackup of database critical files, backup destinations, backup optimization, compression and encryption. Lessons: |
|
|
|
|
|
|
|
|
|
|
Configuring autobackup for control file |
Lesson 5: Creating Backups with RMAN
This lesson demonstrates the use of RMAN in the creation of different types of database backups. It also teaches delegates how to maintain and report on backups. Lessons: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Lesson 6: Restore and Recovery Task
This lesson explores the steps involved in performing recovery after the loss of control files and redo log groups. Lessons: |
|
|
|
|
|
|
|
|
|
|
|
Lesson 7: Using RMAN to Perform Recovery
This lesson demonstrates the use of RMAN to perform complete recovery of critical and noncritical datafiles. Participants will also learn how to recover from different backup source types such as image copies and incremental backup sets. Lessons: |
|
|
|
|
|
|
|
|
|
Lesson 8: Monitoring and Tuning RMAN
This lesson explores ways of tuning RMAN for best backup and restore performance as well as monitoring the progress of RMAN jobs. Lessons: |
|
|
|
|
|
|
|
|
|
|
|
Lesson 9: Diagnosing the Database
This lesson explains how to detect and repair database corruption, set up diagnostic repositories and run health checks on an Oracle database. Lessons: |
|
|
|
|
|
|
|
|
|
Lesson 10: Using Flashback Technology I
This lesson describes how Oracle Flashback technology works. Participants will learn how to write and execute the different types of Flashback queries. Lessons: |
|
|
|
|
|
|
|
|
|
|
|
Lesson 11: Using Flashback Technology II
This lesson describes the implementation and usage of Oracle Total Recall as well as Flashback recycle bins. Lessons: |
|
|
|
|
|
|
|
|
|
|
|
|
|
Lesson 12: Performing Flashback Database
This lesson describes the Oracle Flashback Database feature and how to set up, monitor and perform Flashback Database operations. Lessons: |
|
|
|
|
|
|
|
|
|
Lesson 13: Managing Memory
This lesson explores the components found within the database instance and demonstrates ways of configuring manual or dynamic memory management of the instance SGA and PGA. Lessons: |
|
|
|
|
|
|
|
|
|
Lesson 14: Managing Database Performance
This lesson explains the tasks involved with the monitor and tuning of the database performance. Lessons: |
|
|
|
|
|
Lesson 15: Managing Performance by SQL Tuning
This lesson describes the use built in advisors to identify and tune specific SQL statements and workloads. Lessons: |
|
|
|
|
|
|
|
Lesson 16: Managing Resources
This lesson describes the management of database resources through the implementation of resource plans and consumer groups. It also describes how to configure and monitor the Database Resource Manager. Lessons: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Lesson 17: Automating Tasks with the Scheduler
This lesson describes how to simplify database management through the proper use of the Scheduler. Lessons: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Lesson 18: Managing Space
This lesson describes the use of different space management techniques such as automatic space management, the Segment Advisor and data compression. Lessons: |
|
|
|
|
|
|
|
|
|
|
|
|
|
Lesson 19: Managing Space for the Database
This lesson explains the concepts and usage of transportable databases and tablespaces. Lessons: |
|
|
|
|
|
|
|
Lesson 20: Duplicating a Database
This lesson explores the need for and methods through which a database can be duplicated. Lessons: |
|
|
|
|
|
|
|
|
Associated certifications and exam:
This course prepares students to write Exam 1Z0-053: Oracle Database 11g Administration Workshop II. On successful completion of this course students will receive an Oracle University attendance certificate.

Oracle Overview
Torque IT considers authorised Oracle training to be an integral part of any Oracle Solaris, Oracle Enterprise Linux, Oracle Applications, Java development, or Oracle Database implementation. Oracle authorized training, and associated certification, ensures that you get the most from your technology investment and that you are able to operate above the technology curve.
Our instructor led training provides customers with a hands-on experience to match job role requirements and prepares delegates for Oracle Certification exams. From in-class demonstrations to hands-on-labs, Torque IT’s authorised Oracle instructor led training provides our customers with a comprehensive and dynamic learning experience.
Oracle certifications are universally recognized as demonstrating a high level of expertise and credibility for individuals and the organizations that employ them. Authorised Oracle training and certification is the industry standard for any solution that includes designing, selling, implementing, upgrading, developing and managing Solaris, Java, and Oracle Database solutions.
Torque IT is recognised by Oracle as an Oracle University Training Centre which means that we offer our clients internationally recognised and globally accredited Oracle training and certification. These achievements reflect our commitment to providing our customers with quality skills development, enablement, training, and certification solutions that demonstrate exceptional depth, breadth, and expertise.
Torque is recognised by Oracle, and the industry, as having met rigorous standards for educational competency, service, customer satisfaction and investment in technology that will prepare the next generation of IT industry professionals to exploit Oracle Solutions.