Webfire Themes Weebly Templates
    Mapple Jaipur
    info@mapple.ac.in
        mapple.edusoft@gmail.com
    Call us :  8233-25-2525
                          8233-54-5555
    • Home
    • Profile
      • Meet the Team
      • Partner with us
      • Webmail
      • Career >
        • Code of Conduct
    • Services
    • Training
      • Online Registration
      • IT Training >
        • Oracle Training >
          • Oracle 11g Database (DBA) >
            • 11g: Introduction to SQL
            • 11g: Administration Workshop 1
            • 11g: Administration Workshop 2
          • Oracle 10g Database (DBA) >
            • 10g: Introduction to SQL
            • 10g: Administration Workshop 1
            • 10g: Administration Workshop 2
          • Oracle 9i Database (DBA) >
            • 9i: Introduction to SQL
            • 9i: Administration Fundamentals 1
            • 9i: Administration Fundamentals 2
            • 9i: Performance Tuning
        • Big Data >
          • Introduction to Big Data
          • Big Data Essentials
        • Java Training >
          • Java Fundamentals SE6 (OCJA)
          • Java Fundamentals SE7 (OCJA)
          • Java Fundamentals SE8 (OCJA)
          • Java SE6 (OCJP)
          • Java SE7 (OCJP)
          • Java SE8 (OCJP)
          • Java SE 7 New Features
          • Java SE 8 New Features
          • Java EE6 Developing App (OCWCD)
          • Java EE6 Servlets & JSP (OCWCD)
          • Java EE6 EJB TECHNOLOGY (OCBCD)
        • PHP With MySQL >
          • PHP Training & MySQL
          • MySQL for Developers
        • Ethical Hacking
        • SEO Training
      • SSC Training >
        • SSC SYLLABUS TIER-I >
          • QUANTITATIVE APTITUDE
          • GENERAL MENTAL ABILITY
          • ENGLISH
          • COMPUTER AWARENESS
          • GENERAL KNOWLEDGE
    • Certification
    • Online Test
      • Admin
    • Alliances
    • Placement
    • Contact Us
      • Bank Details

    Oracle Database 11g: Administration Workshop 2

    What you will learn:
    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.
    Why Oracle 11 g training from Mapple Edusoft :
    • Official Course-ware from Oracle University.
    • Authorized Structured Oracle Training in Jaipur.
    • Highly Qualified Java Industry Experts as Trainer.
    • Hands on experience on Oracle Software.
    • Course Completion Certificate From Oracle University.
    • Discount Vouchers for International Exams.
    • 10 Full-length Online Mock Tests (Real-life Oracle® Exam) per Module.

    Prerequisites :
    • Oracle Database 11g: SQL Fundamentals I
      Oracle Database 11g: Administration Workshop I 

    Course Topics :
    Core Concepts and Tools of the Oracle Database
    • The Oracle Database Architecture: Overview
    • ASM Storage Concepts
    • Connecting to the Database and the ASM Instance
    • DBA Tools Overview
    Configuring for Recoverability
    • Purpose of Backup and Recovery (B&R), Typical Tasks and Terminology
    • Using the Recovery Manager (RMAN)
    • Configuring your Database for B&R Operations
    • Configuring Archivelog Mode
    • Configuring Backup Retention
    • Configuring and Using a Flash Recovery Area (FRA)
    Using the RMAN Recovery Catalog
    • Tracking and Storing Backup Information
    • Setting up a Recovery Catalog
    • Recording Backups
    • Using RMAN Stored Scripts
    • Managing the Recovery Catalog (Backup, Export, Import, Upgrade, Drop and Virtual Private Catalog)
    Configuring Backup Settings
    • Configuring and Managing Persistent Settings for RMAN
    • Configuring Autobackup of Control File
    • Backup optimization
    • Advanced Configuration Settings: Compressing Backups
    • Configuring Backup and Restore for Very Large Files (Multisection)
    Creating Backups with RMAN
    • RMAN backup types
    • Creating and Using the following:
    • - Backup Sets and Image Copies
    • - Whole Database Backup
    • - Fast Incremental Backup
    • - Configure Backup Destinations
    • - Duplexed Backup Sets
    • - Archival Backups
    Restore and Recovery Task
    • Restoring and Recovering
    • Causes of File Loss
    • Automatic Tempfile Recovery
    • Recovering from the Loss of a Redo Log Group
    • Recovering from a Lost Index Tablespace
    • Re-creating a Password Authentication File
    • Complete and Incomplete Recovery
    • Other Recovery Operations
    Using RMAN to Perform Recovery
    • Complete Recovery after Loss of a Critical or Noncritical Data File
    • Recovering Image Copies and Switching Files
    • Restore and Recovery of a Database in NOARCHIVELOG Mode
    • Incomplete Recovery
    • Performing Recovery with a Backup Control File
    • Restoring from Autobackup: Server Parameter File and Control File
    • Restoring and Recovering the Database on a New Host
    Monitoring and Tuning RMAN
    • Monitoring RMAN Jobs
    • Balance Between Speed of Backup Versus Speed of Recovery
    • RMAN Multiplexing
    • Synchronous and Asynchronous I/O
    • Explaining Performance Impact of MAXPIECESIZE, FILESPERSET, MAXOPENFILES and BACKUP DURATION
    Diagnosing the Database
    • Data Recovery Advisor (DRA)
    • Block Corruption
    • Automatic Diagnostic Repository (ADR)
    • Health Monitor
    • The ADR Command-Line Tool, ADRCI
    Using Flashback Technology I
    • Flashback Technology: Overview and Setup
    • Using Flashback Technology to Query Data
    • Flashback Table
    • Flashback Transaction Query
    • Performing Flashback Transaction Backout
    Using Flashback Technology II
    • Oracle Total Recall
    • Flashback Drop and the Recycle Bin
    Performing Flashback Database
    • Configuring Flashback Database
    • Performing Flashback Database Operations
    • Monitoring Flashback Database
    Managing Memory
    • Oracle Memory Structures
    • Oracle Database Memory Parameters
    • Using Automatic Memory Management
    • Automatic Shared Memory Management
    • Using Memory Advisors
    • Using Data Dictionary Views
    Managing Database Performance
    • Tuning Activities
    • Using Statistic Preferences
    • Optimizer Statistics Collection
    • Monitor the Performance of Sessions and Services
    • Automatic Workload Repository (AWR)
    • Describing the Benefits of Database Replay
    Managing Performance by SQL Tuning
    • SQL Tuning and SQL Advisors
    • Using SQL Tuning Advisor
    • SQL Access Advisor
    • SQL Performance Analyzer Overview
    Managing Resources
    • Database Resource Manager: Overview and Concepts
    • Accessing and Creating Resource Plans
    • Creating Consumer Group
    • Specifying Resource Plan Directives, including:
    • - Limiting CPU Utilization at the Database Level
    • - Instance Caging
    • Activating a Resource Plan
    • Monitoring the Resource Manager
    Automating Tasks with the Scheduler
    • Simplifying Management Tasks
    • Creating a Job, Program, and Schedule
    • Using Time-Based, Event-Based, and Complex Schedules
    • Describing the Use of Windows, Window Groups, Job Classes, and Consumer Groups
    • Multi-Destination Jobs
    Managing Space in Blocks
    • Free Space Management
    • Monitoring Space
    • Compressing Data
    Managing Space in Segments
    • Segment Creation on Demand
    • Additional Automatic Space-Saving Functionalit
    • Shrinking Segments
    • Segment Advisor
    • Managing Resumable Space Allocation
    Managing Space for the Database
    • Using 4 KB-Sector Disks
    • Transporting Tablespaces
    • Transporting Databases
    Duplicating a Database
    • Purpose and Methods of Cloning a Database
    • Using RMAN to Create a Duplicate Database
    • Cloning a Database from a Backup
    • Duplicate a Database Based on a Running Instance
    • Targetless Duplicating a Database

      
    Certificate From Oracle University :
    Oracle Training in Jaipur - DBA, Developer - OCA -OCP
    Oracle Training in Jaipur - DBA, Developer - OCA -OCP
    Authorized Oracle 11g Training in Jaipur @ Mapple Edusoft

    OUR SERVICES : 

    IT Training & Skill Development
    International Certification
    Earn & Learn
    Software & Website Development
    Business Support Services
    Infrastructure leasing
    Franchise

    Company :

    About Us
    Contact Us
    Terms and Conditions
    Privacy Policy
    Disclaimer of Warranty

    Alliances :

    Oracle - Java - WDP
    EC - Council
    MeritTrac Services Pvt. Ltd
    Aspiring Minds
    Hughes Communication India Ltd.

    Contact US

    • Mapple Edusoft Private Limited
      78, 3rd Avenue, Goms Defence Colony,
      Vaishali Nagar, Jaipur - 302021
      Rajasthan
    • +91-8233-54-5555
      +91-8233-25-5555
    • info@mappleedusoft.com
    • www.mappleedusoft.com

    Back to top