Oracle Database 11g Release 2 DBA - Part I

Follow-On Courses

• Oracle Database 11g Release 2 DBA - Part II

Introduction to Oracle Database 11g

• Relational database concepts
• Database administration tasks
• DBA responsibilities

Oracle Database 11g Architecture

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

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
• Upgrade a database using Database Upgrade Assistant (DBUA)

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

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 Shared Server architecture
• Identify when to use Shared Servers and when to use Dedicated Servers

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
• STARTUP a database and instance using SQL
• View alert log and trace files
• View or modify initialization parameters with EM

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

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

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

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

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

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

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

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
• Fine grained auditing
• Auditing from Enterprise Manager

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

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

Manage 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

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

Proactive Database Maintenance

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

Performance Management

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

Backup and Recovery Considerations

• 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

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

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
• Data Recovery Advisor Views

Work with Oracle support

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