Download app Download App
tag
Favourite 0
Your cart is empty
Keep shopping  right

    Oracle Database 12c Advanced Administration-OCP Training Course

    This Oracle Database 12c: Backup and Recovery Workshop will teach each you how to evaluate your own recovery requirements. You will develop appropriate strategies for bac...

    ₹ 22000

    ₹ 25000

    12% off

    SHARE
    Baroda Institute of Technology
    ₹22000  ₹ 25000  

    12% off

     
    Buy Now
    This includes following
    •  105 Hours
    •  Completion certificate : Yes
    •  Language : Hinglish 
    This Oracle Database 12c: Backup and Recovery Workshop will teach each you how to evaluate your own recovery requirements. You will develop appropriate strategies for backup, restore and recovery procedures from provided scenarios. In this course, you will be introduced to Oracle Database Cloud Service. Oracle Database 12c Advanced Administration-OCP online training course will teach you about Recovery Manager (RMAN) command line and graphical interfaces for various backup, failure, restore and recovery scenarios. The Oracle Certified Associate (OCA) for Oracle Database 12c assesses the most important skills DBAs need for daily operational management and maintenance. Building upon the competencies in the Oracle Database 12c OCA certification, the Oracle Certified Professional (OCP) for Oracle Database 12c includes the advanced knowledge and skills required of top-performing database administrators, including development and deployment of backup, recovery and Cloud computing strategies.

        Live Class Practical Oriented Training

        Timely Doubt Resolution

        Dedicated Student Success Mentor

        Certification & Job Assistance

        Free Access to Workshop & Webinar

        No Cost EMI Option

        Manage Oracle Database Storage Structures. Gain an Understanding of the Oracle Database Cloud Service

        Create a Container Database. Implement Database Auditing. Configure Oracle Net Services

        Configure Your Database for Backup and Recovery Operations. Describe Oracle Database Architecture.

        Install Oracle Database 12c Software. Upgrade a Database to Oracle Database 12c. Create an Oracle Database

        Allocated Among Sessions and Tasks. Schedule Jobs to Run Inside or Outside of the Database.

        Configure the Database Instance Such That Resources Are Appropriate. Manage the Oracle Database Instance

       Lecture-1 Explain Oracle backup and recovery solutions

       Lecture-2 Performing Basic Backup and Recovery

       Lecture-3 Configuring for Recoverability

       Lecture-4 Configure the Fast Recovery Area

       Lecture-5 Configure control files and redo log files for recoverability

       Lecture-6 Create and use an RMAN recovery catalog

       Lecture-7 Protect the RMAN recovery catalog

       Lecture-8 Use various RMAN backup types and strategies

       Lecture-9 Perform full and incremental backups

       Lecture-10 Manage backups

       Lecture-11 Use techniques to improve backups

       Lecture-12 Perform backup of non-database files

       Lecture-13 Create RMAN-encrypted backups

       Lecture-14 Describe the Automatic Diagnostic Workflow

       Lecture-15 Performing Restore and Recovery Operations

       Lecture-16 Recovering Files Using RMAN

       Lecture-17 Using Oracle Secure Backup

       Lecture-18 Using Flashback Database

       Lecture-19 Transporting Data

       Lecture-20 Duplicating a Database

       Lecture-21 Monitoring and Tuning of RMAN Operations

       Lecture-22 Oracle Database Cloud Service 

    •   Lecture-1 Explain Oracle backup and recovery solutions
Live Lecture 
·      Describe types of database failures

·      Describe the tools available for backup and recovery tasks

·      Describe RMAN and maximum availability architecture

·      Use the SYSBACK privilege

·      Use RMAN stand-alone and job commands                    

·      Practical Exercise
    •   Lecture-2 Performing Basic Backup and Recovery
Live Lecture 
·      Back up and recover a NOARCHIVELOG database

·      Perform backup and recovery in NOARCHIVELOG mode

·      Use SQL in RMAN                      

·      Practical Exercise
    •   Lecture-3 Configuring for Recoverability
Live Lecture 
·      Configure and manage RMAN settings

·      Configure persistent settings for RMAN

·      View persistent settings

·      Specify a retention policY            

·      Practical Exercise
    •   Lecture-4 Configure the Fast Recovery Area
Live Lecture 
·      Explain the Fast Recovery Area

·      Configure the Fast Recovery Area           

