Oracle DBA Online Training

Oracle Training‎ > ‎

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

• 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

• 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

Register for training in our website: http://www.keylabstraining.com/sr