Oracle Apps Online for Working professional by KYGNETEC Services & Solutions

ORACLE DBA Course Content

Backup and Recovery Considerations

Oracle Suggested Backup Strategy
Plan and Implement a Backup and Recovery Strategy
Define a Backup Strategy
Define a Disaster Recovery Plan
The Advantages and Disadvantages of Different Backup Methods
Test a Backup and Recovery Plan

Oracle Recovery Structures and Processes

Architectural Components of Backup and Restore
Redo Logs, Checkpoints and Archives
Multiplexing Control Files and Redo Logs
Types of Database Failure

Memory Management

Automatic Shared Memory Management
PGA Memory Management
Automatic Memory Management
The Memory Advisor
Memory Allocation Advisors
Memory Management Data Dictionary Views

Using ARCHIVELOG and NOARCHIVELOG Modes

The Archive Modes of a Database
Altering the Archive Mode of a Database
Configuring Multiple Archival Destinations
Configuring Multiple ARCH Processes
Data Dictionary Tables for Archiving

Troubleshooting Utilities

Database Synchronization
Using Log and Trace Files to Diagnose Problems
Detecting Block Corruption
DB_BLOCK_CHECKSUM
DB_BLOCK_CHECKING
The ANALYZE Command
The DBMS_REPAIR Package
Use DBVERIFY to Validate the Database File Structure
Block Media Recovery
Automatic Diagnostic Repository (ADR)
The ADR Command Line Tool (ADRCI)
The Health Monitor

Recovery Manager Overview

Overview of Recovery Manager
RMAN Features and Components
Connect to RMAN
Start Up and Shut Down a Target Database Using RMAN

Create a Recovery Catalog

Recovery Catalog Overview
Create a Recovery Catalog
Use a Flashback Recovery Area
Register and Unregister a Database
Control File Information
RESYNC CATALOG command
Virtual Private Catalogs
Merge Catalogs
Backup a Recovery Catalog

Backing up with RMAN

Channel Allocation
The Configure Channel Command
Types of RMAN Backup
Recovery Manager Commands
Performing Backups with RMAN
The Backup Command
The Copy Command
Backup File Image Copies
Perform Full, Incremental and Cumulative Backups
Use Data Dictionary Tables

Maintain a Recovery Catalog

Reset Database Command
Change the Availability Status of Backups and Copies
Catalog Backups Made with Operating System Commands
Generate Reports and Lists
Configuration Values
Cross Check Backups and Copies
Delete Backups
Drop Database and Archival Backups

Restore and Recover with RMAN

Overview of Restore
The Restore Command
Restore a Database in Noarchivelog Mode
Restore and Recover a Database in Archivelog Mode
Incomplete Recovery using Until Time and Until Sequence
Restore and Recover a Tablespace
Automatic tempfile Recovery
Recover a Datafile Not Backed Up
Recover a Lost Redo Log Group
Re-create a Password Authentication File
Apply Incremental Backups to Restore Datafile Image Copies
The Switch command
The Data Recovery Advisor (DRA)
Restore and Recover the Database on a New Host

Create a Duplicate Database with RMAN

Overview of Database Duplication
Database Duplication
Duplication Options
Create Files for the Duplicate Database
Prepare an Auxiliary Instance for Duplication
Create a Duplicate Database
Clone a Running Database without a Backup
Targetless duplication of a database

Manage Space for the Database

Transport Tablespaces
Transport Databases

Monitor, Tune and Troubleshoot Backup & Recovery

Recovery Manager Tuning Overview
Tuning RMAN Backup Performance
Synchronous and Asynchronous I/O
Instance Recovery Performance Tuning
RMAN Messages
Troubleshoot RMAN
RMAN Detected Block Corruptions
Performance impact of MAXPIECESIZE, FILESPERSET, MAXOPENFILES and BACKUP DURATION

Flashback

Configure and Use Flashback Database
Monitor Flashback Database
Flash Recovery Area Space Usage
Flashback Query
Retrieve Row History with Flashback Versions Query
Audit or Recover from Transactions with Flashback Transactions Query
Flashback Table
Recover Dropped Tables with Flashback Drop
The Recycle Bin
Recover Tables to a Point in Time with Flashback Table
Flashback Database
Flashback Restore Points
Flashback Transaction Backout

Oracle Total Recall

Overview of Oracle Total Recall
Manage Flashback Archives
Flashback Data Archive and Auditing
Flashback Data Archive Uses

Automate Tasks with the Scheduler

Introduction to the Scheduler
Scheduler Related Parameters
Access Rights
Create a Program
Drop a Program
Create a Schedule
Create a Job
Job Classes
Windows
Window Group
Events and Chains
Monitoring and Logging
Use Time Based, Event Based and Complex Schedules
Multi Destination Jobs

Manage Space in Segments

Tablespace Monitoring
Segment Management Enhancements
Segment Advisor
Segment Space Estimation
Online Segment Shrink
Proactive Tablespace Management

Manage Space in Blocks

Free Space Management
Monitor Space
Compress Data

Manage Database Performance

Tuning Activities
Use Statistic Preferences
Optimizer Statistics Collection
Monitor The Performance of Sessions And Services
Automatic Workload Repository (AWR)
The Benefits of Automatic Database Replay

Database Performance by SQL Tuning

Application and SQL Tuning
SQL Tuning Advisor
SQL Access Advisor
SQL Performance Analyzer

Automatic Storage Management

Overview of ASM
ASM Instance Creation
SYSASM Role
Administer ASM Disk Groups
ASM Files
ASM Startup and Shutdown
ASM Data Dictionary Views
Migrate a Database to ASM Using RMAN
The ASM Command Line Tool
Use 4KB Sector Disks

Managing Resources with Resource Manager

Overview of the Database Resource Manager
Create Resource Plans
Create Resource Consumer Groups
Create Resource Plan Directives
Limit CPU Utilization at the Database Level
Instance Caging
Control Resources by User Groups
Specify an Instance Plan
Monitor the Resource Manager
Data Dictionary Views