Course Introduction

• Administration and Course Materials
• Course Structure and Agenda
• Delegate and Trainer Introductions

Session 1: INTRODUCTION TO ORACLE DATABASE 10G

• Relational database concepts
• Database administration tasks
• DBA responsibilities

Session 2: ORACLE DATABASE 10G ARCHITECTURE

• Oracle architecture
• The Oracle instance
• Memory structures
• Background processes
• Server and client processes
• The Oracle database

Session 3: INSTALLATION & CONFIGURATION OF AN ORACLE DATABASE

• Installation Prerequisites
• Understand system requirements
• Use optimal flexible architecture
• Authentication methods for a database
• Oracle environment variables
• Install Oracle software using the Oracle Universal Installer (OUI)
• Use the Database Configuration Assistant (DBCA) to create a database
• Use DBCA to manage templates
• Upgrade a database using Database Upgrade Assistant (DBUA)

Session 4: ADMINISTER A DATABASE

• Administrative tools available to a DBA
• Using SQL*Plus in Oracle to manage a database
• Administer the database using Enterprise Manager (EM)
• Start and stop the agent
• Start and stop the EM Database Console
• Access EM
• EM navigation
• Grant EM administrative privileges to a user

Session 5: CONFIGURE THE ORACLE NETWORK ENVIRONMENT

• Overview of network configuration
• Oracle Net Listener configuration and management
• Oracle Net Naming methods
• Tools for configuring and managing the Oracle network
• Configure client connections with Net Manager
• View listener configuration
• Start and stop the Oracle listener
• Use TNSPING to test Oracle Net connectivity
• Connect to the database

Session 6: MANAGE AN ORACLE INSTANCE

• Access an Oracle database
• Database authentication methods
• Initialization parameters
• Password file
• SHUTDOWN the database
• STARTUP the database
• View alert log and trace files

Session 7: TABLESPACE AND DATAFILE MANAGEMENT

• Overview of tablespaces and datafiles
• Use EM to view the storage structure of the database
• Create tablespace command
• Locally managed tablespaces
• Dictionary managed tablespaces
• Bigfile tablespaces
• Temporary tablespaces
• Multiple temporary tablespaces
• Create tablespaces
• Manage tablespaces
• Use standard and non-standard block sizes
• Create and manage tablespaces using OMF
• Manage tablespaces

Session 8: MANAGE REDO LOGS

• Redo log file structure
• Maintaining redo log files
• Log switches and checkpoints
• Multiplex redo log files
• Manage online redo log files with OMF
• List redo log information

Session 9: MANAGE CONTROL FILES

• The usage of the control file
• The contents of a control file
• Manage control files
• Standby control file
• Manage control files with OMF
• List control file information

Session 10: MANAGE SCHEMA OBJECTS

• Create a new table
• View the attributes and contents of a table
• Understand data integrity
• Define constraints
• Create indexes
• View index attributes
• Create views
• Create and use sequences

Session 11: MANAGE USERS

• Database administration accounts
• User accounts
• Create a user account
• Change a user's password
• Alter and drop a user account
• Monitor user information
• Terminate user sSessions

Session 12: MANAGE PROFILES AND RESOURCES

• Create profile command
• Manage passwords with profiles
• Control resource usage with profiles
• Alter and drop profile command

Session 13: MANAGING PRIVILEGES

• Database access
• System level roles and privileges
• Object level privileges
• The grant and revoke commands
• Create roles
• Modify and drop roles
• Control the availability of roles
• Use predefined roles
• Synonyms
• Listing valid grants
• Product user profiles

Session 14: DATABASE AUDITING

• Auditing SYS statements
• Auditing end user sessions
• Auditing the use of privileges
• Auditing modifications made to database objects
• Audit table relocation
• Fine grained auditing

Session 15: UNDO MANAGEMENT

• Undo data overview
• Monitor and administer undo
• Configure undo retention
• Guarantee undo retention
• Use the undo advisor
• Size the undo tablespace

Session 16: MANAGE DATA

• Use Data Pump to export data
• Use Data Pump to import data
• Use SQL Loader
• Create directory objects

Session 17: ORACLE SHARED SERVER

• When shared servers should be used
• Configure shared servers
• Monitor shared servers
• Shared server architecture

Session 18: MONITORING AND RESOLVING LOCK CONFLICTS

• Detect and resolve lock conflicts
• Manage deadlocks

Session 19: PROACTIVE DATABASE MAINTENANCE

• Automatic Workload Repository
• Automatic Database Diagnostic Monitoring
• Monitor an Oracle database
• Use the Advisors
• Set up notification rules

Session 20: PERFORMANCE MONITORING

• Troubleshoot invalid and unusable objects
• Gather optimizer statistics
• View performance metrics
• React to performance issues

Session 21: BACKUP AND RECOVERY CONSIDERATIONS

• Oracle Suggested Backup Strategy
• Plan and implement a backup and recovery strategy
• Define a backup strategy
• Define a disaster recovery plan
• The advantages and disadvantages of different backup methods
• Test a backup and recovery plan

Session 22: ORACLE RECOVERY STRUCTURES AND PROCESSES

• Architectural components of backup and restore
• Redo logs, checkpoints and archives
• Multiplexing control files and redo logs
• Types of database failure

Session 23: USING ARCHIVELOG AND NOARCHIVELOG MODES

