Oracle Database 11g: Data Guard Administration

This Oracle Database 11g: Data Guard Administration Release 2 training helps you develop the skills to use Oracle Data Guard to help protect your Oracle database against planned and unplanned downtimes. Explore how Data Guard standby databases can be used to support production functions such as reporting, querying and testing, while in a standby role.

Learn To:

·         Offload business processing needs to another system

·         Offload backup needs to another system

·         Build highly available systems

·         Offload business processing needs to another system

Benefits to You

Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling smooth and rapid consolidation within your Datacenter.

Data Guard Architecture

This course explores Data Guard architecture, the configuration of physical and logical standby databases and role transitions. Expert instructors will also help you explore Oracle Data Guard 11g features, including Oracle Active Data Guard and snapshot standby databases.

Oracle Database 12c Backup and Recovery Workshop

This Oracle Database 12c: Backup and Recovery Workshop will teach you how to evaluate your own recovery requirements. You'll develop appropriate strategies for backup, restore and recovery procedures from provided scenarios.

Learn To:

·         Develop appropriate backup and recovery procedures to address your business needs.

·         Implement backup and recovery settings and perform backup operations to disk and tape.

·         Employ Oracle Database recovery procedures to recover from media and other failures.

·         Diagnose and repair data failures.

·         Use Flashback Technologies and data duplication to complement backup and recovery procedures.

·         Secure the availability of your database by appropriate backup and recovery strategies.

Benefits to You

Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds.

Perform Backup and Recovery

Expert instructors will begin by helping you gain a deeper understanding of possibly the most important job of a Database Administrator – backup and recovery. The concepts and architecture that support backup and recovery, along with the steps required to carry it out in various ways and situations, are covered in detail.

Recovery Manager Command Line and Graphical Interfaces

This course will teach you about Recovery Manager (RMAN) command line and graphical interfaces for various backup, failure, restore and recovery scenarios.

Participate in Hands-on Practices and Workshops

Participating in extensive hands-on practices and workshops will help you gain experience in a realistic technical environment. Interactive workshops give you the opportunity to diagnose and recover from numerous failure scenarios, based on backup and recovery case studies.

Key Takeaways

Upon completing this course, you will know how to evaluate your own recovery requirements. You'll have the skills to develop an appropriate strategy for backup and recovery procedures.

Course Objectives

·         Describe Oracle Database backup methods and recovery operations that can be used to resolve database failure.

·         Describe the Oracle Database architecture components related to backup and recovery operations.

·         Plan effective backup and recovery procedures.

·         Configure the database for recoverability.

·         Use Recovery Manager (RMAN) to create backups and perform recovery operations.

·         Use the Data Recovery Advisor to diagnose and repair failures.

·         Use Oracle Flashback Technologies to recover from human error.

·         Perform an encrypted database backup and restore.

·         Perform table space point-in-time recovery.

·         Describe additional high availability features such as Oracle Data Guard.

Oracle Database 12c ASM Administration

This Oracle Database 12c: ASM Administration training teaches you about Oracle ASM architecture. Expert Oracle University instructors will help you develop a deeper understanding of both standard ASM and Flex ASM applications.

Learn To:

·         Administer ASM files, directories, templates, and disk groups.

·         Manage and administer Oracle Cloud File System and its components.

·         Configure and manage advanced CloudFS features like ACFS Auditing and Encryption, ACFS Replication and High Availability NFS.

Benefits to You

Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds by learning about the Oracle Database 12c Grid Infrastructure, specifically Oracle ASM.

Course Objectives

·         Describe the components of ASM

·         Explain and apply Automatic Storage Management (ASM) initialization parameters

·         Manage ASM instances and associated processes

·         Monitor ASM using the V$ASM dynamic performance views

·         Understand Flex ASM architecture and components

·         Understand ASM Deployment Alternatives

·         Install and configure Flex ASM

·         Manage Flex ASM

·         Employ ASM space management techniques

·         Create and delete Automatic Storage Management (ASM) disk groups

·         Set the attributes of an existing ASM disk group

·         Perform ongoing maintenance tasks on ASM disk groups

·         Explain key performance and scalability considerations for ASM disk groups

·         Describe the Automatic Storage Management (ASM) architecture

·         Use different client tools to access ASM files

·         Describe the format of a fully qualified ASM file name

Oracle Grid Infrastructure Administration

This Oracle 11g: RAC and Grid Infrastructure Administration Accelerated training teaches you about the Oracle Grid Infrastructure products, including Oracle Automatic Storage Manager (ASM), ASM Cluster File System and Oracle Cluster ware. You will also learn to administer the Oracle Cluster ware and storage products using both command line utilities and graphical tools using both command line and graphical user interface clients.

Learn To:

·         Describe the Oracle Database 11g Grid Infrastructure.

·         Administer both Policy and Administrator managed RAC databases.

·         Install and configure Grid Infrastructure.

·         Describe Oracle Database 11g RAC enhancements and new features<./li>

·         Describe Grid Plug and Play.

·         Use Oracle Cluster ware to make applications highly available.

·         Troubleshoot the Oracle Cluster ware by examining log files, enabling debugging and enabling tracing for various utilities.

