TypeOnline Course
REGISTER

Overview

Audience & Prerequisites

Course Outline

Schedule & Fees

Certification

Oracle Database 11g: Administration Workshop II

This Oracle Database 11g: Administration Workshop II Release 2 training takes the database administrator beyond the basic tasks covered in the first workshop. You’ll begin by gaining a deep understanding of the most important responsibilities a DBA has: performing backup and recovery.

Objectives

  • 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
  • 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

Intended Audience

  • Database Administrators
  • Support Engineer
  • Technical Consultant
  • Technical Administrator

Prerequisites

  • Oracle Database 11g Database Administration
  • Oracle Database 11g: Administration Workshop I

Course Outline                                                                                                                             Duration: 5 Days

Oracle Database 11g : Database Architecture and Recovery Operations

  • Oracle Database Architecture
  • Backup and Recovery Operations

Oracle Database 11g : The RMAN Catalog and Creating Backups

  • The RMAN Recovery Catalog
  • Creating Backups with RMAN

Oracle Database 11g : Performing Restore and Recovery Tasks

  • Restore and Recovery Tasks
  • Performing User-Managed Backup and Recovery

Oracle Database 11g : Using, Monitoring and Tuning RMAN

  • Using RMAN to Perform Recovery
  • Monitoring and Tuning RMAN

Oracle Database 11g : Database Diagnostics and Flashback Technologies

  • Diagnosing the Oracle Database
  • Flashback Technologies

Oracle Database 11g : Managing Database Memory and Performance

  • Managing Memory
  • Managing Database Performance

Oracle Database 11g : Managing Database Resources and the Scheduler

  • Managing Resources
  • Task Automation and Administration

Oracle Database 11g : Managing Database Space and Duplication

  • Oracle Database 11g Release 2: Managing Database Space and Duplication
  • Duplicate Databases

Please write to us at info@itstechschool.com & contact us at +91-9870480053 for the course price & certification cost, schedule & location

Drop Us a Query

For more info kindly contact us.