Oracle 11g DBA Fundamentals

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 Database Storage

• 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 Undo Data

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

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
• 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

EXPORT, IMPORT & DATAPUMP*

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

SQL Loader*

• Conventional path
• Types of file
• The control file

Backup and Recovery Procedures

• 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

Optimisation*

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

Network Architecture

• Basic configuration
• Oracle Net Manager
• Listener administration
• Using and configuring Oracle Names
• Networking Wizard

Shared Server*

• Using shared server
• Configuration
• Restrictions

Database Architecture* and ASM

• Oracle Database Architecture Overview.
• ASM General Architecture
• Creating an ASM Instance
• ASM Storage Concepts
• The ASMCMD Utility

Configuring for Recoverability*

• Backup and Recovery Functionality
• Typical Backup and Recovery Tasks.
• Oracle Backup and Recovery Solutions.
• Causes of File Loss

User-Managed Backup & Recovery

• Restoring and Recovering
• Critical Versus Non-critical
• Recovering from a TEMPFILE Loss
• Recovering a Read-Only Tablespace

Configuring RMAN

• Using RMAN to Create Backups
• Configuring Persistent RMAN Settings.
• Control File Auto-backups
• Configuring and Allocating Channels for Use in Backups
• Configuring Backup Optimization

Creating Backups

• Creating an Oracle-Suggested Backup.
• Creating Backup Sets & Image Copies.
• Creating a Whole Database Backup
• RMAN Backup Types.
• Monitoring Block Change Tracking
• Archival Backups: Concepts

Using RMAN Recovery Catalog*

• RMAN Repository Data Storage: Comparison of Options
• Storing Information in the Recovery Catalog.
• Registering a Database in the Recovery Catalog
• Resynchronization: Concepts
• Using RMAN Stored Scripts
• Backing Up and Recovering the Recovery Catalog

Using RMAN to Perform Recovery*

• Using RMAN RESTORE and RECOVER Commands
• Performing Recovery Using Enterprise Manager
• Recovery Using Incrementally Updated Backups
• Perform a Fast Switch to Image Copies
• Restoring and Recovering the Database on a New Host
• Performing Disaster Recovery

Using RMAN to Duplicate a Data*

• Creating a Duplicate Database
• Creating an Initialization Parameter File for the Auxiliary Instance.
• Allocating Auxiliary Channels
• Understand RMAN Duplication
• Using EM to Clone a Database
• Cloning a Running Database

Point-in-time Recovery*

• Tablespace Point-in-Time Recovery (TSPITR) Concepts.
• TSPITR Architecture.
• When to Use TSPITR.
• Determining the Tablespaces for the Recovery Set.
• Using Enterprise Manager to Perform TSPITR.
• Understanding TSPITR Processing.
• Troubleshooting RMAN TSPITR

Monitoring and Tuning RMAN*

• Monitoring RMAN Sessions
• Interpreting RMAN Message Output
• Using the DEBUG Option
• Tuning RMAN
• RMAN Multiplexing
• Comparing Synchronous and Asynchronous I/O
• Tape Subsystem Performance Rules

Using Flashback Technology*

• Transactions and Undo
• Guaranteeing Undo Retention
• Preparing Your Database for Flashback
• Flashback Drop and the Recycle Bin
• Using Flashback Technology to Query Data
• Flashback Transaction Wizard

Using Flashback Database*

• Flashback Table
• Enabling Row Movement on a Table
• Flashback Database Architecture
• Configuring Flashback Database
• Performing Flashback Database Using EM
• Flashback Database Considerations
• Flashback Data Archive

Diagnosing the Database*

• Automatic Diagnostic Workflow & Repository.
• Location for Diagnostic Traces
• Viewing the Alert Log Using Enterprise Manager
• The Support Workbench and Oracle Configuration Manager
• Create a Service Request
• Package and upload diagnostic data to Oracle Support
• Incident Packaging Configuration
• Health Monitor Overview & Data Recovery Advisor

Managing Memory*

• Oracle Memory Structures
• Automatic Memory Management (AMM) Overview
• Oracle Database Memory Parameters
• Auto Memory Parameter Dependency
• Automatic Shared Memory Management (ASMM) Overview
• Automatic PGA Memory Management
• Using the Memory Advisor to Size the SGA
• Memory Tuning Guidelines for the Library Cache

Managing Database Performance

• Tuning Activities
• Performance Planning & Tuning Methodology
• Instance Tuning
• Troubleshoot and Tune Views
• Automatic Workload Repository
• SQL Tuning & SQL Advisors
• Using the SQL Tuning Advisor
• SQL Access Advisor: Overview

Using the Segment Advisor*

• Space Management: Overview
• Proactive Tablespace Monitoring
• Thresholds and Resolving Space Problems
• Monitoring Tablespace Space Usage
• Shrinking Segments
• Space Reclamation with ASSM
• Automatic Segment Advisor
• Minimum Compatibility Level

Scheduler*

• Simplifying Management Tasks
• Key Components and Steps
• Programs
• Schedules
• Jobs and Job classes
• Windows