·         Add and remove nodes and explore quality of service concepts.

·         Upgrade or patch the Grid Infrastructure environment.

·         Upgrade and path Oracle RAC databases.

Benefits to You

Enrolling in this advanced course will help you develop the skills to leverage the Oracle Cluster ware to make applications highly available. You'll leave the class with the ability to support monitoring and failover to other nodes as well.

RAC Database Administration in the Oracle Grid Infrastructure Environment

Furthermore, you'll get hands-on training administering cluster databases using Enterprise Manager and command-line utilities like SRVCTL, CRSCTL and SQL*Plus. Expert Oracle University instructors will help you study the new connection architecture and how to make those connections highly available. Backup and recovery issues relative to cluster database environments will also be covered, along with Oracle RAC One Node and online migration.

Accelerated Course

This course is based on Oracle Database 11g Release 2. Please note that this is an accelerated course, covering 9 days' worth of content in only 5 days. Because of the extra content covered each day, the daily class duration may be slightly longer than usual.

Course Objectives

·         Understand Oracle Cluster ware architecture

·         Describe how Grid Plug and Play affects Cluster ware

·         Describe Automatic Storage Management (ASM) architecture

·         Perform Grid Infrastructure installation and create RAC database

·         Demonstrate Cluster ware management proficiency

·         Manage application resources

·         Troubleshoot Oracle Cluster ware

·         Administer ASM Instances and disk groups

·         Administer ASM Cluster File Systems

·         Install Oracle Database 11gR2 software and create RAC database

·         Manage RAC databases

·         Manage backup and recovery for RAC

·         Determine RAC-specific tuning components

·         Configure and manage services in a RAC environment

·         Describe high availability architectures

Oracle RAC (Real Application Cluster) Administration

This course will introduce you to the general features and capabilities of Oracle Database 11g Release 1 for Oracle Real Application Clusters (RAC). You'll learn how to install and administer Oracle Cluster ware and more.

Learn To:

·         Install Oracle Cluster ware and Real Application Clusters.

·         Administer a RAC Database.

·         Administer Database Services in a RAC environment.

·         Administer Oracle Cluster ware.

·         Add/Remove a node to/from a cluster.

·         Patch Oracle Cluster ware and RAC software.

·         Administer your Database in a Real Application Clusters environment using Enterprise Manager Grid Control.

·         Configure and use database services, along with the Load Balancing Advisory in a RAC environment.

Benefits to You

Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling smooth and rapid consolidation within your Datacenter.

Add & Remove Nodes in Clusters

This course will also teach you how to add and remove nodes in clusters. Learn how to patch both Oracle Cluster ware and Real Application Clusters software in a rolling fashion.

This course is appropriate for a 10g audience, too. There are few minor changes between 10g and 11g features.

Oracle Database 11g Advanced PLSQL

In this Oracle Database 11G Advanced PL/SQL training, expert Oracle University instructors will help you explore the advanced features of PL/SQL to design and tune PL/SQL. You'll learn how it interfaces with the database and other applications in the most efficient manner.

Learn To:

PL/SQL designing best practices.

Create PL/SQL applications that use collections.

Implement a virtual private database with fine-grained access control.

Write code to interface with external C and Java applications.

Write code to interface with large objects and use Secure File LOBs.

Write and tune PL/SQL code effectively to maximize performance.

Benefits to You

Extend the functionality of the SQL language with PL/SQL language to write application code. This will help your organization realize the full benefit of utilizing Oracle best practices.

Virtual Private Database

You'll also be introduced to Virtual Private Database (VPD) to implement security policies. Learn techniques and tools to strengthen applications against SQL injection attacks. Explore programming efficiency, use of external C and Java routines, PL/SQL server pages and fine-grained access.

Oracle 11g Administration II

This Oracle Database 11g: Administration Workshop II Release 2 training takes the database administrator beyond the basic tasks covered in the first workshop. You'll begin by gaining a deep understanding of the most important responsibilities a DBA has: performing backup and recovery.

Learn To:

·         Diagnose and repair data failures with Flashback technology.

·         Manage space to optimize database storage so you can respond to growing space requirements.

·         Monitor and manage major database components, including memory, performance and resources.

·         Secure the availability of your database through appropriate backup and recovery strategies.

·         Automate DBA tasks with the Scheduler.

Benefits to You

Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling smooth and rapid consolidation within your Datacenter.

Backup & Recovery

The concepts and architecture that support backup and recovery, along with the steps required to execute it in various ways and situations, are covered in detail. You'll learn how to define and test your own backup and recovery scenarios.

Manage Memory Effectively

You'll also learn how to manage memory effectively, as well as how to perform some performance evaluation and tuning tasks. Instructors will review all types of flashback technologies, scheduling jobs inside and outside of the database and controlling system resource usage.

Course Requirements

This course counts towards the Hands-on course requirement for the Oracle Database 11g Administrator Certification. Only instructor-led in class or instructor-led online formats of this course will meet the Certification Hands-on Requirement. Self-Study and Knowledge Center courses DO NOT meet the Hands-on Requirement.