Oracle Database 11g Administration Workshop II Release 2

Duration: 
5 days
Codes: 
II,11G
Versions: 
2

Overview

This course brings database administrators beyond a basic understanding of their duties and to transfer advanced skills needed to effectively administer an Oracle database installation within a large-scale enterprise. Important subject areas include advanced database configuration, performance monitoring and tuning, configuring for recovery, troubleshooting and fault diagnosis, and use of the extensive advisory framework. Sometimes configuration and operational problems can exist within an Oracle database installation because important technologies are either not fully understood or not properly implemented. Advanced technologies which should be applied to any mission-critical database installation. The Database Resource Manager is an essential tool for database tuning and achieving optimum performance, and is often used in combination with the advisors. The Database Scheduler is a sophisticated tool which can automate many administration tasks and integrate the database into the larger data center and systems infrastructure. All of the data within a database installation is at risk unless one has designed, tested and implemented a robust backup and recovery strategy. When a major failure occurs, a variety of recovery and troubleshooting techniques must be employed. The Oracle Recovery Manager (RMAN) tool is discussed with additional facilities including the Data Recovery Advisor, Redo Log File Size Advisor and MTTR Advisor. It is tempting to short-cut appropriate backup procedures if they perform poorly, so special attention is giving to performance optimization.

Audience

The primary target audiences for this course are:

  • Database administrators
  • Web server administrators
  • System administrators
  • Implementation specialists
  • Data center support engineers
  • Senior application designers and developers

Skills Gained

After completing the course, the delegates will be in a position to do the following:

  • Backup and Recover A Database Using RMAN (Command Line Interface and Enterprise Manager)
  • Use Flashback to View Past States of Data and Revert the Database Or Objects To That State
  • Monitor and manage major database components, including memory, performance and resources
  • Use An Adaptable Memory Configuration For The Database
  • Isolate Sessions With Heavy Traffic and Poorly Performing SQL Statements
  • Configure The Oracle Database For Optimal Recovery
  • Set Up The Database Instance To Allocate Resources Appropriately Among Sessions and Tasks
  • Manage space to optimise database storage so you can respond to growing space requirements
  • Diagnose and repair data failures with Flashback technology
  • Secure the availability of your database through proper backup and recovery strategies
  • Automate DBA Tasks with the Scheduler

Prerequisites

The candidates need to be familiar with Oracle SQL or equivalent and PL/SQL packages. Also, the candidate should hold a certification in Oracle Database 11g Administration Workshop I Release 2.

Course Outline

Database Architecture and ASM

  • Describe Automatic Storage Management (ASM)
  • Set up initialization parameter files for ASM and database instances
  • Start up and shut down ASM instances
  • Administer ASM disk groups

Configuring for Recoverability

  • Set multiple archive log file destinations to increase availability
  • Define, apply and use a retention policy
  • Set Up Flash Recovery Area
  • Use Flash Recovery Area

Using the RMAN Recovery Catalog

  • Identify situations that require RMAN recovery catalogue
  • Create and configure a recovery catalogue
  • Synchronise the recovery catalogue
  • Create and Use RMAN stored scripts
  • Back up the recovery catalogue
  • Create and use a virtual private catalogue

Configuring Backup Specifications

  • Configure backup settings
  • Allocate channels to use in backing up
  • Configure backup optimisation

Using RMAN to Create Backups

  • Create image file backups
  • Create a whole database backup
  • Enable fast incremental backup
  • Create duplex backup and back up backup sets
  • Create an archival backup for long-term retention
  • Create a multisection, compressed and encrypted backup
  • Report on and maintain backups

Performing User-Managed Backup and Recovery

  • Recover from a lost TEMP file
  • Recover from a lost redo log group
  • Recover from the loss of password file
  • Perform user-managed complete database recovery
  • Perform user-managed incomplete database recovery
  • Perform user-managed and server managed backups
  • Identify the need for backup mode
  • Back up and recover a control file

Using RMAN to Perform Recovery

  • Perform complete recovery from a critical or noncritical data file loss using RMAN
  • Perform incomplete recovery using RMAN
  • Recover using incrementally updated backups
  • Switch to image copies for fast recovery
  • Restore a database onto a new host
  • Recover using a backup control file
  • Perform Disaster recovery

Using RMAN to Duplicate a Database

  • Creating a duplicate database
  • Using a duplicate database

Performing Tablespace Point-in-Time Recovery

  • Identify the situations that require TSPITR
  • Perform automated TSPITR

Monitoring and Tuning RMAN

  • Monitoring RMAN sessions and jobs
  • Tuning RMAN
  • Configure RMAN for Asynchronous I/O

Using Flashback Technology

  • Restore dropped tables from the recycle bin
  • Perform Flashback Query
  • Use Flashback Transaction

Additional Flashback Operations

  • Perform Flashback Table operations
  • Configure, Monitor Flashback Database and Perform Flashback Database operations
  • Set up and use a Flashback Data Archive

Diagnosing the Database

  • Set up Automatic Diagnostic Repository
  • Using Support Workbench
  • Perform Block Media Recovery

Managing Memory

  • Implement Automatic Memory Management
  • Manually configure SGA parameters
  • Configure automatic PGA memory management

Managing Database Performance

  • Use the SQL Tuning Advisor
  • Use the SQL Access Advisor to tune a workload
  • Understand Database Replay

