Training Course: 10g DBA Fundamentals II (O1020)

Training Course Summary:

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.

Pre-Requisites:

Oracle 10g SQL (O011)
10g DBA Fundamentals I (O1010)

Who Should Attend:

Oracle Database Administrators
Oracle Systems Administrators
Oracle Support Engineers

Training Course Overview/Content:

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
back to top
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
back to top
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,
Recovery Manager: Tips and tricks
Persistent Parameters
Block Level recovery
back to top
Enterprise Manager Utilities
Catalog Maintenance Using Enterprise Manager
Creating an EM Backup Configuration
LogMiner
Recovery Manager
Configurable Parameters
back to top
Standby Databases and Guards
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
back to top
Flashback
Flashback Features
Enabling Flashback
Flashback Query
Additional Query Functions
Flashback Version Query
Flashback Transaction Query
Flashback Table
Flashback Drop (Recycle Bin)
Flashback Database
back to top
Network Architecture
Basic configuration
Oracle Net Manager
Listener administration
Using and configuring Oracle Names
Networking Wizard
back to top
Oracle Intelligent Agent
Installation
Configuration
Mixed SQL*Net and 9i Networking
Troubleshooting
back to top
Connection Manager
Concentrators
Multiplexing
Connection pooling
back to top
Shared Server
Using shared server
Configuration
Restrictions
back to top
Shared Memory Management
Manual Memory Allocation
Setting up ASMM
Non-dynamic SGA Buffers
back to top
Scheduler
Programs
Schedules
Jobs
Job Classes
Windows
back to top
Automated Storage Management
Features
ASM instances and database instances
ASM Disk groups
ASM Files