Course 281:
Oracle Database Administration: Hands-On

(5 days)

 

Course Description

This course is your first step towards success as an Oracle DBA, designed to give you a firm foundation in basic database administration. In this class, you’ll learn how to create and maintain an Oracle database. You will gain an understanding of the Oracle database architecture and how its components work and interact with one another. You will also learn how to properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and basic backup/recovery techniques. The lesson topics are reinforced with structured hands-on practices.

Learning Objectives

  • Building, starting up, and shutting down the database
  • Creating and maintaining tablespaces
  • Configuring UNDO tablespaces and retention periods
  • Administering partitioned objects for maintenance and performance
  • Safeguarding using backup and restore techniques
  • Retrieving lost data from hardware and software failure
  • Managing user resources and privileges
  • Redefining, reorganizing, and shrinking tables online
  • Recovering from user error with flashback operations

Who Should Attend

Database administrators and others involved in the management of Oracle databases.

Prerequisites

Course 267: Oracle Database: A Comprehensive Hands-On Introduction, or equivalent SQL knowledge is assumed.


Course Outline

Introduction to Oracle Database Administration

  • Your Responsibilities as an Oracle DBA
  • Configuring the Instance and Database
  • Maintaining Security
  • Balancing User Requirements and Resources
  • Ensuring Database Availability

The Oracle Architecture

  • Processing Transactions with the Server
  • Identifying Types of Oracle Processes and Memory Structures
  • Determining Database File Structure
  • Archiving Redo Log Information
  • Sizing the Result Cache for Optimizing Repeated Queries

Building an Oracle Database

  • Creating the Database
  • Setting the Initialization Parameters
  • Simplifying Memory Allocation with Memory Targets
  • Establishing Network Connectivity
  • Converting from Text-Based to Server Parameter Files
  • Configuring Control Files and Redo Log Files
  • Starting and Stopping the Database
  • Mounting and Opening the Database with SQL*Plus
  • Authenticating Connections Having SYSDBA Privilege
  • Closing the Database and Shutting Down the Instance

Automating Database Management

  • The Oracle Enterprise Manager Architecture
  • Navigating the Graphical Interface
  • Comparing Command-Line and Graphical Techniques
  • Administering with Database Control
  • Equipping Database Control to Manage Additional Databases
  • Setting Thresholds and Generating Alerts
  • Verifying Changes in the Data Dictionary
  • Performing Privilege Management

Performing Flashback Operations

  • Resetting Data to Recent Points in Time with Flashback
  • Tracking Changes to Data Values with Row History
  • Obtaining Transaction History with Flashback Transaction
  • Performing Efficient Recovery of Data with Flashback Table
  • Retrieving Dropped Tables and Dependent Objects from the Recycle Bin

Securing the Database

  • Establishing User Accounts
  • Authenticating Users with Sophisticated Password Checking
  • Allocating Space Quotas for User Schemas
  • Limiting Resource Usage Through Profiles
  • Enforcing Security
  • Granting and Revoking System and Object Privileges
  • Simplifying Privilege Management with Roles
  • Preventing Changes to Read-Only Tables

Controlling Database Storage

  • Defining Logical and Physical Structures
  • Creating, Altering, and Dropping Tablespaces
  • Managing Space for Rollback and Read Consistency
  • Configuring UNDO Tablespaces
  • Monitoring Expansion of Rollback Segments
  • Swapping to an Alternative UNDO Tablespace
  • Handling Sort Data Efficiently with Temporary Tablespaces
  • Comparing Traditionally Managed and Oracle-Managed Files
  • Sizing Database Objects by Defining Extents and Block Occupancy
  • Eliminating Row Migration with PCTFREE and Data Pump
  • Shrinking Tables and Indexes Online to Regain Space

Partitioning to Support Administration and Availability

  • Creating Table Partitions and Subpartitions
  • Selecting Partitioning Methods: Range, List, Hash, Interval
  • Partitioning Tables Based on Virtual Columns
  • Setting Up Automatic Partition Allocation
  • Referencing the Partitioning Method in Child Tables
  • Administering Partitions with Merge, Split, Add, and Drop
  • Maintaining Index Partitions
  • Maximizing Performance with Local and Global Indexes
  • Monitoring Index Partition Usage
  • Rebuilding Unusable Indexes

Backing Up and Recovering the Database

  • Safeguarding the Database
  • Role of the Redo Log and Control File
  • Ensuring Recovery Using Archiving
  • Protecting and Tracing the Control File
  • Selecting a Backup Strategy
  • Implementing Hot and Cold Backups
  • Partial Online and Offline Backups
  • Restoring Tables with Data Pump
  • Performing Recovery of the Database or Individual Tablespaces

Fundamental Tuning Concepts

  • Sizing the Buffer Cache and Shared Pool
  • Balancing Disk I/O and Memory Allocation
  • Index Storage Considerations

 

Please Contact Your ROI Representative to Discuss Course Tailoring!