Oracle 11g DBA Training Online :

Oracle Database 11g Administration

Exploring the Oracle Database Architecture
• Explain the Memory Structures
• Describe the Process Structures
• Overview of Storage Structures
Preparing the Database Environment
• Identify the tools for Administering an Oracle Database
• Plan an Oracle Database installation
• Install the Oracle software by using Oracle Universal Installer (OUI)
Creating an Oracle Database
• Create a database by using the Database Configuration Assistant (DBCA)
Managing the Oracle Instance
• Setting database initialization parameters
• Describe the stages of database startup and shutdown
• Using alert log and trace files
• Using data dictionary and dynamic performance views
Configuring the Oracle Network Environment
• Configure and Manage the Oracle Network
• Using the Oracle Shared Server architecture
Managing Database Storage Structures
• Overview of table space and data files
• Create and manage table spaces
• Space management in table spaces
Administering User Security
• Create and manage database user accounts
• Grant and revoke privileges
• Create and manage roles
• Create and manage profiles
Managing Undo Data
• Overview of Undo
• Transactions and undo data
• Managing undo

Implementing Oracle Database Security: Oracle 11g DBA Online Training
• Database Security and Principle of Least Privilege
• Work with Standard Database Auditing
Database Maintenance
• Use and manage optimizer statistics
• Use and manage Automatic Workload Repository (AWR)
• Use advisory framework
• Manage Alerts and Thresholds
Performance Management
• Use Automatic Memory Management
• Use Memory Advisors
• Troubleshoot invalid and unusable objects

Backup and Recovery Concepts
• Identify the types of failure that can occur in an Oracle database
• Describe ways to tune instance recovery
• Identify the importance of checkpoints, redo log files, and archived log files
• Overview of flash recovery area
• Configure ARCHIVELOG mode
Performing Database Backups
• Create consistent database backups
• Back up your database without shutting it down
• Create incremental backups
• Automate database backups
• Manage backups, view backup reports and monitor the flash recovery area
Performing Database Recovery
• Overview of Data Recovery Advisor
• Use Data Recovery Advisor to Perform recovery (Control file, Redo log file and Data file)
Moving Data
• Describe and use methods to move data (Directory objects, SQL*Loader, External Tables)
• Explain the general architecture of Oracle Data Pump
• Use Data Pump Export and Import to move data between Oracle databases

Configuring for Recoverability : Oracle 11g DBA Online Training
• Configure multiple archive log file destinations to increase availability
• Define, apply and use a retention policy
• Configure the Flash Recovery Area
• Use Flash Recovery Area
Using the RMAN Recovery Catalog
• Identify situations that require RMAN recovery catalog
• Create and configure a recovery catalog
• Synchronize the recovery catalog
• Create and Use RMAN stored scripts
• Back up the recovery catalog
• Create and use a virtual private catalog
Configuring Backup Specifications
• Configure backup settings
• Allocate channels to use in backing up
• Configure backup optimization
Using RMAN to Create Backups
• Create image file backups
• Create a whole database backup
• Enable fast incremental backup
• Create duplex backup and back up backup sets
• Create an archival backup for long-term retention
• Create a multisection, compressed and encrypted backup
• Report on and maintain backups

Using RMAN to Perform Recovery
• Perform complete recovery from a critical or noncritical data file loss using RMAN
• Perform incomplete recovery using RMAN
• Recover using incrementally updated backups
• Switch to image copies for fast recovery