Watch Intro Video

Video

Course curriculum

  • 1

    Introducing the Course

    • Introducing the Course

      FREE PREVIEW

    • Installing Oracle Database 12c R1 on Linux 6 with ASM

    • Practice: Create an Oracle 12c Database with ASM (part 1)

    • Practice: Create an Oracle 12c Database with ASM (part 2)
  • 2

    Introduction to Oracle Data Guard

  • 3

    Implementing Oracle Data Guard using SQL*Plus

    • Creating a Physical Standby Database-Part 1

    • Creating a Physical Standby Database-Part 2

    • notification

    • Practice 1 Creating a Physical Standby Database

    • Download zip-file ( for the practice 1 )

    • Practice 1 Creating a Physical Standby Database ( Part 1 )

      FREE PREVIEW

    • Practice 1 Creating a Physical Standby Database ( Part 2 )

    • Practice 1 Creating a Physical Standby Database ( Part 3 )

    • Creating Logical Standby Db

    • Practice 2 Creating a Logical Standby Database

    • Practice 2 Create a logical standby database
  • 4

    Oracle Data Guard Broker

    • Using the Data Guard Broker - Part 1

    • Using the Data Guard Broker - Part 2

    • Practice 3 Creating a Data Guard Broker Configuration

    • Download zip-file ( for the practice 3)

    • Practice 3 Creating a Broker Configuration
  • 5

    Managing Physical and Logical Standby Databases

    • Managing Physical Standby Database

    • Practice 4 Changing the Data Guard Protection Mode

    • Practice 4 Changing the Data Guard Protection Mode

    • Managing Logical Standby Database

    • Practice 5 Managing Logical Standby Database

    • Practice 5 Managing Logical Standby Database

    • Monitoring Data Guard Configuration

    • Practice 6 Monitoring Data Guard Configuration

    • Download zip-file ( for the practice 6)

    • Practice 6 Monitoring DG
  • 6

    Perform Role Transitions

    • Perform Role Transition Switchover

    • Perform Role Transition Failover

    • Practice 7 Perform Role Transitions

    • Download zip-file ( for the practice 7)

    • Practice 7 Perform Role Transitions

    • Enabling Fast-Start Failover

    • Practice 8 Enabling Fast-Start Failover

    • Practice 8 Enabling FSFO
  • 7

    Active Data Guard and Snapshot Standby Databases

    • Managing Active Data Guard

    • Managing Snapshot Standby Databases

    • Practice 9 Implement Active Data Guard and Snapshot Standby Database

    • Practice 9 Implement Active Data Guard and Snapshot Standby Database
  • 8

    Managing Client Connectivity

    • Managing Client Connectivity (Part 1)

    • Managing Client Connectivity (Part 2)

    • Practice 10 Implement Client Failover

    • Practice 10 Implement Client Failover
  • 9

    RMAN Considerations in Data Guard Configuration

    • RAMAN Considerations in Data Guard Configuration

    • Practice 11 Using RMAN in Data Guard Environment

    • Practice 11 Using RMAN in Data Guard Environment
  • 10

    Performing Rolling Upgrade using DBMS_ROLLING

    • Performing Rolling Upgrade using DBMS_ROLLING

    • Practice 12 Apply Patch Set using DBMS_ROLLING

    • Practice 12 Apply Patch Set using DBMS_ROLLING (Part 1)

    • Practice 12 Apply Patch Set using DBMS_ROLLING (Part 2)

    • Practice 12 Apply Patch Set using DBMS_ROLLING (Part 3)
  • 11

    Creating Oracle 19c Data Guard Environment

    • Practice 13 - Creating Oracle 19c Data Guard Environment ( part 1 of 3 )

    • Practice 13 - Creating Oracle 19c Data Guard Environment ( part 2 of 3 )

    • Practice 13 - Creating Oracle 19c Data Guard Environment ( part 3 of 3 )
  • 12

    Reinstating a Failed Primary using Flashback Database

    • Practice 14 - Reinstating a Failed Primary Using Flashback Database

    • Using Flashback Database in Oracle Data Guard

    • Practice 15 - Using Flashback Database in Oracle Data Guard - Part 1 of 4

    • Practice 15 - Using Flashback Database in Oracle Data Guard - Part 2 of 4

    • Practice 15 - Using Flashback Database in Oracle Data Guard - Part 3 of 4

    • Practice 15 - Using Flashback Database in Oracle Data Guard - Part 4 of 4
  • 13

    Oracle Data Guard on RAC and More

    • More About Oracle Data Guard

    • Creating an Oracle 12c R2 Physical Standby RAC from a Primary RAC

    • Creating an Oracle 12c R2 Physical Standby RAC Database from a Primary RAC database Demo Files
  • 14

    Appendices

    • Course Presentation and Practice Files