Oracle Database 11g DBA - Part I — A 5-Day Course

Synopsis

This course is designed to give the Oracle database administrator practical experience in setting up, administering and troubleshooting an Oracle 11g database. Database administrators will gain an understanding of the architecture and processes of the Oracle database server. They will be able to ensure the integrity and availability of a company's data within the Oracle environment. They will be able to monitor the performance of the database and perform basic backup and recovery of the database.

Objectives

The delegate will practise:

Installing and Configuring Oracle
Creating and Managing an Oracle Database
Administering an Oracle Database
Configuring the Oracle Network Environment
Configuring Shared Servers
Creating and Managing Database Storage Structures
Managing Redo Log Files and Control Files
Managing Schema Objects
Managing Users, Profiles, Privileges and Roles
Managing Undo Data and Temporary Segments
Monitoring and Resolving Lock Conflicts
Maintaining Database Security
Monitoring the Performance of the Database
Loading and Unloading Data
Backing Up and Recovering the Database

Suitable For

This course is intended for:

Anyone who needs to administer, monitor and support an Oracle 11g database.

Prerequisites

Delegates should have an understanding of relational database concepts and basic operating system knowledge.
They should have attended the "Oracle SQL" course or have a good working knowledge of Oracle SQL*Plus.
Knowledge of PL/SQL would be beneficial

Examinations

This course covers the main topics of the Oracle exam #1Z0-052 Oracle Database 11g: Administration I.

Exams are not included as part of the course.

Before taking any exam, ensure you have the recommended experience. The Oracle website lists all exam requirements and these are updated regularly.

Publicly scheduled dates, locations, and prices

London — £1595 (+VAT)

15–19 Mar 2010
10–14 May 2010
21–25 Jun 2010
26–30 Jul 2010
20–24 Sep 2010
1–5 Nov 2010
20–24 Dec 2010

Outline Course Contents

Introduction to Oracle Database 11g

Relational database concepts
Database administration tasks
DBA responsibilities

Oracle Database 11g Architecture

Oracle architecture
The Oracle instance
Memory structures
Background processes
Server and client processes
The Oracle database

Installation and Configuration of an Oracle Database

System Hardware Requirements
Optimal Flexible Architecture
Authentication methods for a database
Oracle environment variables
Install Oracle software using the Oracle Universal Installer (OUI)
Use the database Configuration Assistant (DBCA)
Create a database with DBCA
Manage a database with DBCA
Delete a database with DBCA
Manage Templates using DBCA
Upgrade a database using Database Upgrade Assistant (DBUA)

Administer a Database

Administrative Tools Available to a DBA
Using SQL*Plus in Oracle to manage a database
Administer the database using Enterprise Manager (EM)
Start and stop the agent
Start and stop the EM Database Console
Access EM
EM navigation
Grant EM administrative privileges to a user

Manage an Oracle Instance

Access an Oracle database
Database authentication methods
Password file
The Startup Process
The Shutdown Process
Initialization parameters
SHUTDOWN a database and instance using SQL
STARTUP a database and instance using SQL
View alert log and trace files
View or modify initialization parameters with EM
Shutdown a database using EM
Startup a database using EM

Tablespace and Datafile Management

Overview of tablespaces and datafiles
Use EM to view the storage structure of the database
Create and alter tablespace commands
Locally managed tablespaces
Dictionary managed tablespaces
Bigfile tablespaces
Temporary tablespaces
Multiple temporary tablespaces
Create tablespaces
Manage tablespaces
Use standard and non-standard block sizes
Create and manage tablespaces using OMF
Drop tablespace command
Overview of Automatic Storage Management (ASM)

Manage Redo Logs

Redo log overview
Plan redo logs
Redo log data dictionary tables
Log switches and checkpoints
Log file maintenance
Add and drop log file members and groups
Clear a log file
Move or rename an online redo log file
Multiplex redo log files
Use EM to manage redo logs
Manage online redo log files with OMF
List redo log information

Manage Control Files

The usage of the control file
The contents of a control file
Manage control files
Replace a lost or damaged control file
Mirror a control file
Standby control file
Manage control files with OMF
List control file information

Manage Schema Objects

Create a new table
View the attributes and contents of a table
Understand data integrity
Define constraints
Alter tables
Create indexes
View index attributes
Create views
Create and use sequences

Manage Users

Database administration accounts
User accounts
Create a user account
Operating system authentication
Change a user's password
Manage a user account
Drop a user account
Monitor user information
Terminate user sessions
Product user profiles

Manage Profiles and Resources

Overview of user profiles
Profile resource parameters
Create profile command
Manage passwords with profiles
Control resource usage with profiles
Maintain profiles
Drop profiles

Managing Privileges

Database access
Oracle supplied roles
System level privileges
Object level privileges
The grant and revoke commands
Create roles
Modify and drop roles
Control the availability of roles
Use predefined roles
Synonyms
Listing valid grants

Database Auditing

Overview of database auditing
Auditing SYS statements
Auditing end user sessions
Statement auditing
Privilege auditing
Auditing modifications made to database objects
Audit table relocation
Fine grained auditing
Auditing from Enterprise Manager

Undo Management

Undo data overview
Monitor and administer undo
Configure undo retention
Switch undo tablespaces
Specify the retention period
Guarantee undo retention
Retention period for flashback queries
View undo space information
Use the undo advisor
Size the undo tablespace
Manage undo with EM

Moving Data

Create directory objects
Data Pump Export and Import
- Data Pump architecture
- Data Pump data dictionary views
- Data Pump interactive mode
- Data Pump API
- Use Data Pump to export data
- Use Data Pump to import data
SQL Loader
- Overview of SQL Loader
- Command line parameters
- Record filtering
- Control file keywords
- Datafiles
- SQL Loader data paths

Oracle Shared Server

Shared server architecture
When shared servers should be used
Configure dispatchers
Configure shared servers
Monitor dispatchers and shared servers

Data Concurrency and Lock Conflicts

Levels of locking in Oracle
Methods used to acquire locks
Possible causes of contention
Deadlocks
Prevent locking problems
Detect lock contention
Resolve conflicts in an emergency

Proactive Database Maintenance

Self Monitoring Architecture
Automatic Workload Repository
Automatic Database Diagnostic Monitoring
Monitor an Oracle database
Use the Advisors
Set up notification rules

Performance Management

Tuning information sources
Identify unusable objects
Statistics collection
Automated statistics collection
Performance metrics
Use the advisors
React to performance issues

Backup and Recovery Considerations

Oracle Suggested Backup Strategy
Database backup, restore and recover
Types of failure
Tune instance recovery
Checkpoints, redo log files and archive log files
Alter the ARCHIVELOG mode of a database
Configure a database for recoverability

Database Backups

Types of RMAN backup
Backup sets and image copies
Perform backups using EM
Automate database backups
Configure backup settings
Catalog settings
Monitor the flash recovery area
Manage backups

Database Recovery

Restore and recovery operations
Recover an entire database from backup
Recover from the loss of a system critical data file
Recover from the loss of a control file
Recover from the loss of a redo log file

Enhancing Database Capabilities

Enterprise Manager Support Workbench
Register for security updates