Microsoft training courses, Cisco training courses, Prince2 training courses, ISEB training courses with locations nationwide
Call now to speak to an experienced Training Advisor
 
     
 
Home
  
How it works
  
About the quality of your course
 
Managed services
  
Partner CourseMonster
  
 
 
Thousands of Microsoft, ISEB, ITIL, Cisco and Prince2 Training Courses and more
  
 
Browse Oracle Training Courses

Database 10g: Backup and Recovery

Course Code: OD10-BR      Days: 3
Show all Oracle Courses
Scheduled Dates
Locations filtered. Show all UK course locations.
Request availability or book by selecting a date:
Scotland
Edinburgh
Edinburgh (EH2) 24/11/08 £ 1,020
Prices exclude VAT.
Have questions or need a better city/date? Ask now.
On-site/international quote? Ask now.

Course Overview

This course is designed to give the Oracle 10g database administrator a firm foundation in backup and recovery tasks. The primary goal of the course is to give the DBA the skills and knowledge to set-up, maintain and troubleshoot an Oracle 10g backup and recovery scheme

The enhancements and changes that have been introduced in 9i will be discussed during this course for the benefit of students to understand the full capability of the Oracle 10g RDBMS as well as for students who may be migrating plans from previous Oracle RDBMS versions.

Audience

  • Oracle Database Administrators
  • Oracle Systems Administrators
  • Oracle Support Engineers

Course Outline

Backup and Recovery Overview

  • Understanding the structures and processes for backup and recovery.
  • Introduce the different methods for backup and recovery
  • Diagnose and troubleshoot database problems.
  • Understand Oracle Recovery Manager

Backup and Recovery

  • Recovery structures and processes
  • Backup and recovery configuration
  • Types of failure and troubleshooting
  • Complete recovery
  • Incomplete media recovery
  • Export and import utilities
  • Test Recovery
  • ALTER DATABASE END BACKUP

Oracle Recovery Manager

  • RMAN command line prompt
  • Recovery Manager Architecture
  • Setting up Recovery Manager
  • Database space requirements and privileges
  • Creating and running backup and recovery scripts from RMAN
  • Using LIST and REPORT options from Recovery Manager
  • Crash Recovery workshop,
  • Tips and tricks when using Recovery Manager.
  • Persistent Parameters
  • Block Level recovery

Enterprise Manager Utilities

  • Catalog Maintenance Using Enterprise Manager
  • Creating an EM Backup Configuration
  • LogMiner
  • Recovery Manager
  • Configurable Parameters

Standby Databases & Data Guard

  • Data Guard Features
  • Creating the Standby Database
  • Maintaining the Standby Database
  • Altering the Physical Structure
  • Failover without Data Guard
  • Failover Using Data Guard
  • Role Transitions Using Data Guard
  • Data Guard Protection Modes
  • Logical Standby Databases
  • Creating a Logical Standby Database
  • Logical Standby Failover and Switchover
  • Data Guard Manager Line Mode
  • Data Guard Manager Using EM

Flashback

  • Flashback Features
  • Enabling Flashback
  • Flashback Query
  • Additional Query Functions
  • Flashback Version Query
  • Flashback Transaction Query
  • Flashback Table
  • Flashback Drop (Recycle Bin)
  • Flashback Database


How to make a booking for the OD10-BR course
 
  CourseMonster books thousands of public training courses, classes and boot camps both in London and throughout the UK including: Berkshire, Birmingham, Bristol, Bournemouth, Bucks, Cambridge, Derby, Devon, Edinburgh, Glasgow, Hampshire, Ipswich, Leeds, Leicester, Luton, Manchester, Middlesex, Milton Keynes, Norfolk, Nottingham, Reading, Surrey, Sussex, Tyne and Wear, Midlands and Yorkshire. Topics range from software to administration and development.  
     
CourseMonster® Patent Pending © SeaKom, All Rights Reserved - Channel partners with Business Training Partnership