Oracle DBA Course Syllabus

Introduction

• Describe course objectives
• Explore the Oracle 10g database architecture

Installing the Oracle Database Software

• Explain core DBA tasks and tools
• Plan an Oracle installation
• Use optimal flexible architecture
• Install software with the Oracle Universal Installer

Creating an Oracle Database

• Create a database with the Database Configuration Assistant (DBCA)
• Create a database design template with the DBCA
• Generate database creation scripts with the DBCA

Managing the Oracle Instance

• Start and stop the Oracle database and components
• Use Enterprise Manager (EM)
• Access a database with SQL*Plus and iSQL*Plus
• Modify database initialization parameters
• Understand the stages of database startup
• View the Alert log
• Use the Data Dictionary

Managing Undo Data

• Explain DML and undo data generation
• Monitor and administer undo
• Describe the difference between undo and redo data

Configure undo retention

• Guarantee undo retention
• Use the undo advisor

Implementing Oracle Database Security

• Describe DBA responsibilities for security
• Apply the principal of least privilege
• Enable standard database auditing
• Specify audit options
• Review audit information
• Maintain the audit trail

Performing Database Backups

• Create consistent database backups
• Back your database up without shutting it down
• Create incremental backups
• Automate database backups
• Monitor the flash recovery area

Performing Database Recovery

• Recover from loss of a control file
• Recover from loss of a redo log file
• Perform complete recovery following the loss of a data file