• Home
  • +91 8447121833 / 0120 4326873
  • Thanks for Contacting us Our representative will be in touch with you shortly

    This website uses cookies

    Oracle Database 12c: Data Guard Administration Training

    This course will teach students how to develop the best disaster recovery solution using the new Oracle Data Guard 12c features and architecture. Students will get a chance explore topics like Oracle Active Data Guard, Far Sync, rolling upgrades and snapshot standby databases. Furthermore, enrolling in this course will help you learn how to manage and troubleshoot a Data Guard configuration.Enroll & Get Certified now!

    • ✔ Course Duration : 40 hrs
    • ✔ Training Options : Live Online / Self-Paced / Classroom
    • ✔ Certification Pass : Guaranteed

    Oracle Database 12c: Data Guard Administration Training

    This course will teach students how to develop the best disaster recovery solution using the new Oracle Data Guard 12c features and architecture. Students will get a chance explore topics like Oracle Active Data Guard, Far Sync, rolling upgrades and snapshot standby databases. Furthermore, enrolling in this course will help you learn how to manage and troubleshoot a Data Guard configuration.

    What you will Learn

    • Create a Data Guard broker configuration
    • Create a physical standby database
    • Verify a Data Guard configuration
    • Edit database properties related to Data Guard
    • Test a Data Guard configuration
    • Describe the Architecture of Oracle Data Guard
    • Explain the applicability between physical and logical standby and snapshot databases
    • Explain the benefits of implementing Oracle Data Guard
    • Explain Data Guard use with the Oracle Multi-tennant databases
    • Configure client connectivity in a Data Guard configuration
    • Implement failover procedures to automatically redirect clients to a new primary database
    • Use Application Continuity in a Data Guard Environment

    PREREQUISITES

    • Good knowledge of Oracle Database
    • Oracle Database 12c: Administration Workshop

    CURRICULUM

    Learning Objectives:
    • What Is Oracle Data Guard?
    • Types of Standby Databases
    • Types of Data Guard Services
    • Role Transitions: Switchover and Failover
    • Oracle Data Guard Broker Framework
    • Choosing an Interface for Administering a Data Guard Configuration
    • Oracle Data Guard: Architecture(Overview)
    • Primary Database Processes
    Learning Objectives:
    • Networking Overview
    • Listener.ora Configuration
    • Statics vs. Dynamic Registration
    • Static Entries for Database Duplication and SQL Maintenence
    • Static Entries for Broker Operations
    • Oracle Network Configuration Tuning
    • Tnsnames.ora Configuration
    Learning Objectives:
    • Steps to Create a Physical Standby Database
    • Preparing the Primary Database
    • FORCE LOGGING Mode
    • Configuring Standby Redo Logs
    • Creating Standby Redo Logs
    • Using SQL to Create Standby Redo Logs
    • Viewing Standby Redo Log Information
    • Setting Initialization Parameters on the Primary Database to Control Redo Transport
    Learning Objectives:
    • Oracle Data Guard Broker: Features
    • Data Guard Broker: Components
    • Data Guard Broker: Configurations
    • Data Guard Broker: Management Model
    • Data Guard Broker: Architecture
    • Data Guard Monitor: DMON Process
    • Benefits of Using the Data Guard Broker
    • Comparing Configuration Management With and Without the Data Guard Broker
    Learning Objectives:
    • Data Guard Broker: Requirements
    • Data Guard Broker and the SPFILE
    • Data Guard Monitor: Configuration File
    • Data Guard Broker: Log Files
    • Creating a Broker Configuration
    • Defining the Broker Configuration and the Primary Database Profile
    • Adding a Standby Database to the Configuration
    • Enabling the Configuration
    Learning Objectives:
    • Using Oracle Enterprise Manager to Create a Broker Configuration
    • Creating a Configuration
    • Creating a New Configuration
    • Adding a Standby Database to an Existing Configuration
    • Using the Add Standby Database Wizard
    • Standby Database Creation: Processing
    • Standby Database Creation: Progress
    • Verifying a Data Guard Configuration
    Learning Objectives:
    • Benefits of Implementing a Logical Standby Database
    • Logical Standby Database: SQL Apply Architecture
    • SQL Apply Process: Architecture
    • Preparing to Create a Logical Standby Database
    • Unsupported Objects
    • Unsupported Data Types
    • Checking for Unsupported Tables
    • Checking for Tables with Unsupported Data Types
    Learning Objectives:
    • Snapshot Standby Databases: Overview
    • Snapshot Standby Database: Architecture
    • Converting a Physical Standby Database to a Snapshot Standby Database
    • Activating a Snapshot Standby Database: Issues and Cautions
    • Snapshot Standby Database: Target Restrictions
    • Viewing Snapshot Standby Database Information
    • Using DGMGRL to View Snapshot Standby Database Information
    • Converting a Snapshot Standby Database to a Physical Standby Database
    Learning Objectives:
    • Oracle Active Data Guard
    • Using Real-Time Query
    • Checking the Standby’s Open Mode
    • Understanding Lag in an Active Data Guard Configuration
    • Monitoring Apply Lag: V$DATAGUARD_STATS
    • Monitoring Apply Lag: V$STANDBY_EVENT_HISTOGRAM
    • Setting a Predetermined Service Level for Currency of Standby Queries
    • Configuring Zero Lag Between the Primary and Standby Databases
    Learning Objectives:
    • Data Protection Modes and Redo Transport Modes
    • Maximum Protection Mode
    • Maximum Availability Mode
    • Maximum Performance Mode
    • Comparing Data Protection Modes
    • Setting the Data Protection Mode by Using DGMGRL
    • Setting the Data Protection Mode
    Learning Objectives:
    • Role Management Services
    • Role Transitions: Switchover and Failover
    • Switchover
    • Preparing for a Switchover
    • Performing a Switchover by Using DGMGRL
    • Performing a Switchover by Using Enterprise Manager
    • Considerations When Performing a Switchover to a Logical Standby Database
    • Situations That Prevent a Switchover
    Learning Objectives:
    • Using Flashback Database in a Data Guard Configuration
    • Overview of Flashback Database
    • Configuring Flashback Database
    • Configuring Flashback Database by Using Enterprise Manager
    • Using Flashback Database Instead of Apply Delay
    • Using Flashback Database and Real-Time Apply
    • Using Flashback Database After RESETLOGS
    • Flashback Through Standby Database Role Transitions
    Learning Objectives:
    • Fast-Start Failover: Overview
    • When Does Fast-Start Failover Occur?
    • Installing the Observer Software
    • Fast-Start Failover Prerequisites
    • Configuring Fast-Start Failover
    • Setting the Lag-Time Limit
    • Configuring the Primary Database to Shut Down Automatically
    • Automatic Reinstatement After Fast-Start Failover
    Learning Objectives:
    • Understanding Client Connectivity in a Data Guard Configuration
    • Understanding Client Connectivity: Using Local Naming
    • Preventing Clients from Connecting to the Wrong Database
    • Managing Services
    • Understanding Client Connectivity: Using a Database Service
    • Creating Services for the Data Guard Configuration Databases
    • Configuring Role-Based Services
    • Adding Standby Databases to Oracle Restart Configuration
    Learning Objectives:
    • Using RMAN to Back Up and Restore Files in a Data Guard Configuration
    • Offloading Backups to a Physical Standby
    • Restrictions and Usage Notes
    • Backup and Recovery of a Logical Standby Database
    • Using the RMAN Recovery Catalog in a Data Guard Configuration
    • Creating the Recovery Catalog
    • Registering a Database in the Recovery Catalog
    • Setting Persistent Configuration Settings
    Learning Objectives:
    • Upgrading an Oracle Data Guard Broker Configuration
    • Upgrading Oracle Database in a Data Guard Configuration with a Physical Standby Database
    • Upgrading Oracle Database in a Data Guard Configuration with a Logical Standby Database
    • Using DBMS_ROLLING to Upgrade the Oracle Database
    • Requirements for Using DBMS_ROLLING to Perform a Rolling Upgrade
    • Leading Group Databases and Leading Group Master
    • Trailing Group Databases and Trailing Group Master
    • Performing a Rolling Upgrade by Using DBMS_ROLLING
    Learning Objectives:
    • Monitoring the Data Guard Configuration by Using Enterprise Manager Cloud Control
    • Viewing the Data Guard Configuration Status
    • Monitoring Data Guard Performance
    • Viewing Log File Details
    • Enterprise Manager Metrics and Alerts
    • Data Guard Metrics
    • Managing Data Guard Metrics
    • Viewing Metric Value History
    Learning Objectives:
    • Monitoring Configuration Performance by Using Enterprise Manager Cloud Control
    • Optimizing Redo Transport Services
    • Setting the ReopenSecs Database Property
    • Setting the NetTimeout Database Property
    • Optimizing Redo Transmission by Setting MaxConnections
    • Setting the MaxConnections Database Property
    • Compressing Redo Data by Setting the RedoCompression Property
    • Delaying the Application of Redo
    Learning Objectives:
    • Introducing Exadata Cloud Service
    • Service Configuration, Connection, Architecture & Availability
    • Data Security & Management Responsibilities
    • Storage Configuration & Management Details
    • Simple Web-Based Provisioning & Management
    • REST APIs
    • Backup and Recovery
    • Migrating to Exadata Cloud Service

    FAQs

    You can enroll for this classroom training online. Payments can be made using any of the following options and receipt of the same will be issued to the candidate automatically via email.
    1. Online ,By deposit the mildain bank account
    2. Pay by cash team training center location

    Highly qualified and certified instructors with 20+ years of experience deliver more than 200+ classroom training.

    Contact us using the form on the right of any page on the mildaintrainings website, or select the Live Chat link. Our customer service representatives will be able to give you more details.

    You will never miss a lecture at Mildaintrainigs! You can choose either of the two options: View the recorded session of the class available in your LMS. You can attend the missed session, in any other live batch.

    We have a limited number of participants in a live session to maintain the Quality Standards. So, unfortunately, participation in a live class without enrollment is not possible. However, you can go through the sample class recording and it would give you a clear insight about how are the classes conducted, quality of instructors and the level of interaction in a class.

    Yes, the access to the course material will be available for lifetime once you have enrolled into the course.

    Just give us a CALL at +91 8447121833 OR email at [email protected]

    CERTIFICATE OF ACHIEVEMENT

    Training features

  • Instructor-led Sessions
    Online Live Instructor-Led Classes.
    Classroom Classes at our/your premises.
    Corporate Training
  • Real-life Case Studies
    Live project based on any of the selected use cases, involving implementation of the various Course concepts.
  • Assignments
    Each class will be followed by practical assignments.
  • Lifetime Access
    You get lifetime access to presentations, quizzes, installation guide & class recordings.
  • 24 x 7 Expert Support
    We have 24x7 online support team to resolve all your technical queries, through ticket based tracking system, for the lifetime.
  • Certification
    Sucessfully complete your final course project and Mildaintrainings will give you Course completion certificate.
  • More Courses

    Modes of Training

  • Most
    Preffered

    Online Classroom


    Instructor Led Trainings
    Live Online Classroom

    View Schedules
  • One to One


    Instructor Led Training
    Live Online Classroom

    Request a Session
  • Team/Corporate


    Train your Team
    and Up-skill them

    Request a Quote
  • Demo Videos

    Our Corporate Clients

    Inquiry: Call | Whats App: +91-8447121833 | Email: [email protected]

    ENROLL NOW


    Warning: startblock('pagecontent') does not match endblock('pageBody') in /home/mildaintrainings/public_html/oracle-training-courses/oracle-database-12c-data-guard-administration.php on line 220