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

Oracle Dataguard 11gR2 With ASM in On-Premises & AWS Cloud paid course free for all. Data Guard for Beginners to Experts and for Real-Time DBA Project Practical Oriented Training

  • 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

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

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

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

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 Network 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

The 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)

Who this course is for:

  • Designed for Junior Oracle DBAs & Oracle Developer(s) or those who want to prepare to complete an Oracle certification.

Source: https://www.udemy.com/course/oracle-dataguard-11gr2-with-asm-in-on-premises-aws-cloud/

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

Leave a Comment

Please disable your adblocker or whitelist this site! And Reload Page