Chapter 1: Introduction to High Availability (HA) and Disaster Recovery (DR) with Cloud functionality
Chapter Goal:
The goal is to provide the end user with an overview of the important Oracle 12c R2 RDBMS Features and High Availability (HA) with Cloud Options.
No of pages
Sub -Topics
1. Introduction to High availability
2. Options for Disaster Recovery
3. Why we require HA & DR
4. Difference between High availability and Disaster recovery
5. Importance of HA & DR
6. Evolution of Cloud technologies
7. Oracle 12c R2 (12.2.0.1.0) with Multi-tenant Features
Chapter 2: High Availability (HA) - GRID Infrastructure (GI) and RAC Options
Chapter Goal:
The goal is to provide the end user with an understanding of the new 12.2 Grid Features. In this way, the end user will be prepared to configure clusters for enhanced High Availability over previous Grid versions.
No of pages:
Sub - Topics
1. Clusterware & RAC introduction
2. Oracle RAC 12 R2 new features
3. Flex ASM and Flex Clusters
4. Oracle Domain Services Clusters
5. Cluster Health Advisor and the GIR
6. Rapid Home Provisioning
7. Oracle RAC Reader nodes
8. Oracle ASM Filter Driver
9. 12.2 ACFS Replication and new Features
10. HACIFS
11. Managing Clusterware with OEM
12. Sparse Files in Diskgroups and ACFS
Chapter 3: Oracle Active Data Guard with Cloud Services
Chapter Goal:
The goal of this chapter is to provide the end user with an understanding of how to manage Oracle Data Guard including with Exadata Cloud. This chapter will serve to enhance the Exadata Cloud experience
No of pages:
Sub - Topics:
1. Oracle Disaster Recovery solution for database
2. Data guard configuration and protection levels
3. Data guard Switchover
4. Data guard Failover
5. Data guard with High availability
Chapter 4: Best Practices in Oracle 12c R2 Data Guard with TIPS and Techniques
Chapter Goal:
This chapter is concerned with expanding on the DataGuard concepts which are touched on in previous chapters. After reading this chapter, end users will have the necessary knowledge to implement a myriad of techniques to better utilize Oracle's DataGuard technology and provide even greater utility to their standby databases.
No of pages:
Sub - Topics:
1. Create a Standby database using DBCA
2. Support for Diagnostic Pack with ADG
3. Support for SQL Tuning Advisor
4. No Logging Changes for Data Guard
5. Multiple Observers
6. Multiple Instance Redo Apply (MIRA) in RAC
7. Subset Standbys
8. Data Guard Database Compare
9. Automatic Password File Synchronization
10. in-Memory Support for ADG
11. Minimize Impact to Primary Databases with Multiple Sync Standby Databases
12. Duplicate Command Enhancements for DG
13. Connection Preservation during Role Changes
14. Data Guard Broker PDB - Migrate PDB
Chapter 5: Oracle Enterprise Manager Cloud control 13c & High Availability (HA) for Cloud Control 13c
Chapter Goal:
The goal of this chapter is to go over the High Availability concepts that pertain to OEM 13cR2. With every release of OEM, OEM is becoming more and more powerful and as a result is relied on more
No of pages:
Sub - Topics:
1. OEM 13c installation and configuration
2. OEM Metrics & Monitoring
3. Backup through OEM
4. HA and MAA best practices for the OEM 13c repository Database
5. OMS High Availability setup
6. OEM Always On Monitoring
7. Snap Cloning with OEM 13c
8. Consolidating Databases with OEM 13c Database Consolidation Workbench
Chapter 6: RAC - TAF - FAN - Benefits - Sessions Failover - HA Capabilities
Chapter Goal: The goal of this chapter is to familiarize end users with the advanced High Availability features available in 12.2 Oracle Clusterware. With this knowledge, end users will be able to make better decisions on how to build out their infrastructure in a resilient and fault tolerant way.
No of pages:
Sub - Topics:
1. Flex ASM with Flex Clusters with FLEX Disk Group Option
2. RAC Reader Nodes Finalization
3. Configure Cluster Domain Services (DSC)
4. Converting from Standard ASM to Flex ASM
5. Installing ASM in Minimal nodes and Benefits
6. Extended RAC Benefits and Pre-Reqs
7. Oracle Extended Cluster Installation – NEW: Extended Redundancy
Chapter 7: Global Data Services (GDS) Configurations for HA
Chapter Goal:
This Chapter will provide the end user with the necessary information to fully understand Global Data Services (GDS) with mission critical applications.
No of pages:
Sub - Topics:
1. Creation and Configuration of Global Data Services (GDS)
2. Administration of Global Data Services (GDS)
3. Client Connection Failover in Global Data Services (GDS)
4. Adding Role Based Services in Global Data Services (GDS)
5. Debugging for Global Data Services (GDS)
6. TAF Configurations in Global Data Services (GDS)
7. Global Data Services (GDS) Configurations for Data Guard and Oracle GoldenGate
Chapter 8: Oracle Sharding Architecture
Chapter Goal:
Oracle Sharding is a scalability and availability feature for custom-designed OLTP applications that enables distribution and replication of data across a pool of Oracle databases
That do not share any resources.
1. Oracle Database Sharing in 12.2
2. Sharding Introduction
3. Necessity of Sharding
4. Sharding deployment
5. Sharding Methods
6. System Managed Sharding
7. Composite Sharding
8. User-Defined Sharding
9. EM 13cR2 Support Sharding
10. Golden Gate with Sharding
Chapter 9: High availability in ODA & Exadata
Chapter Goal:
The goal is to provide the end user with a brief but important overview of ODA capabilities so that basic functionality can be used.
1. Introduction to ODA
2. OAKCLI - Database creation
3. OAKCLI - Snapshot database creation
4. OAKCLI - Database deletion
5. OAKCLI - Database upgrade
6. Introduction HA in ODA
7. Physical standby creation
8. RAC Database creation
9. OEM access for ODA
10. ODA Patching
Chapter 10: Troubleshooting and Health-Check in High Availability
Chapter Goal: The goal of this chapter is to introduce the various health check utilities, both new in 12.2 and from previous versions which can greatly ease management and troubleshooting efforts in HA and DR.
1. Troubleshooting Method