PREREQUISITES: SQL and PL/SQL or comparable experience is required. Knowledge of routine database administration tasks is recommended. Students without database administration experience will likely struggle with this class.
WHO SHOULD ATTEND? Oracle database administrators will benefit from this course.
COURSE DESCRIPTION: This course provides the information for database administrators to become fully responsible for ongoing Oracle database operations, backup, recovery, tuning and using advanced features of the Oracle database. The first 2-day segment provides in-depth understanding of backup and recovery concepts, backup set-up, and using RMAN in practical backup and recovery scenarios. The remaining 2 days cover advanced administration tasks such as understanding the Oracle self-tuning database approach, utilizing the Oracle scheduler, controlling resource utilization through Resource Plans, comprehensive coverage of the various Flashback technologies, Oracle support for multi-national/lingual functionality and using Automatic Storage Management.
BENEFITS OF ATTENDANCE: The student will be able to:
Enhance the security of Oracle by 'hardening' the Listener
Prepare for Oracle failures by implementing appropriate backup procedure(s)
Recover from Oracle failures caused by individual users
Recovery from non-critical Oracle database failures
Recover from critical Oracle database failures
Discover and recover from block corruption
Utilize the automated performance monitoring and tuning features of Oracle
Utilize Oracle resource management
Schedule background jobs using the Oracle Scheduler
Use the different Flashback capabilities of the Oracle database
Understand multi-national Oracle capabilities (globalization)
Configure Automatic Storage Management (ASM)
COURSE OUTLINE
CHAPTER 1: COURSE OVERVIEW AND INTRODUCTION
1) Review of some Oracle10g New Features
2) Oracle10/11g Architecture
3) Oracle's "Self-tuning" Database components
4) Enterprise Manager's Advisors
5) Overview of RMAN Enhancements
CHAPTER 2: SECURING THE LISTENER
1) Reviewing the TNS Architecture
2) Installing lsnrctl.exe on a Client
3) Steps to "Harden" the TNS Listener
CHAPTER 3: OVERVIEW OF RECOVERY MANAGER (RMAN)
1) RMAN Features
2) RMAN Architecture
3) RMAN Commands
4) Remote Operations
5) Redo and Undo data content
6) Recovery Concepts
CHAPTER 4: CONFIGURING RMAN
1) Determine RMAN Configuration
2) Alternative Ways to Run RMAN
3) Understanding the Recovery Catalog
4) Retention Policies
5) Backing Up Using Enterprise Manager
CHAPTER 5: BACKING UP USING RMAN
1) Identify the Types of Backups Supported by RMAN
2) Manage File Copy Backups
3) Define a Backup Set
4) Using Incremental Backups
5) Understand the RMAN Backup Algorithm
CHAPTER 6: RECOVERING FROM NON-CRITICAL CRASHES
1) Recover Temporary Tablespaces
2) Recover a Redo Log Group Member
3) Recover an Index Tablespace
4) Recover Read-Only Tablespaces
5) Recreate the Password File
CHAPTER 7: DATABASE RECOVERY
1) Recovering the Control File
2) Reasons for Incomplete Recovery
3) Performing Incomplete Recovery
4) Performing Database Recovery Following RESETLOGS
5) Performing BMR (Block Media Recovery) and Trial Recovery
6) Performing Complete Recovery using RMAN and EM
CHAPTER 8: FLASHBACK DATABASE
1) Match Flashback Technology to Different Recovery Situations
2) Using Flashback Database
3) Manage Flashback Database Using Enterprise Manager
4) Manage and Maintain the Flash Recovery Area
CHAPTER 9: RECOVERING USER ERRORS
1) Recover Dropped Tables using Flashback
2) Perform Flashback Table
3) Manage the Oracle Recycle Bin
4) Recover User Errors using Flashback Versions Query
5) Perform Transaction Recovery using Flashback Transaction Query
CHAPTER 10: HANDLING BLOCK CORRUPTION
1) Block Corruption and Its Causes and Symptoms.
2) Using ANALYZE and DBVERIFY to Detect Block Corruptions
3) Detecting Corruptions Using dbms_repair
4) The DB_BLOCK_CHECKING parameter
5) Using RMAN’s BMR to Repair Block Corruption
CHAPTER 11: AUTOMATIC WORKLOAD REPOSITORY (AWR)
1) The Common Manageability Infrastructure (CMI)
2) How the Automatic Workload Repository (AWR) Collects Statistics
3) Enabling the AWR
4) Active Session History (ASH) in Oracle
5) AWR Snapshots and Baselines
6) Using AWR Reports
CHAPTER 12: AUTOMATIC DATABASE DIAGNOSTIC MANAGER (ADDM) AND THE ADVISOR FRAMEWORK
1) The Common Manageability (CMI) Infrastructure: ADDM
2) Setting and Using Server-Generated Alerts
3) Using Database Advisors
4) Using the Segment Tuning Advisor
5) Using the SQL Tuning Advisor
CHAPTER 13: DATABASE RESOURCE MANAGEMENT
1) Configuring the Oracle Database Resource Manager
2) Assigning Users to Resource Manager Groups
3) Creating Resource Plans Within Groups
4) Specifying Resource Directives to Consumer Groups
CHAPTER 14: THE SCHEDULER
1) Core Scheduler Features
2) Simplifying Administration Tasks Using the Scheduler
3) Creating Jobs, Programs, Schedules & Windows
4) Reusing Scheduler Components
5) Viewing Information About Job Executions and Instances
CHAPTER 15: GLOBALIZATION SUPPORT
1) Customize Language-Dependent Behavior
2) Specifying Different Linguistic Sorts for Queries
3) Using Timestamp Datatypes
CHAPTER 16: AUTOMATIC STORAGE MANAGEMENT (ASM)
1) Understanding Automatic Storage Management
2) Administering an ASM Instance
3) Configuring the Components of ASM
4) Using ASM in the Database
5) Viewing Information About ASM
