Oracle 11g Database Administration
Online interactive hands-on course help candidates to learn Oracle 11g Database Architecture and day-to-day activities of a DBA such as Database installation, backup & recovery, troubleshooting performance issues. We give special care to every candidates to complete the hands-on lab exercises on each topic.
Day 01
Introduction to DBA
• Relational Database Systems
• Integrity Constraints
• Structured Query Language
• Tasks of an Oracle Database Administrator
Oracle Server Installtion
• Installation of Oracle Database Software
• Optimal Flexible Architecture (OFA)
• Oracle Universal Installer
• Prerequisite Checks
• Configuration Assistants
Database Creation
• Creating an Oracle Database
• Database Architecture
• Exploring the Storage Structure
• Control Files
• Redo Log Files
• Tablespaces and Datafiles
• Segments, Extents, and Blocks
• Oracle Instance Management
• Oracle Memory Structures
• Oracle Processes
• Data Dictionary
• Database Control
• Grid Control
• Database Configuration Assistant (DBCA) Overview
• Creating a Database
• Passwords and Storage
• File Locations and Backup Recovery
• Content and Initialization Parameters
• Other Actions with DBCA
Day 2
Managing the Database
• Starting and Stopping iSQL*Plus
• Starting and Stopping Database Control
• Accessing Database Control
• SYSOPER and SYSDBA
• Database Home Page
• Changing the Listener Status
• NOMOUNT MOUNT OPEN States
• SHUTDOWN Options
• Initialization Parameter Files
• Viewing the Alert Log
Net Services
• Oracle Net Services
• Oracle Net Listener
• Monitoring the Listener
• Listening Addresses
• Static Database Registration
• Listener Control Utility
• Oracle Net Connections
• Directory Naming
• Advanced Connections
• Oracle Net Manager
• Configuring Service Aliases with Net Manager
Managing Schema Objects
• Schemas
• Accessing Schema Objects
• Schema Object Namespaces
• Specifying Data Types in Tables
• Other Data Types
• Creating and Modifying Tables
• Understanding Data Integrity
• Defining Constraints
• Viewing the Attributes of a Table
• Viewing the Contents of a Table
• Creating Indexes
• Creating Views
• Using a Sequence
Day 3
Storage Structures
• Tablespaces and Data Files
• Space Management in Tablespaces
• Storage for Locally Managed Tablespaces
• Altering a Tablespace
• Actions with Tablespaces
• Dropping Tablespaces
• Viewing Tablespace Information
Administering Users
• Database User Accounts
• Creating a User
• Profiles and Users
• Authenticating Users
• Database Users and Schemas
• Privileges : System and Object
Roles
• Assigning Quota to Users
• Assigning Roles to Users
Managing Data
• Manipulating Data Through SQL
• The INSERT Command
• The UPDATE Command
• The DELETE Command
• The COMMIT and ROLLBACK Commands
• Integrity Constraints and DML
Oracle Utilities
• Data Pump (Export & Import)
• DIRECTORY Objects
• SQL*Loader
• The SQL*Loader Control File
• Loading Methods
• Comparing Direct and Conventional Path Loads
• External Tables
• Transportable tablespace
Undo Management
• Undo Data
• Transactions and Undo Data
• Storing Undo Information
• Monitoring Undo
• Administering Undo
• Configuring Undo Retention
• Guaranteeing Undo Retention
• Sizing the Undo Tablespace
• Using the Undo Advisor
Day 4 and Day 5
Database Backup and Recovery
• Backup and Recovery Concepts
• Backup and Recovery Issues
• Categories of Failures
• Instance Recovery
• Phases of Instance Recovery
• Tuning Instance Recovery
• Using the MTTR Advisor
• Configuring for Recoverability
• ARCHIVELOG Mode
• Configuring Backup Strategy
• Scheduling Backups: Review
• Backup Control File to Trace
• Manage Backups
Database Recovery
• Opening a Database
• Changing Instance Status
• Keeping a Database Open
Scenarios:
• Loss of a Control File
• Loss of a Redo Log File
• Loss of a Data File in NOARCHIVELOG Mode
• Loss of a Noncritical Data File in ARCHIVELOG Mode
• Loss of a System-Critical Data File in ARCHIVELOG Mode
• Oracle Recovery Manager
• Oracle Recovery Catalog maintenance
• Backups using Oracle Recovery Manager
• Recovery using Oracle recovery manager
• Database Cloning using RMAN
• Tablespace Point in time recovery
• Incomplete recovery
Day 6
Database Monitoring
• Monitoring and Resolving Lock Conflicts
• Locks
• Locking Mechanism
• Data Concurrency
• DML Locks
• Enqueue Mechanism
• Lock Conflicts
• Possible Causes of Lock Conflicts
• Detecting Lock Conflicts
• Resolving Lock Conflicts
• Deadlocks
Performance Monitoring
• Monitoring Methodologies
• Database and Instance Metrics
• Data Dictionary Metrics
• Optimizer Statistics
• Schedule Optimizer Statistics Collection
• Dynamic Performance Views
• Viewing Metric Information
• Reacting to Performance Issues
• Reacting to Performance Issues
Proactive Maintenance
• Server Generated Alerts
• Thresholds
• Setting Thresholds
• Baseline Measurements
• Tuning and Diagnostic Advisors
• SQL Tuning and Access Advisors
• Memory Advisors
• Segment Advisor
• Automatic Workload Repository (AWR)
• Managing the AWR
• Automatic Database Diagnostic Monitor (ADDM)