วัตถุประสงค์
 
         This practical foundation course is an essential toolkit for all Database Administrators covering the practical skills needed by the DBA to perform the Oracle 10g database administration function within their enterprise.

รายละเอียดหลักสูตร 

Basic Concepts
• The DBA Role
• Basic ORACLE Architecture
• Logical /Physical Structures
• Some Administration Terminology
• Basic Steps to a new ORACLE Database
• Database Administrator Tools
• Parameter Files (Text & Binary)

Starting and stopping the Database
• Steps to Start the Database
• Altering Database Availability
• Steps to Shutdown the Database

Managing Database Storage
• Managing Tables / Data Storage.
• Setting Storage Parameters
• Managing Tablespaces and Data Files
• Creating Additional Tablespaces
• Adding Data Files to a Tablespace
• Tablespace Online / Offline
• Locally Managed Tablespaces
• Multiple Block sizes
• Database Default Temporary Tablespaces
• Renaming and Relocating Data Files
• Dropping Tablespaces and Data Files

Managing Rollback Segments
• Managing Rollback Segments
• Assignments to Rollback Segments
• De-allocation of Rollback Segment Extents
• Types of Rollback Segments
• Acquiring of Rollback Segments
• Rollback Segment States
• Creating Rollback Segments
• Changing Storage Parameters
• Bringing Rollbacks Segments Online
• Taking Rollback Segments Offline
• Dropping a Rollback Segment

Automatic Undo Management
• Setting up Automatic Undo Management
• Monitoring Undo Segments
• Undo Tablespace & Sizing
• General Implications

Redo Logs and Control Files
• Managing Redo Logs
• Types of Redo Log
• Archiving Modes
• Log Switches and Checkpoints
• Creating Online Redo Log Groups
• Creating Log Group Members
• Renaming / Relocating Redo Log Members
• Dropping Redo Log Groups / Members
• Archiving Redo Logs
• Specifying Archived Log Destinations
• Manual Archiving of Redo Logs
• Control Files
• Creating/Dropping Control Files

Database Security
• Key Concepts
• Users
• Internal User
• Connecting as SYSDBA/SYSOPER
• Password Management
• Password Dictionary Structures
• Security Schemas
• Privileges / Roles / Profiles
• Security Guidelines
• Dropping Users
• Profile Management
• Creating / Altering/ Dropping Roles
• Enabling and Disabling Roles
• Grant / Revoke System Privileges and Roles
• Grant / Revoke Object Privileges

Backup and Recovery Procedures
• Basic Concepts
• Backup Guidelines
• Performing Full / Partial Back-ups
• Control File Backups in ARCHIVELOG mode
• Online Backup
• Recovery Mechanisms
• Oracle Online Recovery
• Restoring a Full Backup
• Closed Database Recovery
• Open Database - Offline Tablespaces Recovery
• Incomplete Media Recovery
• Applying Redo Logs
• Types of failure
• Appropriate Recovery Procedures
• Restoring Damaged Data Files
• Restoring Archived Redo Log Files

UTILITIES: EXPORT and IMPORT
• Introduction to Utilities
• EXP: The Runtime EXPORT Command
• EXP Operation Notes
• Restrictions on Export
• IMP: The Runtime IMPORT Command
• Privileges Required for IMPORT
• IMP Parameters & Operation Notes

SQL Loader
• Conventional path
• Types of file
• The control file

Enterprise Manager
• Overview
• OEM Standalone
• Management Server

Creating the Database
• Steps to create an ORACLE Database
• Examples of Creating Database
• After Database Creation

หลักสูตรแนะนำ

• Oracle Database Administrators : 2