·      Practical Exercise
    •   Lecture-5 Configure control files and redo log files for recoverability
Live Lecture 
·      Multiplex control files

·      Multiplex redo log files                 

·      Practical Exercise
    •   Lecture-6 Create and use an RMAN recovery catalog
Live Lecture 
·      Configure a recovery catalog

·      Register target databases in a recovery catalog

·      Catalog additional backup files

·      Resynchronize a recovery catalog

·      Use and maintain RMAN stored scripts

·      Upgrade and drop a recovery catalog                   

·      Practical Exercise
    •   Lecture-7 Protect the RMAN recovery catalog
Live Lecture 
·      Back up the recovery catalog

·      Re-create an unrecoverable recovery catalog

·      Export and import the recovery catalog

·      Implementing Backup Strategies              

·      Practical Exercise
    •   Lecture-8 Use various RMAN backup types and strategies
Live Lecture 
·      Enable ARCHIVELOG mode

·      Create tape and disk based backups

·      Create whole database backups

·      Create consistent and inconsistent backups

·      Create backup sets and image copies

·      Create backups of read-only tablespaces

·      Employ best practices for data warehouse backups

·      Performing Backups                      

·      Practical Exercise
    •   Lecture-9 Perform full and incremental backups
Live Lecture 
·      Create full and incremental backups

·      Use the Oracle-suggested backup strategy                       

·      Practical Exercise
    •   Lecture-10 Manage backups
Live Lecture 
·      Configure and monitor block change tracking

·      Report on backups using LIST, REPORT commands

·      Manage backups using CROSSCHECK, DELETE commands

·      Configuring RMAN Backup Options and Creating Backup of Non-Database Files       

·      Practical Exercise
    •   Lecture-11 Use techniques to improve backups
Live Lecture 
·      Create compressed backups

·      Create multi-section backups of very large files

·      Create proxy copies

·      Create duplexed backup sets

·      Create backups of backup sets

·      Create archival backups                

·      Practical Exercise
    •   Lecture-12 Perform backup of non-database files
Live Lecture 
·      Back up a control file to trace

·      Back up archived redo log files

·      Back up ASM diskgroup metadata

·      Using RMAN-Encrypted Backups                       

·      Practical Exercise
    •   Lecture-13 Create RMAN-encrypted backups
Live Lecture 
·      Use transparent-mode encryption

·      Use password-mode encryption

·      Use dual-mode encryption

·      Restore encrypted backups

·      Diagnosing Failures                       

·      Practical Exercise
    •   Lecture-14 Describe the Automatic Diagnostic Workflow
Live Lecture 
·      Use the Automatic Diagnostic Repository

·      Use ADRCI

·      Find and interpret message output and error stacks

·      Use the Data Recovery Advisor

·      Handle block corruption

·      Detect block corruption using RMAN

·      Perform block recovery using RMAN

·      Practical Exercise
    •   Lecture-15 Performing Restore and Recovery Operations
Live Lecture 
·      Describe and tune instance recovery

·      Perform complete and incomplete recovery

·      Use RMAN RESTORE and RECOVER commands

·      Restore ASM disk groups

·      Recover from media failures

·      Perform complete and incomplete or “point-in-time” recoveries using RMAN               

·      Practical Exercise
    •   Lecture-16 Recovering Files Using RMAN
Live Lecture 
·      Perform recovery for spfile, control file, redo log files

·      Perform table recovery from backups

·      Perform recovery of index and read-only tablespaces, temp file

·      Restore a database to a new host              

·      Practical Exercise
    •   Lecture-17 Using Oracle Secure Backup
Live Lecture 
·      Configure and use Oracle Secure Backup

·      Using Flashback Technologies

·      Describe the Flashback technologies

·      Configure a database to use Flashback technologies

·      Guarantee undo retention

·      Use Flashback to query data

·      Use Flashback Query

·      Use Flashback Version Query

·      Use Flashback Transaction Query

·      Flash back a transaction

·      Perform Flashback Table operations

·      Perform Flashback Table

·      Restore tables from the recycle bin

·      Describe and use Flashback Data Archive

·      Use Flashback Data Archive

·      Use DBMS_FLASHBACK_ARCHIVE package                       

·      Practical Exercise
    •   Lecture-18 Using Flashback Database
Live Lecture 
·      Perform Flashback Database

·      Configure Flashback Database

·      Perform Flashback Database                     