• Configuring a database in Archivelog mode
• Configuring a database in Noarchivelog mode
• Configuring multiple redo log archive processes
• Configuring multiple archival destinations

Session 24: PHYSICAL BACKUP WITHOUT RMAN

• Closed and open backups
• Using operating system commands for database backup
• Performing offline backups
• Performing online backups
• Backup in logging and nologging modes
• Control file backups
• Data Dictionary views for backup operations

Session 25: COMPLETE DATABASE RECOVERY WITHOUT RMAN

• Recovery in NOARCHIVELOG mode
• Recovery in ARCHIVELOG mode

Session 26: INCOMPLETE RECOVERY WITH ARCHIVING

• When to use incomplete recovery
• Performing an incomplete recovery
• Recover from losing current and inactive noarchived redo log files

Session 27: ADDITIONAL RECOVERY ISSUES

• Minimizing downtime
• Rapid crash recovery
• Checkpointing and cache recovery
• Parallel recovery
• Trial recovery
• Recover a database with missing data files
• Rebuilding lost or damaged control files
• Recovering read-only tablespaces

Session 28: GLOBALIZATION

• Overview of globalization
• Language encoding schemes
• NLS character sets
• NLS language and territory definitions
• NLS data dictionary views
• Multi language linguistic sorts
• Date times with timezones
• Display formats
• Date functions
• Case and accent insensitive sorts

Session 29: TROUBLESHOOTING UTILITIES

• Using log and trace files to diagnose problems
• Detecting block corruption
• The ANALYZE command
• The DBMS_REPAIR package
• Use DBVERIFY to validate the database file structure
• Block media recovery

Session 30: RECOVERY MANAGER OVERVIEW

• RMAN features and components
• Connecting to RMAN without a recovery catalog
• Start up and shut down a target database using RMAN

Session 31: CREATING AND MAINTAINING A RECOVERY CATALOG

• Creating a recovery catalog
• Use a Flashback recovery area
• Register a database
• Connecting to RMAN
• Control file information
• RESYNC CATALOG command
• Configure persistent RMAN settings
• Retention policies
• Control file autobackups

Session 32: BACKING UP WITH RMAN

• Types of RMAN backup
• Backup Commands
• Backup sets parallelization
• Compressed backups
• Performing backups
• Full closed and open backups
• Incremental and cumulative backups
• The copy command
• Block change tracking
• Troubleshooting

Session 33: MAINTAINING A RECOVERY CATALOG

• Reset command
• Change the availability status of backups and copies
• Catalog backups made with operating system commands
• Cross check backups and copies
• Use data dictionary tables
• Update the repository after backup deletion

Session 34: RESTORING AND RECOVERING WITH RMAN

• Perform recovery in noarchivelog mode
• Perform complete recovery in archivelog mode
• Incomplete recovery using UNTIL TIME and UNTIL SEQUENCE
• Restore and recover a tablespace
• Restore and recover datafiles
• Recover a datafile not backed up
• Apply incremental backups to restore datafile image copies
• The SWITCH command

Session 35: FLASHBACK

• Configure and use flashback database
• Monitor flashback database
• Flash recovery area space usage
• Flashback query
• Retrieve row history with flashback versions query
• Audit or recover from transactions with Flashback transactions query
• Flashback table
• Recover dropped tables with flashback drop
• The recycle bin
• Recover tables to a point in time with flashback table
• Flashback database

Session 36: MANAGING RESOURCES WITH RESOURCE MANAGER

• Overview of the Database Resource Manager
• Create resource plans and consumer groups
• Create resource plan directives
• Control resource by user groups
• Specify an instance plan
• Fixed CPU Quotas
• Integrate Resource Manager and Profiles
• Automatic session assignment
• Monitor the Resource Manager

Session 37: AUTOMATIC STORAGE MANAGEMENT

• Overview of ASM
• ASM initialization parameter files
• Administer ASM disk groups
• Execute SQL commands with ASM file names
• ASM instance startup and shutdown
• Migrate a database to ASM

Session 38: AUTOMATING TASKS WITH THE SCHEDULER

• Introduction to the Scheduler
• Scheduler Architecture
• Program and job concepts
• Managing jobs and programs
• Prioritize jobs
• View job execution details
• Run external jobs

Session 39: AUTOMATIC DATABASE MANAGEMENT

• Automatic database management
• Monitoring the Oracle database
• Monitoring and managing storage
• Monitoring and managing memory
• Automatic PGA Memory Management
• Automatic Shared Memory Management
• Self monitoring architecture
• Automatic Workload repository
• Metrics, thresholds and alerts
• Automatic Database Diagnostics Monitor (ADDM)
• Monitoring and Tuning usage model
• Setting up Notification rules
• Using the Advisors

Session 40: MEMORY MANAGEMENT, ALERTS AND WAITS

• Memory Management
• Automatic memory management
• Memory advisors
• System generated alerts
• Threshold and event based alerts
• Wait Interface

Session 41: SQL PERFORMANCE TUNING

• Automated statistics collection
• Application statistics collection
• SQL Tuning advisor
• SQL Access advisor
• Segment advisor
• 10g Hints

Session 42: SECURING THE ORACLE LISTENER

• Listener Password Authentication
• Controlling Database Access
• Securing the EXTPROC Service Entry