Space Management

  • Manage resumable space allocation
  • Describe the concepts of transportable tablespaces and databases
  • Reclaim wasted space from tables and indexes by using the segment shrink functionality

Managing Resources

  • Understand the database resource manager
  • Create and use Database Resource Manager Components

Automating Tasks with the Scheduler

  • Create a job, program, and schedule
  • Use a time-based or event-based schedule for executing Scheduler jobs
  • Create lightweight jobs
  • Use job chains to perform a series of related tasks

Administering the Scheduler

  • Create Windows and Job Classes
  • Use advanced Scheduler concepts to prioritise jobs

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.

ITILv3, RESILIA, PRINCE2, PRINCE2 Agile, AgileSHIFT, MSP, M_o_R, P3M3, P3O, MoP, MoV courses on this page are offered by QA, ATO of AXELOS Limited. ITIL, RESILIA, PRINCE2, PRINCE2 Agile, AgileSHIFT, MSP, M_o_R, P3M3, P3O,MoP, MoV are registered trademarks of AXELOS Limited. All rights reserved.

Upcoming Dates

  • GREEN This class is Guaranteed To Run.
  • SPVC - Self-Paced Virtual Class.
  • Click a Date to Enroll.
Course Location Days Cost Date
Virtual Virtual5 7499 £7499 2019-10-14
London London5 7499 £7499 2019-10-21
London London5 7499 £7499 2019-10-21
Nottinghamshire Nottingham5 7499 £7499 2019-11-11
Cumbria Carlisle5 7499 £7499 2019-11-11
West Sussex Chichester5 7499 £7499 2019-11-11
Yorkshire Leeds5 7499 £7499 2019-11-11
Glamorgan Swansea5 7499 £7499 2019-11-11
Berkshire Reading5 7499 £7499 2019-11-11
Midlands Birmingham5 7499 £7499 2019-11-11
Leicestershire Hinckley5 7499 £7499 2019-11-11
Clwyd Wrexham5 7499 £7499 2019-11-11
Glamorgan Cardiff5 7499 £7499 2019-11-11
Suffolk Ipswich5 7499 £7499 2019-11-11
Cheshire Crewe5 7499 £7499 2019-11-11
Edinburgh Edinburgh5 7499 £7499 2019-11-11
Bristol Bristol5 7499 £7499 2019-11-11
Yorkshire Wakefield5 7499 £7499 2019-11-11
London London5 7499 £7499 2019-11-11
Warwickshire Warwick5 7499 £7499 2019-11-11
Leicestershire Leicester5 7499 £7499 2019-11-11
Berkshire Bracknell5 7499 £7499 2019-11-11
Glasgow Glasgow5 7499 £7499 2019-11-11
Northern Ireland Belfast5 7499 £7499 2019-11-11
Sussex Brighton5 7499 £7499 2019-11-11
Kent Maidstone5 7499 £7499 2019-11-11
Hertfordshire Watford5 7499 £7499 2019-11-11
Buckingshire High Wycombe5 7499 £7499 2019-11-11
Northamptonshire Corby5 7499 £7499 2019-11-11
Kent Canterbury5 7499 £7499 2019-11-11
Tyne and Wear Newcastle5 7499 £7499 2019-11-11
Inverness Inverness5 7499 £7499 2019-11-11
Manchester Bolton5 7499 £7499 2019-11-11
Dublin Dublin5 7499 £7499 2019-11-11
Buckinghamshire Milton Keynes5 7499 £7499 2019-11-11
Dorset Bournemouth5 7499 £7499 2019-11-11
Gloucestershire Cirencester5 7499 £7499 2019-11-11
Virtual Virtual5 7499 £7499 2019-11-11
Aberdeenshire Aberdeen5 7499 £7499 2019-11-11
Surrey Guildford5 7499 £7499 2019-11-11
Oxfordshire Oxford5 7499 £7499 2019-11-11
London Bromley5 7499 £7499 2019-11-11
Berkshire Swindon5 7499 £7499 2019-11-11
Staffordshire Stoke on Trent5 7499 £7499 2019-11-11
Dorset Poole5 7499 £7499 2019-11-11
Norfolk Norwich5 7499 £7499 2019-11-11
Devon Plymouth5 7499 £7499 2019-11-11
Merseyside Liverpool5 7499 £7499 2019-11-11
Essex Chelmsford5 7499 £7499 2019-11-11
Manchester Manchester5 7499 £7499 2019-11-11
Hampshire Southampton5 7499 £7499 2019-11-11
Derbyshire Buxton5 7499 £7499 2019-11-11
Cambridgeshire Cambridge5 7499 £7499 2019-11-11
Derbyshire Burton upon Trent5 7499 £7499 2019-11-11
Somerset Bath5 7499 £7499 2019-11-11
Midlands Northampton5 7499 £7499 2019-11-11
Yorkshire Sheffield5 7499 £7499 2019-11-11
Cheshire Chester5 7499 £7499 2019-11-11
Lancashire Chorley5 7499 £7499 2019-11-11
Midlands Wolverhampton5 7499 £7499 2019-11-11
Middlesbrough Teesside5 7499 £7499 2019-11-11
Devon Exeter5 7499 £7499 2019-11-11
London London5 7499 £7499 2019-12-09
Virtual Virtual5 7499 £7499 2019-12-09
London London5 7499 £7499 2020-01-06
London London5 7499 £7499 2020-01-06
London London5 7499 £7499 2020-03-02
Manchester Manchester5 7499 £7499 2020-03-02