Oracle Dataguard 11gR2 With ASM in On-Premises & AWS Cloud

Real Time, DBA Project Highly Practical Oriented this DataGuard Training makes you install & practice at your own system

SECTION – I

What you’ll learn

  • S E C T I O N – I BEFORE PRACTICAL Topics – 6 Before Practice Actionable Items with an Effective Pitch.
  • S E C T I O N – II IN-PRACTICAL Topics – 20 Extraordinary Technical Voice Out Videos – Step by Step & Nook & Corner Coverage.
  • S E C T I O N – III POST PRACTICAL Topics – 10 Administrating, Managing & Monitoring Items with an Effective Pitch.
  • PART – IV DataGuard in AMAZON CLOUD Topics – 2 Lab Practice with an Effective Pitch.
  • Downloadable – The Require RPM Packages for OS EL6.5 and for Oracle 11gR2 in Section-2 Lecture 12.
  • Full Lifetime Access.
  • RealTime & DBA Project Highly Practical Oriented this DataGuard Training makes you install & practice at your own system.
  • Access on Mobile & TV as well.

Course Content

  • BEFORE PRACTICAL Topics – Presentation Method –> 7 lectures • 15min.
  • IN-PRACTICAL Topics – Step by Step Voice out Video Demo –> 29 lectures • 5hr 56min.
  • POST PRACTICAL Topics – Presentations Method –> 10 lectures • 25min.
  • DataGuard in AMAZON CLOUD Topics –> 2 lectures • 4min.

Oracle Dataguard 11gR2 With ASM in On-Premises & AWS Cloud

Requirements

  • Assume the audience have the basic knowledge of the Oracle Database Administration fundamentals. We do not expect you to be an expert DBA.

SECTION – I

B E F O R E – P R A C T I C A L Topics  – 6 Before Practice Actionable Items with an Effective Pitch


1-Introduction of DataGuard

2-Oracle Database Enterprise Edition Requirement

3-Dataguard Architecture Diagram

4-Standby Database Types

5-Dataguard Protection Modes

6-What is Dataguard Broker



SECTION – II

In-P R A C T I C A L Topics – 20 Extraordinary Technical Voice Out Videos – Step by Step, Nook & Corner coverage


1-Installing Virtual Machine Ver14.0 on Your Local Desktop/Laptop

2-Creating Virtual Machine for PRIMARY Server

3-Creating Virtual Machine for STANDBY1 Server

4-Installing OS OEL Ver6.5 on Both PRIMARY Server and STANDBY1 Server

5-Oracle Configuration in OS on Both PRIMARY Server and STANDBY1 Server –

(The Require RPM Packages are uploaded for you to download)

6-Creating Partitions on RAW Devices (for ASM Disks Usage) on Both PRIMARY Server and

STANDBY1 Server

7-Network Configuration Between PRIMARY Server and STANDBY1 Server

8-ASM Library Configuration on PRIMARY Server

9-Installing Oracle Grid IS Software for Stand Alone on PRIMARY Server

10-asmca (ASM Configuration Assistant) on PRIMARY Server

11-ASM Library Configuration on STANDBY1 Server

12-Installing Oracle Grid IS Software for Stand Alone on STANDBY1 Server

13-asmca (ASM Configuration Assistant) on STANDBY1 Server

14-Installing Oracle Database Software on PRIMARY Server

15- Installing Oracle Database Software on STANDBY1 Server

16-Sample Database Creation (example: devdb) on PRIMARY Server only

17a-Preparing Primary Database on PRIMARY Server and Standby Database on STANDBY1

Server

17b-Preparing Primary Database Newtwork Configuration

17c-Preparing Standby Database Network Configuration

17d-TNS Ping Checking on Both PRIMARY Server and STANDBY1 Server

17e-Duplicating the Primary Database on STANDBY1 Server

17f-Editing oratab File on STANDBY1 Server

17g-Verifying Standby Database Setup

17h-Set Retention and Turn on Flashback Mode on Both Primary Database and Standby Database

17i-Start Redo Apply on Standby Database

17j-Verify Synchronization Between Primary Database & Standby Database

18-Configuring and Enabling Dataguard Broker on Both PRIMARY Server and STANDBY1 Server

19-Dataguard Switch-Over (Role Transition)

20-Dataguard Manual Fail-Over Testing

 

SECTION – III

P O S T – P R A C T I C A L  Topics – 10 Administrating, Managing & Monitoring Items with an Effective Pitch


1-Start Up & Shutdown a Physical Standby Database

2-Monitoring, Configuring “Apply Lag” and Enabling “Zero Lag” in Real-Time Query

Environment in 11g

3-Monitoring Redo Transport Synchronizing Response Time on Primary Database

4-Automatic and Manual Repair of Corrupted Data Blocks

5-Adding Temp Files to Physical Standby Database

6-Primary Database Changes That Require Manual Intervention at Physical Standby Database

7-While Opening Primary Database with OPEN RESETLOGS Option (After Recover)

8-Manual Archived Redo Log Gap Solution

9-Snapshot Standby Database

10-Monitoring Primary Database, Physical Standby Database and Snapshot Standby Database

 

SECTION – IV

Amazon Cloud (AWS RDS) – 2 Lab Practice with an Effective Pitch

11-Amazon Web Service (AWS) RDS – Read Replica (Oracle DataGuard)

12-HIGH AVAILABILITY ON AWS RDS ORACLE (MULTI-AZ)