Skip to toolbar

Oracle 11g OCP -DBA

|Oracle 11g OCP Certification|

Training at Nhames Limited is a wonderful experience.

Oracle Database 11g extends Oracle’s unique ability to deliver the benefits of grid computing with more self-management and automation. Oracle Database 11g Administrator Certification combines training, experience, and testing to ensure that you have a strong foundation and expertise in the industry’s most advanced database management system.

Oracle Database 11g: Administration II
Course code: 1Z0-053

Course 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

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


Performing User-Managed Backup and Recovery

  • Recover from a lost TEMP file
  • Recover from a lost redo log group
  • Recover from the loss of 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
  • Back up and recover a control file


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


Performing Tablespace Point-in-Time Recovery
Identify the situations that require TSPITR
Perform automated TSPITR

Monitoring and Tuning RMAN

  • Monitoring RMAN sessions and jobs
  • Tuning RMAN
  • Configure RMAN for Asynchronous I/O


Using Flashback Technology

  • Restore dropped tables from the recycle bin
  • Perform Flashback Query
  • Use Flashback Transaction


Additional Flashback Operations

  • Perform Flashback Table operations
  • Configure, Monitor Flashback Database and Perform Flashback Database operations
  • Set up and use a Flashback Data Archive


Diagnosing the Database

  • Set up Automatic Diagnostic Repository
  • Using Support Workbench
  • Perform Block Media Recovery


Managing Memory
Implement Automatic Memory Management
Manually configure SGA parameters
Configure automatic PGA memory management

Managing Database Performance

  • Use the SQL Tuning Advisor
  • Use the SQL Access Advisor to tune a workload
  • Understand Database Replay


Space Management

  • Manage resumable space allocation
  • Describe the concepts of transportable tablespaces and databases
  • Reclaim wasted space from tables and indexes by using the segment shrink functionality


Managing Resources

  • Understand the database resource manager
  • Create and use Database Resource Manager Components


Automating Tasks with the Scheduler

  • Create a job, program, and schedule
  • Use a time-based or event-based schedule for executing Scheduler jobs
  • Create lightweight jobs
  • Use job chains to perform a series of related tasks


Administering the Scheduler

  • Create Windows and Job Classes
  • Use advanced Scheduler concepts to prioritize jobs

Then fill a form online at Oracle for your Hands-on

Why Train with us :

Menu

@

Not recently active

Send this to a friend