Oracle 11g Database Administrators Fundamentals I

Managing the Oracle Instance

• Initialization Parameters
• Memory Management
• Automatic Shared Memory Management (ASMM)
• Database Startup and Shutdown
• Viewing the Alert History
• Using Trace Files
• Data Dictionary: Overview

• Managing Tables / Data Storage.
• Setting Storage Parameters
• Managing Tablespaces / Data Files
• Automatic Storage Management (ASM)
• SYSTEM and SYSAUX Tablespaces.
• Creating Additional Tablespaces
• Adding Data Files to a Tablespace
• Tablespace Online / Offline
• Locally Managed Tablespaces
• Multiple Block sizes
• Bigfile Tablespaces
• Temporary Tablespaces
• Database Default Tablespaces
• Renaming Tablespaces
• Renaming and Relocating Data Files
• Dropping Tablespaces and Data Files

• Managing Rollback Segments
• Setting up Automatic Undo Management
• Monitoring Undo Segments
• Undo Tablespace & Sizing
• Undo Advisor

• 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

• Key Concepts
• Connecting as SYSDBA/SYSOPER
• Password Management
• Schemas and Synonyms
• Dropping Users
• Profile Management
• Creating / Altering/ Dropping Roles
• Enabling and Disabling Roles
• Granting / Revoking System Privileges and Roles.
• Granting / Revoking Object Privileges

• Introduction to Utilities
• EXP: Runtime EXPORT Command
• EXP Parameters and Operation Notes
• Restrictions on Export
• IMP: Runtime IMPORT Command
• IMP Parameters & Operation Notes
• Using Data Pump Features
• Transportable Tablespaces

• Conventional path
• Types of file
• The control file

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

• Database Control
• Server Generated Alerts
• Reacting to Alerts
• Advisor Central

• Introduction to Database Tuning
• Gathering Tuning Statistics
• Tuning Memory
• Balancing Disk I/O
• Resource Contention
• Automatic Workload Repository (AWR)
• Automatic Database Diagnostic Monitor (ADDM)