·      Practical Exercise
    •   Lecture-19 Transporting Data
Live Lecture 
·      Describe and use transportable tablespaces and databases

·      Transport tablespaces between databases using image copies or backup sets

·      Transport databases using data files or backup sets

·      Transport data across platforms                         

·      Practical Exercise
    •   Lecture-20 Duplicating a Database
Live Lecture 
·      Choose a technique for duplicating a database

·      From an active database, connected to the target and auxiliary instances

·      From backup, connected to the target and auxiliary instances

·      From backup, connected to the auxiliary instance, not connected to the target, but with recovery catalog connection

·      From backup, connected to the auxiliary instance, not connected to the target and the recovery catalog

·      Duplicate a database with RMAN

·      Create a backup-up based duplicate database

·      Duplicate a database based on a running instance            

·      Practical Exercise
    •   Lecture-21 Monitoring and Tuning of RMAN Operations
Live Lecture 
·      Tune RMAN performance

·      Interpret RMAN error stacks

·      Diagnose performance bottlenecks

·      Tune RMAN backup performance

·      Managing Pluggable and Container Databases                 

·      Practical Exercise
    •   Lecture-22 Oracle Database Cloud Service
Live Lecture 
·      Database as a Service Architecture, Features and Tooling

·      Software Editions: Included Database Options and Management Packs

·      Automated Database Provisioning

·      Managing the Compute Node Associated With a Database Deployment

·      Managing Network Access to Database as a Service

·      Enabling Access to a Compute Node Port

·      Scaling a Database Deployment & Patching Database as a Service

·      Using the Oracle Database Cloud Service Console to Manage Patches               

·      Practical Exercise
    Basic understanding of Oracle database.
    Ans: The course offers a variety of online training options, including: • Live Virtual Classroom Training: Participate in real-time interactive sessions with instructors and peers. • 1:1 Doubt Resolution Sessions: Get personalized assistance and clarification on course-related queries. • Recorded Live Lectures*: Access recorded sessions for review or to catch up on missed classes. • Flexible Schedule: Enjoy the flexibility to learn at your own pace and according to your schedule.
    Ans: Live Virtual Classroom Training allows you to attend instructor-led sessions in real-time through an online platform. You can interact with the instructor, ask questions, participate in discussions, and collaborate with fellow learners, simulating the experience of a traditional classroom setting from the comfort of your own space.
    Ans: If you miss a live session, you can access recorded lectures* to review the content covered during the session. This allows you to catch up on any missed material at your own pace and ensures that you don't fall behind in your learning journey.
    Ans: The course offers a flexible schedule, allowing you to learn at times that suit you best. Whether you have other commitments or prefer to study during specific hours, the course structure accommodates your needs, enabling you to balance your learning with other responsibilities effectively. *Note: Availability of recorded live lectures may vary depending on the course and training provider.
    Education Provider
    profile
    Baroda Institute Of Technology - Training Program

    BIT (Baroda Institute Of Technology) Is A Training And Development Organization Catering To The Learning Requirements Of Candidates Globally Through A Wide Array Of Services. Established In 2002. BIT Strength In The Area Is Signified By The Number Of Its Authorized Training Partnerships. The Organization Conducts Trainings For Microsoft, Cisco , Red Hat , Oracle , EC-Council , Etc. Domains / Specialties Corporate Institutional Boot Camp / Classroom Online – BIT Virtual Academy Skill Development Government BIT’s Vision To Directly Associate Learning With Career Establishment Has Given The Right Set Of Skilled Professionals To The Dynamic Industry. Increased Focus On Readying Candidates For On-the-job Environments Makes It A Highly Preferred Learning Provider. BIT Is Valued For Offering Training That Is At Par With The Latest Market Trends And Also Match The Potential Of Candidates. With More Than A Decade Of Experience In Education And Development, The Organization Continues To Explore Wider Avenues In Order To Provide Learners A Platform Where They Find A Solution For All Their Up- Skilling Needs!

    Graduation
    2002
    Data Sciences

    More Courses by : Baroda Institute of Technology


    Baroda Institute of Technology
    ₹22000  ₹ 25000  

    12% off

     
    Buy Now
    This includes following
    •  105 Hours
    •  Completion certificate : Yes
    •  Language : Hinglish

    More Courses by : Baroda Institute of Technology


    Copyright © 2024 Digital Class World. All Rights Reserved.