Oracle Database 10g DBA Part II — A 5-Day Course

Synopsis

This course introduces the delegate to advanced administration tools. Participants will learn how to plan and implement a backup and recovery strategy using operating system backups, the import and export utilities and Recovery Manager. They will also learn how to control database resources using the Resource Manager. How to automate administration tasks with the Scheduler and how to carry out performance monitoring and tuning. This course covers the main examination topics of the Oracle exam #1Z1-043 Oracle Database 10g: Administration II. Exams are not included as part of the course.

Course Objectives

The delegate will practise:

Planning a backup strategy and a disaster recovery strategy
Altering a database to ARCHIVELOG and NOARCHIVELOG modes
Performing online and offline backups
Performing complete and incomplete database recovery
Recovering a database from non-critical losses
Performing logical backups with the export and import utilities
Using Recovery Manager to perform backups and restorations
Using Flashback technology to recover a database
Reviewing database logs for diagnostic purposes
Using Database advisors and views to monitor and improve database performance
Controlling database resources using Resource Manager
Automating management tasks with the scheduler

Suitable for

Database administrators and technical support staff who are required to plan and implement database backup and recovery strategies for Oracle10g databases. This course is also suitable for delegates who need to be able to monitor and improve the database performance.

Prerequisites

Delegates should have a working knowledge of Oracle SQL*Plus and Oracle Database Administration. This can be obtained by attendance on the Oracle SQL and Oracle Database 10g DBA Part I courses
Knowledge of PL/SQL would be beneficial

Publicly scheduled dates, locations, and prices

London — £1595 (+VAT)

19–23 Apr 2010
24–28 May 2010
5–9 Jul 2010
23–27 Aug 2010
4–8 Oct 2010
15–19 Nov 2010
20–24 Dec 2010

Manchester — £1595 (+VAT)

22–26 Mar 2010
24–28 May 2010
19–23 Jul 2010
27 Sep–1 Oct 2010
6–10 Dec 2010

Bristol — £1595 (+VAT)

19–23 Apr 2010
28 Jun–2 Jul 2010
13–17 Sep 2010
22–26 Nov 2010

Birmingham — £1595 (+VAT)

17–21 May 2010
28 Jun–2 Jul 2010
27 Sep–1 Oct 2010
6–10 Dec 2010

Leeds — £1595 (+VAT)

26–30 Apr 2010
5–9 Jul 2010
13–17 Sep 2010
22–26 Nov 2010

Edinburgh — £1595 (+VAT)

17–21 May 2010
26–30 Jul 2010
18–22 Oct 2010

Outline Course Contents

Backup and Recovery Considerations

Oracle Suggested Backup Strategy
Plan and Implement a Backup and Recovery Strategy
Define a Backup Strategy
Define a Disaster Recovery Plan
The Advantages and Disadvantages of Different Backup Methods
Test a Backup and Recovery Plan

Oracle Recovery Structures and Processes

Architectural Components of Backup and Restore
Redo Logs, Checkpoints and Archives
Multiplexing Control Files and Redo Logs
Types of Database Failure

Using ARCHIVELOG and NOARCHIVELOG Modes

Configuring a database in Archivelog mode
Configuring a database in Noarchivelog mode
Configuring multiple redo log archive processes
Configuring multiple archival destinations

Physical Backup without RMAN

Closed and Open Backups
Using operating system commands for database backup
Performing Offline Backups
Performing Online Backups
Backup in Logging and Nologging Modes
Control File Backups
Data Dictionary Views for Backup Operations

Complete Database Recovery without RMAN

Recovery in NOARCHIVELOG Mode
Recovery in ARCHIVELOG Mode

Incomplete Recovery with Archiving

When to use Incomplete Recovery
Performing an incomplete Recovery
Recover from Losing Current and Inactive Noarchived Redo Log Files

Additional Recovery Issues

Minimizing downtime
Rapid crash recovery
Checkpointing and cache recovery
Parallel recovery
Trial recovery
Recover a database with missing data files
Rebuilding lost or damaged control files
Recovering read-only tablespaces

Globalization

Overview of globalization
Language encoding schemes
NLS character sets
NLS language and territory definitions
NLS data dictionary views
Multi language linguistic sorts
Date times with timezones
Display formats
Date functions
Case and accent insensitive sorts

Troubleshooting Utilities

Using Log and Trace Files to Diagnose Problems
Detecting Block Corruption
The ANALYZE Command
te DBMS_REPAIR Package
Use DBVERIFY to Validate the Database File Structure
Block Media Recovery

Recovery Manager Overview

RMAN Features and Components
Connecting to RMAN without a Recovery Catalog
Start Up and Shut Down a Target Database Using RMAN

Creating and Maintaining a Recovery Catalog

Creating a Recovery Catalog
Use a Flashback Recovery Area
Register a Database
Connecting to RMAN
Control File Information
RESYNC CATALOG command
Configure Persistent RMAN Settings
Retention Policies
Control File Autobackups

Backing up with RMAN

Types of RMAN Backup
Backup Commands
Backup sets parallelization
Compressed backups
Performing backups
Full closed and open backups
Incremental and cumulative backups
The copy command
Block change tracking
Troubleshooting

Maintaining a Recovery Catalog

Reset Command
Change the Availability Status of Backups and Copies
Catalog Backups Made with Operating System Commands
Cross Check Backups and Copies
Use data dictionary tables
Update the repository after backup deletion

Restoring and Recovering with RMAN

Perform recovery in noarchivelog mode
Perform complete recovery in archivelog mode
Incomplete recovery using UNTIL TIME and UNTIL SEQUENCE
Restore and recover a tablespace
Restore and recover datafiles
Recover a datafile not backed up
Apply incremental backups to restore datafile image copies
The SWITCH command

Flashback

Configure and use flashback database
Monitor flashback database
Flash recovery area space usage
Flashback query
Retrieve row history with flashback versions query
Audit or recover from transactions with Flashback transactions query
Flashback table
Recover dropped tables with flashback drop
The recycle bin
Recover tables to a point in time with flashback table
Flashback database

Managing Resourcse with Resource Manager

Overview of the Database Resource Manager
Create resource plans and consumer groups
Create resource plan directives
Control resource by user groups
Specify an instance plan
Fixed CPU Quotas
Integrate Resource Manager and Profiles
Automatic session assignment
Monitor the Resource Manager

Automatic Storage Management

Overview of ASM
ASM initialization parameter files
Administer ASM disk groups
Execute SQL commands with ASM file names
ASM instance startup and shutdown
Migrate a database to ASM

Automating Tasks with the Scheduler

Introduction to the Scheduler
Scheduler Architecture
Managing jobs and programs
Prioritize jobs
View job execution details
Run external jobs

Automatic Database Management

Monitoring the Oracle database
Monitoring and managing storage
Monitoring and managing memory
Automatic PGA Memory Management
Automatic Shared Memory Management
Self monitoring architecture
Automatic Workload repository
Metrics, thresholds and alerts
Automatic Database Diagnostics Monitor (ADDM)
Monitoring and Tuning usage model
Setting up Notification rules
Using the Advisors

Memory Management, Alert and Waits

Memory Management
Automatic memory management
Memory advisors
System generated alerts
Threshold and event based alerts
Wait Interface

SQL Performance Tuning

Automated statistics collection
Application statistics collection
SQL Tuning advisor
SQL Access advisor
Segment advisor
10g Hints

Securing the Oracle Listener

Listener Password Authentication
Controlling Database Access
Securing the EXTPROC Service Entry