Exadata – Advance Training

Oracle Exadata Database Machine (DBM) is software and hardware engineered together to provide the highest-performing and most-available platform for running Oracle Database. Exadata DBM is a modern architecture featuring scale-out industry-standard database servers, scale-out intelligent storage servers, state-of-the art PCI flash storage servers and an extremely high speed InfiniBand internal fabric that connects all servers and storage. Exadata runs all types of database workload including Online Transaction Processing (OLTP), Data Warehousing (DW), In-Memory Analytics and consolidation of mixed workload and is the ideal foundation for a consolidated database cloud.

Download Brochure

What you will learn?

Exadata Advanced Trainingfurther enriches your knowledge and understanding of Exadata gained through ExadataBoot Camp Hands-on Training. This course enables you to master the advanced topics of Exadata like Exadata Backup & Recovery, Exadata Patching procedures, Exadata Migration Procedures, Configuring DBFS on Exadata, Bulk Data Loading on Exadata, Configuring Exadata Storage Security, Monitoring Exadata, Exadata Maintenance Procedures,and various tools/utilities used to manage/monitor Exadata.The training methodology consists of both theory sessions and hands-on practices with 24x7 online lab access.

After completing this training, you should be able to handle advanced tasks related to Exadata

Training Highlights

  • Training by real time&hands-on Exadata expert
  • In-depth coverage and thorough explanation of all topics
  • Hands-on sessions with 24x7 online Lab Access
  • Session PPTs, Hands-on Lab Guide and online resources for additional reading

Who can attend?

  • Database Administrators
  • Sales Consultants
  • System Administrator
  • Technical Administrator
  • Technical Consultant

Suggested Pre-requisites

  • Exadat - Bootcamp Hands-on Training

[/vc_column_text][dt_gap height="25"][vc_tabs style="tab-style-one" interval="0"][vc_tab title="Introduction" tab_id="1426660931328-4-1ac11-c58efc5b-333c"][/vc_tab][vc_tab title="Course Content" tab_id="1424725573-1-52ac11-c58efc5b-333c"][vc_column_text]Introduction

  • Course Objectives
  • Prerequisites
  • Course Contents
  • Terminology
  • Introducing the Laboratory Environment

Exadata Database Machine Overview

  • What is Exadata?
  • Exadata Storage Server Features: Overview
  • Exadata Vs Traditional Storage Servers
  • What is Exadata Database Machine (DBM)?
  • Components of Database Machine
  • DBM Configurations
  • DBM Versions/Generations
  • DBM Hardware: Overview
  • DBM Software: Overview
  • DBM Scalability
  • Exadata Storage Expansion Racks
  • Exadata Elastic Configurations
  • Why Database Machine?

Exadata Database Machine Backup and Recovery

  • DBM Backup & Recovery Overview
  • Backup of Software on DB nodes
  • Recovering DB nodes using LVM snapshot based Backups
  • Reimaging a DB node
  • Overview Cell Backup
  • Understanding Cell Disk Layout
  • Cell System Volumes
  • Creating Cell Rescue Image using External USB
  • Recovering Storage Server
  • Cell Rescue Procedure
  • Reimaging Cell Server
  • Using RMAN to perform Database backups on DBM
  • Understanding Read I/O optimizations provided by Exadata for RMAN incremental backups
  • Understanding Recovery Optimizations provided by Exadata for RMAN
  • General Recommendations for RMAN
  • Disk-Based Backup Strategy
  • Disk-Based Backup Recommendations
  • Disk-Based Backup on non-exadata storage
  • Tape-Based Backup Strategy
  • Tape-Based Backup Architecture and Recommendations

Patching & Updating Exadata Database Machine

  • Patching and Updating: Overview
  • Rolling Vs Non-Rolling Methods
  • Maintaining Database Server Software
  • Bundle Patches, QDPE, QFSDP
  • Maintaining Exadata Storage Server Software
  • Understanding Internals of Storage Server Patching
  • Maintaining Firmware/Software on Other Components of DBM

