Real Time, DBA Project Highly Practical Oriented this DataGuard Training makes you install & practice at your own system
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
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 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)
Who this course is for:
Designed for Junior Oracle DBAs & Oracle Developer(s) or those who want to prepare to complete an Oracle certification.
Those who would like to be an expert in Oracle Data Guard with ASM on-premises and in Amazon Cloud.
DOWNLOAD LINK