Oracle Database 11g: Administration Workshop II
- Course type:
- Essentials (What does this mean?)
| RRP | £2200 exc. VAT |
|---|---|
| Days | 5 |
| Code | OC11GDBA2 |
Secure online payment
- view dates / book course
- course description
- certification
- blogs
Course dates
Currently scheduled dates for this training course Location Sep Oct Nov Dec view later dates Manchester |- |25 |- |- 
Location Jan Feb Mar Apr view earlier dates Manchester |- |- |- |- Manchesterlocation information and directions
25 Oct 5 or more places available £2,200 exc VAT
Gaining a professional certification is a step that sets you apart – that benchmarks your knowledge in a recognised way – discount bundles available until end October 2010
Overview
Please note that Oracle courses running at London training centres are subject to a 10% surcharge.
In this course, 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 students learn to manage memory effectively and 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 covered. Topics are reinforced with hands-on practices.
Learn to
- Back up and recover a database using RMAN and Enterprise Manager
- Configure Oracle Database for optimal recovery for any environment
- Identify burdensome database sessions and poorly performing SQL
- Configure the database instance such that resources are allocated among sessions and tasks appropriately Schedule jobs to run inside or outside of the database
Audience
- Data Warehouse Administrator
- Database Administrators
- Support Engineer
- Technical Consultant
Prerequisites
Delegates will learn how to
- Back up and recover a database
- Configure Oracle Database for optimal recovery
- Administer ASM disk groups
- Use an RMAN backup to duplicate a database
- Automating Tasks with the Scheduler
Course outline
Database Architecture and ASM
- Oracle Database Architecture Overview
- ASM General Architecture
- Creating an ASM Instance
- Using Enterprise Manager to Manage ASM Users
- ASM Storage Concepts
- The ASMCMD Utility
- ASM Scalability and Performance
Configuring for Recoverability
- Purpose of Backup and Recovery Functionality
- Typical Backup and Recovery Tasks
- Oracle Backup and Recovery Solutions
- Using Recovery Manager (RMAN)
- Using a Flash Recovery Area
- Flash Recovery Area Space Management
Using the RMAN Recovery Catalog
- RMAN Repository Data Storage: Comparison of Options
- Storing Information in the Recovery Catalog
- Registering a Database in the Recovery Catalog
- Recovery Catalog Resynchronization: Concepts
- Using RMAN Stored Scripts
- Backing Up and Recovering the Recovery Catalog
- Using a Virtual Private Catalog
Configuring Backup Specifications
- Using RMAN to Create Backups
- Configuring Persistent Settings for RMAN
- Using Enterprise Manager to Configure RMAN Settings
- Control File Auto-backups
- Managing Persistent Settings
- Configuring Devices for Backup
- Configuring and Allocating Channels for Use in Backups
- Configuring Backup Optimization
Creating Backups
- Creating an Oracle-Suggested Backup
- Creating Backup Sets & Image Copies
- Creating a Whole Database Backup
- RMAN Backup Types
- Monitoring Block Change Tracking
- Creating Duplex Backup Sets
- Archival Backups: Concepts
- Encrypting Backups
Performing User-Managed Backup and Recovery
- Restoring and Recovering
- Causes of File Loss
- Critical Versus Non-critical
- Recovering from a TEMPFILE Loss
- Re-creating Indexes
- Recovering from a Lost Index Tablespace
- Authentication Methods for Database Administrators
- Recovering a Read-Only Tablespace
Using RMAN to Perform Recovery
- Using RMAN RESTORE and RECOVER Commands
- Performing Recovery Using Enterprise Manager
- Recovery Using Incrementally Updated Backups
- Perform a Fast Switch to Image Copies
- Restoring and Recovering the Database on a New Host
- Performing Disaster Recovery
Using RMAN to Duplicate a Database - Using RMAN to Create a Duplicate Database
- Creating a Duplicate Database
- Creating an Initialization Parameter File for the Auxiliary Instance
- Allocating Auxiliary Channels
- Understanding the RMAN Duplication Operation
- Using EM to Clone a Database
- Cloning a Running Database
Performing Tablespace Point-in-time Recovery
- Tablespace Point-in-Time Recovery (TSPITR) Concepts
- Tablespace Point-in-Time Recovery: Architecture
- Understanding When to Use TSPITR
- Determining the Tablespaces for the Recovery Set
- Using Enterprise Manager to Perform TSPITR
- Understanding TSPITR Processing
- Troubleshooting RMAN TSPITR
Monitoring and Tuning RMAN
- Parallelization of Backup Sets
- Monitoring RMAN Sessions
- Interpreting RMAN Message Output
- Using the DEBUG Option
- Tuning RMAN
- RMAN Multiplexing
- Comparing Synchronous and Asynchronous I/O
- Tape Subsystem Performance Rules
Using Flashback Technology
- Flashback Technology
- Transactions and Undo
- Guaranteeing Undo Retention
- Preparing Your Database for Flashback
- Flashback Drop and the Recycle Bin
- Using Flashback Technology to Query Data
- Possible Workflow
- Flashback Transaction Wizard
Using Flashback Database
- Flashback Table
- Enabling Row Movement on a Table
- Enabling Row Movement on a Table
- Flashback Database Architecture
- Configuring Flashback Database
- Performing Flashback Database Using EM
- Flashback Database Considerations
- Flashback Data Archive
Diagnosing the Database
- Automatic Diagnostic Workflow & Repository
- Location for Diagnostic Traces
- Viewing the Alert Log Using Enterprise Manager
- The Support Workbench and Oracle Configuration Manager
- Create a Service Request
- Package and upload diagnostic data to Oracle Support
- Incident Packaging Configuration
- Health Monitor Overview & Data Recovery Advisor
Managing Memory
- Oracle Memory Structures
- Automatic Memory Management Overview
- Oracle Database Memory Parameters
- Auto Memory Parameter Dependency
- Automatic Shared Memory Management: Overview
- Automatic PGA Memory Management
- Using the Memory Advisor to Size the SGA
- Memory Tuning Guidelines for the Library Cache
Managing Database Performance
- Tuning Activities
- Performance Planning & Performance Tuning Methodology
- Instance Tuning
- Troubleshooting and Tuning Views
- Automatic Workload Repository
- SQL Tuning & SQL Advisors
- Using the SQL Tuning Advisor
- SQL Access Advisor: Overview
Using the Segment Advisor
- Space Management: Overview
- Proactive Tablespace Monitoring
- Thresholds and Resolving Space Problems
- Monitoring Tablespace Space Usage
- Shrinking Segments
- Space Reclamation with ASSM
- Automatic Segment Advisor
- Minimum Compatibility Level
Managing Resources
- Database Resource Manager: Overview
- Database Resource Manager Concepts
- Accessing Resource Plans
- Default Maintenance Resource Manager Plan
- Creating Consumer Groups
- Resource Allocation Methods for Resource Plans
- Monitoring the Resource Manager
Automating Tasks with the Scheduler
- Simplifying Management Tasks
- Key Components and Steps
- Creating an Event-Based Schedule
- Creating Complex Schedules
- Creating Job Chains
Administering the Scheduler - Advanced Scheduler Concepts
- Job Classes
- Windows
- Prioritizing Jobs Within a Window
- Remote Jobs
- Installing the Scheduler Agent
- Dictionary Views Supporting Remote Jobs
Globalization
- Globalization Support Features
- What Every DBA Needs to Know
- Understanding Unicode
- Database Character Sets and National Character Sets
- Language- and Territory-Dependent Parameters
- Linguistic Searching and Sorting
- Case- and Accent-Insensitive Search and Sort
- NLS Data Conversion with Oracle Utilities
Related certification tracks
Related Certifications
This course forms part of the following certification track(s):
Need help planning your certification?
The easiest way to get help planning your certification training is to call one of our specialists on 0845 757 3888 or to e-mail us info@qa.com. We'll be happy to help.
Related blogs
Learning about learning
Posted by Stephanie Dedhar on 03 September 2010
A recent trip to the Science Museum proved that, with a little imagination, learning absolutely can be fun as well as effective.
Using the Novell ZCM 10.3 Agent to Display Closest Server Rules
Posted by Andrew Mallett on 02 September 2010
QA have been training and consulting with Novell ZCM 10 ( desktop management ) since the early days of the product back in 2007. So you know coming that by on training with us you are going to get the latest and most accurate advice and knowledge. A new feature of the 10.3 agent is that it allows support staff to display the evaluated closest server rules from the view point of the agent. This is great in trouble shoot as it is an easy mechanism to test the rules that you have created.
Creating Dynamic RAID Arrays with BTRFS
Posted by Andrew Mallett on 28 August 2010
You may have used Logical Volumes on Linux before with either LVM or EVMS and, of course, software raid. Now though we have a file-system that supports volumes that can dynamically increase and support RAID : BTRFS. With the complete implementation in the file-system the deployment and management is simplified and performance is increased. Although still EXPERIMENTAL it is worth looking at BTRFS as it has become to ship in many of the leading Linux Distributions.
Good e-learning: engaging, relevant and effective
Posted by Stephanie Dedhar on 17 August 2010
There are three headline characteristics that I keep in mind and try to achieve every time I design a piece of learning content.
Why would you use Linux?
Posted by Andrew Mallett on 14 August 2010
Over the last couple of years we have seen Linux being offered with some laptops and netbooks. Linux is free operating system, the bit that glues all of your software together, a little like Microsoft Windows but it is free, yes its’ cost is a big fat ZILCH. As we approach the UK Government’s public spending review this October, you can be sure that free, or “Open Source” software will be high on cost saving mechanism.