After completing this course you would be able to perform duties Oracle DBA duties and you can appear for exam 1Z0-053 Oracle Database 11g: Administration II OCP.

Topics Covered

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

Who should attend

Anyone interested.

Pre-requisites

English, should have knowledge of IT.

What you need to bring

Below is per-requisite: You need to have=>your own desktop/Laptop at least 2GB and dual core or 3rd generation procession, at least 100GB Disk space. =>Internet access to attend online Instructor let course using Webex/Goto meeting."

Key Takeaways

After completing this course you would be able to perform duties Oracle DBA duties and you can appear for exam 1Z0-053 Oracle Database 11g: Administration II OCP.