Oracle Database 11g – Administration I
Through hands-on experience administering an Oracle 11g database, you will gain an understanding of the Oracle Server architecture, and you will learn how to expand the size of the database, implement security, and know why and how specific database administration tasks are performed.
The primary audiences for this course are:
- Database administrators
- Web server administrators
- System administrators
- Implementation specialists
- Data center support engineers
- Senior application designers and developers
- Knowledge of SQL, the Introduction to Oracle 11g SQL and SQL Plus course, or equivalent experience.
- Introduction to Oracle 11g PL/SQL or equivalent experience is highly recommended.
- Oracle 11g Foundations: SQL & SQL Plus
Major tasks to be considered within this course are:
- Configuration of the Linux and MS Windows operating systems in anticipation of a database installation.
- Server Class installation of the Oracle 11g R2 Enterprise Edition database.
- Verification of a valid database installation.
- Database administrator interface options, including the use of Enterprise Manager, command-line SQL*Plus, and terminal console SSH.
- Database deinstallation.
- Online software patching.
- Startup and shutdown of database services and related software components.
- Super administrator authentication options.
- An in-depth exploration of the database architecture, including memory, process and data structures, and the management of those structures.
- Management of database files.
- Specialized facilities intended to maximize performance of enterprise-scale transactional applications, such as the shared SQL and PL/SQL cache, the Result Cache, the database buffer cache, and other similar components.
- Management of security policies and procedures, including administration of user accounts, roles, privileges and profiles.
- Utilization of advanced self-tuning and self-management capabilities, including the use of Oracle-Managed Files, database Advisors and other components of the Management Framework.
- Performance monitoring, problem troubleshooting, and resolving lock and conflict issues.
- Using the Oracle Enterprise Manager and SQL interfaces for administration tasks.
- Control over database support services, including the Database Control, Oracle Net and others.
- A primer on backup and recovery structures and strategies.
- Operating system-specific considerations for various platforms, especially Linux and MS Windows Server.
Module 1: Introduction and Duties of the DBA
• Oracle RDBMS Components
• DBA Responsibilities
Module 2: Tables, Constraints, and Indexes
• Introduction to Datatypes and Tables
• Integrity Constraints
• Temporary Tables, Partitioned Tables (range, hash, list), External Tables, IOTs
• Indexes and Skip Scanning
• Online Reorganization
• Database Workspace Management
Lab: Database Startup and Shutdown
Module 3: Other Database Schema Objects
• DDL Commands Used
• Views, Materialized Views
• Sequences, Synonyms, Database Links
• Outlines, Dimensions, Hierarchies
• PL/SQL Program Units
• Supplied Packages
• Oracle Data Dictionary
• Storage of Large Objects (BFILEs, BLOBs, CLOBs)
Lab: Using and Managing SPFILES and Parameters
Module 4: Starting and Stopping the Database
• What Tool to Use?
• Connecting as a Privileged User
• Password file authentication
• Starting a Database
• Shutting Down a Database
• Reading the Alert Log/Trace Files
• Quiescing the Database
• SPFILE / Parameter Management
Lab: Creating Tables, Indexes, and Constraints
Module 5: How Space is Physically Consumed – Blocks and Extents
• Basic Definitions
• Blocks and Extents
Lab: Creating Other Database Schema Objects
Module 6: How Space is Logically Consumed – Segments
• Introduction to Segments
• Managing Undo Segments
• Automatic Undo Management
• Managing Sort Activity
• Managing Data Segments
• Managing Index Segments
• Monitoring Database Segments
Lab: Users and Security
Lab: Undo Segments
Module 7: Managing Tablespaces – Default Behavior of CREATE TABLESPACE Command
• Tablespace Overview
• System Tablespace
• Types of Tablespaces
• Creating Additional tablespaces
• Altering Tablespaces
• Temporary Tablespaces – Default
• Temporary Tablespaces
• Tablespace Quotas
• Monitoring Tablespaces
Lab: Managing Tablespaces
Module 8: Basic Oracle Architecture
• Architecture Overview
• Database Structures
• Process Structures
• Memory Structures – SGA
• Memory Structures – PGA
• Alternative Configurations
Lab: Multiple Block Size Management
Module 9: Oracle Database Files
• Basic Structures of an Oracle RDBMS
• Data Files
• Redo Log Files
• Archived Redo Log Files
• Control Files
• Oracle-Managed Files (OMF)
Lab: Advanced Memory Management
Module 10: Users and Security
• Managing Database Users
• System/Object Privileges
• Managing Roles/Profiles
• Resource and Password Management
• The Virtual Private Database
Lab: Oracle Database Files
Module 11: Networking
• Duties of the DBA for Networking
• Overview of Oracle Network Architecture
• Name Resolution
• Oracle Net Client Configuration
• Oracle Net Server Configuration
• Configuring the Listener
• Shared Server
Lab: Data Loading
Module 12: Physical NOARCHIVELOG Mode Backups
• Oracle Database Backups
• Automatic Recovery Architecture
• NOARCHIVELOG Mode
• ARCHIVELOG Mode
• Physical Backups
• Closed Backups in NOARCHIVELOG Mode
Module 13: Configuring Archivelog Mode
Module 14: Physical ARCHIVELOG Mode
Module 15: Backups
• Configuration of the Database for Archiving
• Setting the ARCHIVELOG Mode
• Establishing Multiple Archiving Destinations
• Closed Backups in ARCHIVELOG Mode
• Open Backups in ARCHIVELOG Mode
• Controlfile Backup
Lab: Backup and Archivelog Mode
Module 16: Complete Recovery
• Recovery Structures and Processes
• Recovery in NOARCHIVELOG and ARCHIVELOG Mode
Lab: Complete Recovery
Module 17: Incomplete Recovery
• What is Incomplete Recovery?
• Recovering from Loss of Current Redo Log Files
Lab: Incomplete Recovery
Module 18: Data Loading
• External Tables
• Data Pump
Module 19: Automation Tools
• The New Enterprise Manager
• DB Console
• Mgt. & Advisory Framework
• Automated Workload Repository