Oracle Database 11g Release 2 DBA - Part I

Course Introduction

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

Session 1: INTRODUCTION TO ORACLE DATABASE 11g

• Relational database concepts
• Database administration tasks
• DBA responsibilities

Session 2: ORACLE DATABASE 11g ARCHITECTURE

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

Session 3: INSTALLATION AND CONFIGURATION OF AN ORACLE DATABASE

• System Hardware Requirements
• Optimal Flexible Architecture
• Authentication methods for a database
• Oracle environment variables
• Install Oracle software using the Oracle Universal Installer (OUI)
• Silent Install
• Use the database Configuration Assistant (DBCA)
• Create a database with DBCA
• Manage a database with DBCA
• Delete a database with DBCA
• Manage Templates using DBCA

Session 4: ADMINISTER A DATABASE INSTANCE

• 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 EM Database Console
• Access EM
• EM navigation
• Grant EM administrative privileges to a user
• Overview of Oracle Restart

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
• Use Enterprise Manager to create and configure the Listener
• Configure client connections with Net Manager
• View listener configuration
• Start and stop the Oracle listener
• Enable Oracle Restart to monitor the listener
• Use TNSPING to test Oracle Net connectivity
• Connect to the database
• Configure Net Services with Enterprise Manager
• Overview of Dedicated Server architecture
• Overview of Shared Server architecture
• Identify when to use Shared Servers and when to use Dedicated Servers

Session 6: MANAGE AN ORACLE INSTANCE

• Access an Oracle database
• Database authentication methods
• Password file
• The Startup Process
• The Shutdown Process
• Initialization parameters
• Shutdown a database and instance using SQL and EM
• Startup a database and instance using SQL and EM
• View alert log and trace files
• View or modify initialization parameters with EM

Session 7: TABLESPACE AND DATAFILE MANAGEMENT

• Overview of tablespaces and datafiles
• Use EM to view the storage structure of the database
• Create and alter tablespace commands
• 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
• Drop tablespace command

Session 8: MANAGE REDO LOGS

• Redo log overview
• Plan redo logs
• Redo log data dictionary tables
• Log switches and checkpoints
• Log file maintenance
• Add and drop log file members and groups
• Clear a log file
• Move or rename an online redo log file
• Multiplex redo log files
• Use EM to manage redo logs
• 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
• Replace a lost or damaged control file
• Mirror a control file
• 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
• Alter tables
• Create indexes
• View index attributes
• Create views
• Create and use sequences

Session 11: MANAGE USERS

• Database administration accounts
• User accounts
• Create a user account
• Operating system authentication
• Change a user's password
• Manage a user account
• Drop a user account
• Monitor user information
• Terminate user sessions
• Product user profiles

Session 12: MANAGE PROFILES AND RESOURCES

• Overview of user profiles
• Profile resource parameters
• Create profile command
• Manage passwords with profiles
• Control resource usage with profiles
• Maintain profiles
• Drop profiles

Session 13: MANAGING PRIVILEGES

• Database access
• Oracle supplied roles
• System level 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

Session 14: DATABASE AUDITING

• Overview of database auditing
• Auditing SYS statements
• Auditing end user sessions
• Statement auditing
• Privilege auditing
• Auditing modifications made to database objects
• Audit table relocation
• Auditing from Enterprise Manager

Session 15: UNDO MANAGEMENT

• Undo data overview
• Monitor and administer undo
• Configure undo retention
• Switch undo tablespaces
• Specify the retention period
• Guarantee undo retention
• Retention period for flashback queries
• View undo space information
• Use the undo advisor
• Size the undo tablespace
• Manage undo with EM

Session 16: MOVING DATA

• Create directory objects
• Data Pump Export and Import
  • Data Pump architecture
  • Data Pump data dictionary views
  • Data Pump interactive mode
  • Data Pump API
  • Use Data Pump to export data
  • Use Data Pump to import data
• SQL Loader
  • Overview of SQL Loader
  • Command line parameters
  • Record filtering
  • Control file keywords
  • Datafiles
  • SQL Loader data paths

Session 17: OVERVIEW OF MANAGING AN ASM INSTANCE

• Overview of Automatic Storage Management
• ASM Storage Components
• Set up initialization files for an ASM instance
• Startup and Shutdown ASM Instances
• Administer ASM disk groups
• Administer ASM Files

Session 18: DATA CONCURRENCY AND LOCK CONFLICTS

• Levels of locking in Oracle
• Methods used to acquire locks
• Possible causes of contention
• Deadlocks
• Prevent locking problems
• Detect lock contention
• Resolve conflicts in an emergency

Session 19: PROACTIVE DATABASE MAINTENANCE

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

Session 20: PERFORMANCE MANAGEMENT

• Tuning information sources
• Identify unusable objects
• Optimizer Statistics collection
• Automated statistics collection
• Performance metrics
• Use the advisors
• React to performance issues

Session 21: BACKUP AND RECOVERY CONSIDERATIONS

• Oracle Backup solutions
• Overview of Oracle Secure Backup
• Oracle Suggested Backup Strategy
• Database backup, restore and recover
• Types of failure
• Tune instance recovery
• Checkpoints, redo log files and archive log files
• Alter the ARCHIVELOG mode of a database
• Configure a database for recoverability

Session 22: DATABASE BACKUPS

• Types of RMAN backup
• Backup sets and image copies
• Perform backups using EM
• Automate database backups
• Configure backup settings
• Catalog settings
• Monitor the flash recovery area
• Manage backups

Session 23: DATABASE RECOVERY

• Restore and recovery operations
• Recover an entire database from backup
• Recover from the loss of a system critical data file
• Recover from the loss of a control file
• Recover from the loss of a redo log file
• Data Recovery Advisor

Session 24: ENHANCE THE CAPABILITIES OF THE DATABASE

• Enterprise Manager Support Workbench
• Register for security updates
• Work with Oracle support
• Log Service Requests
• Manage patches