Oracle 10g/11g Database Administration II Part 1

Course Description

 

This Oracle online training course explains advanced Oracle database topics. Oracle 10g/11g Database Administration II Part 1 provides an in-depth look into Oracle’s backup and recovery architecture as well as advanced DBA issues, and discusses facets of advanced database administration tasks. This Oracle online training is designed for the Oracle database administrator with some experience.

 

In order to take this course you need to have taken Oracle 10g/11g Database Administration I Part1 and Part 2, Oracle 10g/11g: Introduction to SQL, Oracle 10/11g: Advanced SQL, Oracle 11g PL/SQL Programming Part 1 and Part 2 or equivalent experience.

 

Once you have completed the Oracle 10g/11g Database Administration II Part 1 the next course in this series is Oracle 10g/11g Database Administration II Part 2. Part 2 provides an in-depth look into Oracle’s advanced memory architecture, database advisors, and job scheduler. Click here to learn more about Oracle 10g/11g Database Administration II Part 2.

 

In This Course You Will Learn How To:

  • Backup and Recover the Oracle Database
  • Create a Recovery Catalog
  • Use Oracle's Flashback features
  • Perform Oracle managed recoveries
  • Perform User managed recoveries
  • Identify and correct block corruption
  • Configure and ASM Instance

 

Prerequisites

 

You need to have equivalent experience or have taken the following courses:

  • Oracle 10g/11g: Introduction to SQL
  • Oracle 10g/11g: Advanced SQL
  • Oracle 11g PL/SQL Programming Part 1
  • Oracle 11g PL/SQL Programming Part 2
  • Oracle 10g/11g Database Administration I Part 1
  • Oracle 10g/11g Database Administration I Part 2

 

Outline

 

Module 00: Oracle 10g/11g Database Administration II Part 1 Online Training - Course Introduction

 

Module 01: Introduction to Oracle

  • Oracle products
  • Oracle Enterprise Solutions
  • PeopleSoft
  • Oracle Applications
  • JD Edwards
  • Siebel

 

Module 02: Oracle Database Management Products

  • Oracle Universal Installer
  • Oracle Enterprise Manager
  • Oracle Grid Solution
  • Oracle Database: Enterprise and Standard Editions

 

Module 03: Database Creation Assistant

  • Database Utilities
  • Database Configuration Assistant(DBCA)
  • Networking Assistant(NETCA)
  • Lab: Database Creation

 

Module 04: Oracle Architecture/ASM

  • Oracle Instance
  • SGA
  • Background processes
  • ASM instance architecture

 

Module 05: ASM Disks/DiskGroups

  • ASM disks
  • ASM diskgroups
  • External
  • Normal
  • High

 

Module 06: Managing ASM Part 1

  • Administer the ASM instance
  • Add disks
  • Rebalance disks
  • Disk re sync
  • •asmcmd

 

Module 07: Managing ASM Part 2

  • ASM and SQL Plus
  • ASM CMD
  • ASM and Enterprise Manager

 

Module 08: Database Recovery

  • Archivelog mode
  • NoArchivelog mode
  • Configure multiple archivelog destinations
  • Lab: Archivelog mode

 

Module 09: Flash Recovery Area

  • Configure flash recovery area
  • Configure flashback database
  • Lab: Archivelog and flashback mode

 

Module 10: Recovery Catalog

  • Definition of recovery catalog
  • Recovery catalog meta data
  • Create the recovery catalog

 

Modules 11: Recovery Catalog Scripts and Databases

  • Create recovery catalog scripts
  • Register target databases
  • Synchronizing the recovery catalog

 

Module 12: Administering the Recovery Catalog

  • Backup the recovery catalog
  • Configure recovery catalog settings
  • Create a virtual private catalog

 

Module 13: RMAN Backups

  • Backup sets
  • Image copies
  • Non-compressed backups
  • Compressed backups
  • Incremental backups
  • Lab: Database backup

 

Module 14: RMAN Recovery

  • Non-critical recovery
  • RMAN restore/recover command

 

Module 15: RMAN Critical Recovery

  • Recover a critical data file
  • Incremental recovery
  • Image copy recovery
  • Recovery to an alternate location

 

Module 16: RMAN Incomplete Recovery

  • Time based recovery
  • Duplicate database
  • Restoring a controlfile
  • Recovery in NoArchivelog mode

 

Module 17: User Managed Recovery

  • Complete database recovery
  • Incomplete database recovery
  • Backup the controlfile
  • Backup database in archivelog/noarchivelog

 

Module 18: Tuning RMAN

  • Multiple channels
  • Long running backups
  • Async I/O
  • SYNC I/O

 

Module 19: Additional RMAN Features

  • Cloning a database
  • Tablespace Point in Time Recovery(TSPITR)

 

Module 20: Recyclebin

  • Define the recyclebin
  • Retrieve objects from the recyclebin
  • Define protected objects in the recyclebin
  • Lab: Creating a table drop and recover the table

 

Module 21: Flashback Query

  • Undo_retention
  • Flashback query
  • Flashback versions query
  • Flashback transactions query

 

Module 22: Flashback Data Archives

  • Define flashback data archives
  • Manage flashback data archives
  • Flashback data archives administration

 

Module 23: Flashback Database

  • Configure flashback database
  • Monitor flashback database
  • Perform flashback database

 

Module 24: Oracle 10g/11g Database Administration II Part 1 Online Training - Course Summary