Migrating Databases to Exadata Database Machine

  • Migration Best Practices: Overview
  • Performing Capacity Planning
  • Database Machine Migration Considerations
  • Choosing the Right Migration Path
  • Logical Migration Approaches
  • Physical Migration Approaches
  • Post-Migration Best Practices
  • Migrating to Database Machine Using Transportable Tablespaces

Bulk Data Loading using Oracle DBFS

  • Bulk Data Loading Using Oracle DBFS: Overview
  • Preparing the Data Files
  • Staging the Data Files
  • Configuring the Staging Area
  • Configuring the Target Database
  • Loading the Target Database

Exadata Storage Security

  • Overview of Exadata Storage Security
  • Exadata Storage Open Security
  • Overview of ASM Scoped Security
  • Overview of Database Scoped Security
  • Implementing ASM Scoped Security
  • Implementing Database Scoped Security

Monitoring Exadata Storage Servers

  • Exadata Metrics and Alerts Architecture
  • Monitoring Exadata Storage Server with Metrics and Alerts
  • Listing Metric definition and current metrics
  • Listing Alert history, Active Requests
  • Listing & Setting thresholds

Other Useful Monitoring Tools

  • Exachk: Overview
  • Running Exachk
  • Exachk Daemon
  • DiagTools: Overview
  • Using ADRCI on Exadata Storage Servers
  • Imageinfo: Overview
  • Imagehistory: Overview
  • ExaWatcher: Overview

Exadata Database Machine Maintenance Tasks

  • Database Machine Maintenance: Overview
  • Replacing a Damaged Physical Disk
  • Replacing a Damaged Flash Card
  • Moving All Disks from One Cell to Another

Powering Database Machine ON/OFF

  • Powering Database Machine On
  • Powering Database Machine Off
  • Shutting Down a Single Exadata Storage Server
  • Starting a Single Exadata Storage Server

UCLID IT School is the pioneer in Oracle Exadata Training.  At UCLID, you are assured to get pure and clean training on Oracle Exadata, handing by Mr. Muralidhar who is huge corporate experienced in Oracle Exadata. We have mastered the art of teaching Oracle DBA and changed many lives for good.  At UCLID, we follow an easy, simple and no-nonsense approach towards making you a master in Oracle DBA.

With it’s enviable & impeccable track record of training and placing thousands of students as Oracle DBAs in many IT organizations, Uclid has the following unique advantages:

  • Training by former employees of Oracle India and real time IT professionals from various top IT firms
  • Training on Real Time scenarios and case studies
  • Most in-depth and comprehensive training on every topic of the course
  • Well structured Training Material for future reference
  • Training on Latest Versions – Oracle 12c
  • Individual attention and group discussions for Interview preperation
  • Dedicated systems for Lab practice supported by qualified Lab Administrators and UPS for power backup
  • Unlimited Lab Access till you get job
  • 100% Placement Assistance backed by many top IT organizations (around 16 Top IT companies hire fresher DBAs from Uclid)
  • 100% Satisfaction guarenteed

The course Instructor, Muralidhar Punyala, was the practice manager for Oracle Exadata at Oracle India. He is an expert DBA with 20 years of extensive and in-depth experience in Database Planning, Design, Implementations, Performance Tuning, High Availability, Scalability, Database Security, Data Management, Upgrade/Migrations, Backup & Recovery, Disaster Recovery areas. Murali has worked with various Fortune 500 companies across the world in Singapore, Hong Kong, UK, Middle East & USA and rendered his DBA services for some of the world’s most complex and very large database projects. Murali holds the following credits:

  • Oracle Exadata 11gR2 Sales Specialist Assessment, from Oracle
  • Oracle Exadata 11gR2 Pre-Sales Specialist Assessment, from Oracle
  • Oracle Database 11gR2 Sales Specialist Assessment, from Oracle
  • Oracle Database 11gR2 Pre-Sales Specialist Assessment, from Oracle