Oracle Certification Program (OCP)


Book this course Online now & get 10% Discount on Course Fee


Course contents:


This course includes exam 1Z0-053.


Oracle Database Architecture Overview

  • ASM General Architecture
  • ASM Storage Concepts
  • ASM Scalability and Performance

Configuring for Recoverability

  • Oracle Backup and Recovery Solutions
  • Using Recovery Manager (RMAN)
  • Using a Flash Recovery Area
  • Flash Recovery Area Space Management

Using the RMAN Recovery Catalog

  • RMAN Repository Data Storage: Comparision of Options
  • Storing inforrmation in the Recovery Catalog
  • Registering a Database in the Recovery Catalog
  • Recovery Catalog Resynchronization: Concepts
  • Using RMAN Stored Scripts

Configuring Backup Specifications

  • Using RMAN to Create Backups
  • Configuring Persistent Settings for RMAN
  • Using Enterprise Manager to Configure RMAN Settings
  • Control File Auto-backups
  • Configuring Backup Optimization

Creating Backups

  • Creating an Oracle-Suggested Backup
  • Creating Backup Sets & Image Copies
  • Creating a Whole Database Backup
  • RMAN Backup
  • Monitoring Block Change Tracking
  • Creating Duplex Backup Sets

Creating Backups

  • Creating an Oracle-Suggested Backup
  • Creating Backup Sets & Image Copies
  • Creating a Whole Database Backup
  • RMAN Backup
  • Monitoring Block Change Tracking
  • Creating Duplex Backup Sets

Performing User-Managed Backup and Recovery

  • Restoring and Recovering
  • Causes of File Loss
  • Critical Versus Non-critical
  • Recovering from a TEMPFILE Loss
  • Recovering from a Lost Index Tablespace
  • Recovering a Read-Only Tablespace

Using RMAN to Perform Recovery

  • Using RMAN RESTORE and RECOVER Commands
  • Performing Recovery Using Enterprise Manager
  • Recovery Using Incrementally Updated Backups

Using RMAN to Duplicate a Database

  • Using RMAN to Create a Duplicate Database
  • Creating a Duplicate Database
  • Creating an Initialization Parameter File for the Auxiliary Instance
  • Allocating Auxiliary Channels
  • Understanding the RMAN Duplication Operation
  • Using EM to Clone a Database

Using Flashback Technology

  • Flashback Technology
  • Transactions and Undo
  • Guaranteeing Undo Retention
  • Preparing Your Database for Flashback
  • Flashback Drop and the Recycle Bin
  • Using Flashback Technology to Query Data

Using Flashback Database

  • Flashback Table
  • Flashback Database Architecture
  • Configuring Flashback Database

Diagnosing the Database

  • Automatic Diagnostic Workflow & Repository
  • Location for Diagnostic Traces
  • Viewing the Alert Log Using Enterprise Manager

Managing Memory

  • Oracle Memory Structures
  • Automatic Memory Management Overview
  • Oracle Database Memory Parameters
  • Automatic Shared Memory Management: Overview
  • Using the Memory Advisor to Size the SGA
  • Memory Tuning Guidelines for the Library Cache

Managing Database Performance

  • Tuning Activities
  • Performance Planning & Performance Tuning Methodology
  • Automatic Workload Repository
  • SQL Tuning & SQL Advisors
  • Using the SQL Tuning Advisor
  • SQL Access Advisor: Overview

Using the Segment Advisor

  • Space Management: Overview
  • Proactive Tablespace Monitoring
  • Shrinking Segments
  • Space Reclamation with ASSM
  • Automatic Segment Advisor

Managing Resources

  • Database Resource Manager: Overview
  • Database Resource Manager Concepts

Automating Tasks with the Scheduler

  • Simplifying Management Tasks
  • Key Components and Steps

Administering the Scheduler

  • Advanced Scheduler Concepts
  • Job Classes
  • Windows
  • Prioritizing Jobs Within a Window
  • Remote Jobs
  • Installing the Scheduler Agent
  • Dictionary Views Supporting Remote Jobs

ENQUIRY FORM