ORACLE DBA ONLINE TRAINING

ORACLE DBA SYLLABUS

Describe Oracle Database Architechture

Ø  Install and configure Oracle 11g

Ø  Configure Oracle Net Services

Ø  Manage the database storage structures

Ø  Create and administer user accounts

Ø  perform basic backup and recovery

Ø  Manage Users and schemas

Ø  Manage Data and Concurrency

Ø  Monitor and administer undo data

Ø  Backup and recover a database

Ø  Monitor performance

Ø  Use the database diagnostic Monitor

####Course Topics..####

Exploring the Oracle Database Architechture.

Ø  Oracle Database Architechture Overview

Ø  Oracle Asm Architechture Overview

Ø  Process Architechture

Ø  Memory Structures

Ø  Logical and Physical Storage Structures

Ø  Asm Storage Stuctures

####Installing your Oracle Software####

Ø  Tasks of an Oracle Database Administrator

Ø  Tools used to Administer an Oracle Database

Ø  Installation : System Requirements

Ø  Oracle Universal Installer (OUI)

Ø  Installing Oracle Grid Infrastructure

Ø  Installing Oracle Database Software

Ø  Silent Install

Ø  Creating an Oracle Database

Ø  planning the database

Ø  using the dbca to create a Database

Ø  password Management

Ø  Creating a Database Design Template

Ø  Using the DBCA to Delete a Database

Ø  Managing the Oracle Database Instance

Ø  Start and stop the Oracle Database and Components

Ø  Use Oracle Enterprise Manager

Ø  Access a Database with SQLPLUS

Ø  Modify database installation Parameters

Ø  Describe the stages of database startup

Ø  Describe database shutdown Options

Ø  View the alert log

Ø  Manage the ASM instance

Ø  set up initialization parameter files for ASM instance

Ø  startup and shut down ASM instances

Ø  Administer ASM Disk groups

Ø  Configuring the Oracle Network Environment

Ø  Use Enterprise Manager to Create and Configure the Listener

Ø  Enable Oracle Restart to Monitor the Listener

Ø  Use tnsping to test the Oracle Net Connectivity

Ø  Identify when to use shared servers and when to use dedicated servers

###Managing Database storage structures##

Ø  Storage Structures

Ø  How table data is stored

Ø  Anatomy of a Database Block

Ø  Space Management in Tablespaces

Ø  Tablespaces in the preconfigured Database

Ø  Actions with Tablespaces

Ø  Oracle Managed Files (OMF)

###Administering User Security###

Ø  Database User Accounts

Ø  Predefined Administrative Accounts

Ø  Benifts of Roles

Ø  Implementing Profiles

###Managing Data Concurrency###

Ø  Data Concurrency

Ø  Enqueue Mechanism

Ø  Resolving Lock Conflicts

Ø  Deadlocks

### MANAGING UNDO  DATA ###

Ø  Data Manipulation

Ø  Transactions and Undo Data

Ø  Undo Data Versus Redo Data

Ø  Configuring Undo Retention

## IMPLEMENTING ORACLE Database Auditing ###

Ø  Describe DBA responsibilities for security

Ø  Enable Standard database auditing

Ø  Specify audit options

Ø  Review audit  information

Ø  Maintain the audit trail

### DATABASE Maintenance ###

Ø  Manage optimizer statistics

Manage the Automatic Workload Repository (AWR)

Use the Automatic Database Diagnostic Monitor (ADDM)

Describe and use the advisory framework

set alert thresholds

use server - generated alerts

use automated tasks

### Performance Management ###

Performance Monitoring

Managing Memory Components

Enabling Automatic Memory Management (AMM)

Automatic Shared Memory Advisor

Using Memory Advisors

Dynamic Performance Statistics

Troubleshooting and Tuning views

Invalid and Unusable Objects

### Backup and Recovery Concepts ###

Part of your job

statement failure

User Error

Understanding Instance Recovery

Phases of Instance Recovery

Using the MTTR Advisor

Media Failure

Archive log files

###  Performing Database Backups Using Rman ###

Backup Solutions : Overview

Oracle Secure Backup

User - Managed Backup

Terminology

Recovery Manager (RMAN)

Configuring Backup Settings

Backing Up the control file to a trace file

Monitoring the Flash Recovery Area.

### Performing Database Recovery ###

OPening a Database

Data Recovery Advisor

Loss of a controlfile

loss of a redolog file

Data Recovery Advisor

Data failures

Listing Data Failures

Data Recovery Advisor Views

## Data Replication ##

Describe Ways to Move Data

Create and Use directory Objects

Use SQL * Loader to move Data

Use external tables to move data

General architechture of Oracle Data Pump

Use Data Pump export and import to move data.

### Working with Support ###

Use the Enterprise Manager Support Workbench

Work with Oracle Support

Log service requests (SR)

Manage Patches

### RMAN Topics ###

Backup Strategies

Flash Recovery Area

RMAN Architechture

RMAN backup Components

RMAN catalog and Configuration

RMAN Commands

Monitoring RMAN backups

Tuning RMAN Jobs

Restoring and recovering using RMAN

Database cloning using RMAN

Troubleshooting RMAN Issues

Best Practises

### 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

Backup 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 backup sets

create an archival backup for long term retention

create a multisection, compressed and encrypted backup

report on and maintain backups

### Performing User- Managed Backup and Recovery ###

Recover from a lost TEMP file

Recover from a lost redo log group

Recover from the loss of a password file

Perform User - Managed Complete database recovery

Perform User - Managed incomplete database recovery

Perform User - Managed and server Managed Backups

Identify the need of backup mode

Backup and recover a control file

#### Using RMAN to perform Recovery ####

Perform complete recovery from a critical or non critical

data file loss using RMAN

Perform incomplete recovery using RMAN

Recover Using incrementally Updated Backups

Switch to image copies for fast recovery

Restore a database onto a new host

Recover Using a backup control file

### Perform Disaster Recovery ###

Using RMAN to Duplicate a Database

Creating a duplicate database

using a duplicate database

Monitoring and tuning RMAN

#### Monitoring RMAN Sessions and jobs ###

Tuning RMAN

Configure RMAN for Asynchronous I/O

### ASM TOPICS ###

## Database Architecture and ASM ##

Describe Automatic Storage Management (ASM)

set up initialization parameter files for ASM and database

instances

start up and shut down ASM Instances

Administer ASM disk groups

Storage Fundamentals

ASM Concepts

Preparing ASM Storage

ASM Instance Setup

ASM diskgroups Failure groups (Redundancy)

Managing Disk groups

Backing up Diskgroups

Monitoring Diskgroups

Creating Database on ASM

Managing Database on ASM