Boot-Up Training for OCP, Oracle 11g

Training/Coaching/Tuition by ACLM Institute of Professional Studies Ghaziabad View Contact

Request Info

Learn how to:

• Install, configure, and administer Oracle Database systems

• Manage and maintain an Oracle Database

• Plan, design and create tables

• Create and update reports from Oracle Databases

• Query Oracle databases using SQL and iSQL*Plus to retrieve critical business data

• Backup and recovery of database systems

• Tune and optimize a Oracle Database for most efficient use of computer resources

Audience and Prerequisites
This course is designed for individuals with the Oracle 11g Certified Associate certification or equivalent knowledge.

Course Content

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

ACLM Institute of Professional Studies

Advanced Computing Literacy Mission (ACLM) has been setup very recently with the aim to put up an strong examples of 16000 students in the field of technological services by the end of 2015. ACLM is affiliated with AISECT and Dr. C.V. Raman Universities for carrying out the training courses of degree, diploma and other certificate courses.

AISECT has completed 25 years in building careers and turning peoples into action. Now, the AISECT becomes a large university having more than 10 Lakhs students are being benefitted every year throughout the country.

Our organisation has been runned by industry professionals having vast experiences in technology, telecommunications and trainings. Currently we’re going through phase-I of technological training and we’re offering various courses under the programme graduate, post-graduate, executive education for senior and middle management, research and consulting and many other courses for corporate training.

State of the art computing

ACLM has one the finest computing environments among all current running institutes in the neighbouring area. We’re Operating around ½ the clock, with 40 desktops, high quality server, wi-fi internet enabled classes, high quality laser and colour inkjet printers.

Live Training Courses

ACLM is also conducting live training courses on advanced courses like Ethical Hacking, SEO, Software Testing, J2EE, .net and C++ courses from different sectors throughout the country. The basic purpose of such type of training is to clear concept on specific topic remotely which helps students directly to get in touch with senior trainers and to clear their doubts. For conducting such Live Training we’re using a 2 way (full duplex) video conferencing systems.

Information Centre

Setting up of information centre was a big task for us. As a general information centre, we’ve not only included the computer courses, we’ve also included a lot of other professional courses. Our information desk is open for information round the clock and experts from different background is always available for counselling.