Oracle Database 11g: Administration Workshop II Course Description
In this course, the concepts and architecture that support backup and recovery, along with the steps of how to carry it out in various ways and situations, are covered in detail. This includes how to define and test your own backup and recovery scenarios.
Also, the students learn to manage memory effectively and to perform some performance evaluation and tuning tasks, including using some of the advisors. All types of flashback technologies, scheduling jobs inside and outside of the database, and controlling system resource usage are covered. Topics are reinforced with hands-on practices. Intended Audience for the Oracle Database 11g: Administration Workshop II Course- Database Administrators
- Data Warehouse Administrator
- Technical Consultant
- Support Engineer
Training Packages & Career Tracks that include the Oracle Database 11g: Administration Workshop II Course
Oracle Database 11g: Administration Workshop II Course Objectives
- Back up and recover a database
- Configure Oracle Database for optimal recovery
- Administer ASM disk groups
- Use an RMAN backup to duplicate a database
- Automating Tasks with the Scheduler
Required Prerequisites for the Oracle Database 11g: Administration Workshop II course
The Oracle Database 11g: Administration Workshop II Course prepare students for the following Exams- 1Z0-053 : Oracle Database 11g: Administration II
Oracle Database 11g: Administration Workshop II Course Outline
- Database Architecture and ASM
- Oracle Database Architecture Overview
- ASM General Architecture
- Creating an ASM Instance
- Using Enterprise Manager to Manage ASM Users
- ASM Storage Concepts
- The ASMCMD Utility
- ASM Scalability and Performance
- Configuring for Recoverability
- Purpose of Backup and Recovery Functionality
- Typical Backup and Recovery Tasks
- 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: Comparison of Options
- Storing Information in the Recovery Catalog
- Registering a Database in the Recovery Catalog
- Recovery Catalog Resynchronization: Concepts
- Using RMAN Stored Scripts
- Backing Up and Recovering the Recovery Catalog
- Using a Virtual Private Catalog
- Configuring Backup Specifications
- Using RMAN to Create Backups
- Configuring Persistent Settings for RMAN
- Using Enterprise Manager to Configure RMAN Settings
- Control File Auto-backups
- Managing Persistent Settings
- Configuring Devices for Backup
- Configuring and Allocating Channels for Use in Backups
- Configuring Backup Optimization
- Creating Backups
- Creating an Oracle-Suggested Backup
- Creating Backup Sets & Image Copies
- Creating a Whole Database Backup
- RMAN Backup Types
- Monitoring Block Change Tracking
- Creating Duplex Backup Sets
- Archival Backups: Concepts
- Encrypting Backups
- Performing User-Managed Backup and Recovery
- Restoring and Recovering
- Causes of File Loss
- Critical Versus Non-critical
- Recovering from a TEMPFILE Loss
- Re-creating Indexes
- Recovering from a Lost Index Tablespace
- Authentication Methods for Database Administrators
- 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
- Perform a Fast Switch to Image Copies
- Restoring and Recovering the Database on a New Host
- Performing Disaster Recovery
- 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
- Cloning a Running Database
- Performing Tablespace Point-in-time Recovery
- Tablespace Point-in-Time Recovery (TSPITR) Concepts
- Tablespace Point-in-Time Recovery: Architecture
- Understanding When to Use TSPITR
- Determining the Tablespaces for the Recovery Set
- Using Enterprise Manager to Perform TSPITR
- Understanding TSPITR Processing
- Troubleshooting RMAN TSPITR
- Monitoring and Tuning RMAN
- Parallelization of Backup Sets
- Monitoring RMAN Sessions
- Interpreting RMAN Message Output
- Using the DEBUG Option
- Tuning RMAN
- RMAN Multiplexing
- Comparing Synchronous and Asynchronous I/O
- Tape Subsystem Performance Rules
- 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
- Possible Workflow
- Flashback Transaction Wizard
- Using Flashback Database
- Flashback Table
- Enabling Row Movement on a Table
- Enabling Row Movement on a Table
- Flashback Database Architecture
- Configuring Flashback Database
- Performing Flashback Database Using EM
- Flashback Database Considerations
- Flashback Data Archive
- Diagnosing the Database
- Automatic Diagnostic Workflow & Repository
- Location for Diagnostic Traces
- Viewing the Alert Log Using Enterprise Manager
- The Support Workbench and Oracle Configuration Manager
- Create a Service Request
- Package and upload diagnostic data to Oracle Support
- Incident Packaging Configuration
- Health Monitor Overview & Data Recovery Advisor
- Managing Memory
- Oracle Memory Structures
- Automatic Memory Management Overview
- Oracle Database Memory Parameters
- Auto Memory Parameter Dependency
- Automatic Shared Memory Management: Overview
- Automatic PGA Memory Management
- 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
- Instance Tuning
- Troubleshooting and Tuning Views
- 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
- Thresholds and Resolving Space Problems
- Monitoring Tablespace Space Usage
- Shrinking Segments
- Space Reclamation with ASSM
- Automatic Segment Advisor
- Minimum Compatibility Level
- Managing Resources
- Database Resource Manager: Overview
- Database Resource Manager Concepts
- Accessing Resource Plans
- Default Maintenance Resource Manager Plan
- Creating Consumer Groups
- Resource Allocation Methods for Resource Plans
- Resource Allocation Methods for Resource Plans
- Monitoring the Resource Manager
- Automating Tasks with the Scheduler
- Simplifying Management Tasks
- Key Components and Steps
- Creating an Event-Based Schedule
- Creating Complex Schedules
- Creating Job Chains
- Creating Job Chains
- 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
- Globalization
- Globalization Support Features
- What Every DBA Needs to Know
- Understanding Unicode
- Database Character Sets and National Character Sets
- Language- and Territory-Dependent Parameters
- Linguistic Searching and Sorting
- Case- and Accent-Insensitive Search and Sort
- NLS Data Conversion with Oracle Utilities
Benefits of taking the Oracle Database 11g: Administration Workshop II course at NetCom
-
Why choose Oracle Training at NetCom Learning?
As a recognition for training excellence, NetCom Learning was chosen by Microsoft as the 2007 Worldwide Learning Solutions Partner of the year out of 1400 training companies. In addition, we have won numerous other training awards for quality and customer satisfaction by CompTIA, EC-Council and other vendors. We are simply passionate about learning and achieving the highest customer satisfaction in your learning experience!
-
NetCom provides Authorized Training
NetCom Learning is a Microsoft Gold Certified Partner for Learning Solutions (CPLS), Cisco Learning Partner, CompTIA Platinum Partner, EC-Council Accredited Training Center, Adobe Authorized Training Center, Autodesk Authorized Training Center and many others. We are proud to offer the highest quality, authorized training solutions from our many partners for our customers.
See our comprehensive list of partner authorizations.
-
Award winning, world-class Instructors
- Masters Degree in Computer Science from Boston University along with several certifications.
- Over 25 years of experience in the IT field and expert in Unix, GNU/Linux, and Oracle ecosystems.
- More than 10 years working as a Software Engineer in multinational companies such as Hewlett-Packard.
Bio:
Finnbarr has both breadth and in-depth knowledge of Unix, GNU/Linux, and Oracle with 25+ years of experience in operating system internals development, system administration, application development and project management on a wide variety of hardware and software platforms. As a Software Engineer, he developed and managed numerous projects in multinational companies such as Hewlett-Packard.
Finnbarr is a member of the Institute of Electrical and Electronic Engineers as well as a Moderator at unix.com. He is also a top Instructor and Subject Matter Expert at NetCom Learning and is well recognized by the students for his knowledge and his great teaching technique.
|
-
Actual Client Testimonials
|
May 15 2012 |
Training environment and material are good. Materials are clear and short to the point. Instructor is very knowledgeable and full of experience. I've learned so much through the lecture as well as from his real life experiences.
-Aye M.
|
| Course(s) Taken |
|
|
|
|
May 15 2012 |
Great training! Great instructor!
-Fasika M.
|
| Course(s) Taken |
|
|
|
|
May 15 2012 |
This was a much needed and intensive training.
-Paul V.
|
| Course(s) Taken |
|
|
|
|
May 15 2012 |
Great experience! Geoff is awesome :-)
-Nadie H.
|
| Course(s) Taken |
|
|
|
|
Aug 29 2011 |
My instructor is very knowledgeable. He was capable of answering all questions and explaining all material in detail. I am glad I chose NetCm for my training. All of the NetCm staff were courteous helpful, and polite.
-Adrienne B.
|
| Course(s) Taken |
|
|
|
|
Jul 02 2011 |
I am very pleased about my experience with NetCom Learning. It was a great course! The best experience I could have expected. Great instructor! Great everything! I am very happy. Thank You!
-Lorena M.
|
| Course(s) Taken |
|
|
|
|
Jul 02 2011 |
Very clean facilities, super friendly staff, knowledgeable instructor.
-Alma C.
|
| Course(s) Taken |
|
|
|
|
Jul 02 2011 |
Geoff was a great instructor during the Oracle course. He ensured I understood the material and brought a sense of fun to the class. I really really have to study for the certification course due to my limited database management skills. This training and certification will hopefully allow me to start a new career.
-Denise L.
|
| Course(s) Taken |
|
|
|
-
Awards won by NetCom
NetCom Learning is an award winning, customer focused company. We are simply Passionate About Learning!
See our list of awards.
-
Specialized Boot Camp Training
This training is also available as a boot camp. NetCom is world famous for delivering specialized boot camp training to our clients. For answers to questions regarding our boot camp training delivery format, please refer to our Boot Camp FAQ section.
Enrollment Options for the Oracle Database 11g: Administration Workshop II course
Training Delivery Methods
Take this training with one of the following training delivery methods
-
Classroom Training
NetCom’s classroom training ensures that you have state-of-the-art tools, techniques and practices you need to succeed on the job. Our instructors are active practitioners and true masters in their fields. With convenient classes at multiple learning centers across the US, you never have to go far to get ahead.
-
Live Online Training (LOT)
NetCom’s premium Live Online Training (we call it LOT) is the ultimate in convenience and cost-effectiveness. LOT combines interactive video instruction via the latest web conference technology, and post-class access to learning labs for a best-in-class learning experience. Learn more about LOT
-
Boot Camp Training
NetCom’s intensive boot camps are designed to advance your skills in the shortest possible amount of time and get you certified. Boot camps go at a faster pace and often run for longer days, so you must have some level of subject matter experience before enrolling. Boot camps have mandatory assessment tests to ensure no one will slow down the class for other students. Learn more about Boot Camps
-
Private Onsite Training
With NetCom’s private training programs, you decide where and when courses are held. Tailor the training to reflect your industry, corporate culture, goals and schedule. You pick the course content, length of training and instructional technique. Save money by doing bulk customized training. Learn more about Private Onsite Training
-
Private 1-on-1 Training
NetCom’s private 1-on-1 training focuses on the highest quality training possible. You get individualized, full attention from the instructor and you decide where and when courses are held. The training is custom tailored to reflect your industry, corporate culture, goals and schedule. You pick the course content, length of training and instructional technique. Learn more about Private 1-on-1 Training
Contact us
|
Duration: 5 days (40 hours)
Pricing: Variable, please request
Why pricing varies..Why pricing varies..
Pricing depends on different training delivery methods, one or more students and availability of volume discounts or currently available promotions.
Our prices are frequently lower since we are able to work with our clients closely on their needs and pass on the optimum amount of savings.
In addition, we provide a price match guarantee for any competitive quotes. click to Live Chat
Click on a date to register.  Live Online Training available
New York, Jun 25, 2012
New York, Sep 17, 2012
New York, Sep 29, 2012
more..
For a customized version of this class, please contact us or call 1-888-563-8266.
|
|
 |
Need course pricing?
Need more information?
Worried about financing?
|
|
|
|
