Oracle High Availability, Disaster Recovery, and Cloud Services , 1st ed.
Explore RAC, Data Guard, and Cloud Technology

Authors:

Language: English

79.11 €

In Print (Delivery period: 15 days).

Add to cartAdd to cart
Publication date:
679 p. · 17.8x25.4 cm · Paperback
Work with Oracle database?s high-availability and disaster-management technologies. This book covers all the Oracle high-availability technologies in one place and also discusses how you configure them in engineered systems and cloud services.

You will see that when you say your database is healthy, it is not limited to whether the database is performing well on day-to-day operations; rather it should also be robust and free from disasters. As a result, your database will be capable of handling unforeseen incidents and recovering from disaster with very minimal or zero downtime. Oracle High Availability, Disaster Recovery, and Cloud Services explores all the high-availability features of Oracle database, how to configure them, and best practices.

After you have read this book you will have mastered database high-availability concepts such as RAC, Data Guard, OEM 13c, and engineered systems (Oracle Exadata x6/x7 and Oracle Database Appliance). 


What You Will Learn

  • Master the best practices and features of Exadata and ODA
  • Implement and monitor high availability with OEM 13c
  • Clone databases using various methods in Oracle 12c R2
  • Work with the Oracle sharding features of Oracle 12c R2

Who This Book Is For
Oracle database administrators

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 Methods
2. Health-Check Methods
3. Cluster Verification Utility (CVU)
4. ORAChk/EXAChk
5. Cluster Health Monitor (CHM)
6. Cluster Health Advisor (CHA)
7. Trace File Analyzer (TFA)
8. Hang Manager (HM)
9. Memory Guard (MG)
10. Quality Of Service Management (QSM)

Chapter 10: Introduction to Oracle Cloud with Various Options

Chapter Goal: 
The goal is to provide the end user with a brief Oracle Cloud options based on type of application.

1. Oracle Public cloud
2. What is cloud? Private, Public, Hybrid, Community.
3. HA setup creation in Public cloud
4. Disaster recovery setup creation in Cloud
5. Migrate databases to Cloud

Chapter 11: Exadata Cloud Service-Introduction

Chapter Goal:
The goal is to provide end user an understanding of cloud services available in terms of database platforms and more specifically on Exadata Cloud service which is a platform of service offering from Oracle and known as a great platform for mission critical database workload, consolidation platform and widely used for customer for modernizing the IT estate.

No of pages:

Sub - Topics: 

1. What is cloud? Private, Public, Hybrid, Community.
2. What is Exadata Cloud Service?
3. Provisioning XD cloud instance?
4. Provisioning XD db instance.
5. Getting Started with Exadata Cloud service.
6. Summary.

Chapter 12: Exadata Cloud Service-Managing them all together

Chapter Goal:
The goal is to provide end user on how to manage Exadata cloud service through Oracle enterprise manager which is deployed already in their data center- Hybrid cloud management capabilities of OEM 13.2 can provide manageability of ExaCS stack including Compute nodes, Storage nodes, ASM management, Database end- to end life cycle management capabilities including but not limited to backup automation, provisioning, cloning, compliance dashboards, snapclones etc..

1. Agent deployment on Compute node.
2. Discovering your ExaCS.
3. Managing ASM and databases.
4. Health-check and best practices through OEM
5. Summary.

Chapter 13: Exadata Cloud Service-Consolidation & Security

Chapter Goal:

The goal is to provide end user consolidation best practices along with implementing security in a consolidated environment. Encryption, segregation of duties, activity monitoring and compliance tracking methods.

1. Database Consolidation design principle on ExaCS
2. Protecting databases -Encryption best practices
3. Protecting databases- Enforcing SOD
4. Protecting databases- key management
5. Protecting databases- Auditing and compliance tracking.
6. Summary.

Chapter 14: Exadata Cloud Service-Testing your migration plan

Chapter Goal:
Testing plays a major role in any platform migration scenarios, moving to cloud could be very exciting at same time poses a great risk if anything goes wrong. Removing uncertainties and having a scientific way of testing the migration methods in a consolidated environment is key to succeed. SQL Performance analyzer and Consolidation workbench features can accelerate the journey to ExaCS simpler and faster.

No of pages:

Sub - Topics: 

1. Selecting right Migration methods to suit workload.
2. Advisories & recommendations
3. Using right testing tools-SPA, Consolidation Workbench, DB replay
4. Analyzing testing result -fix regressions.
5. Summary.

Chapter 15 Exadata Cloud Service-Migrating databases using Golden Gate Cloud Service

Chapter Goal: 
Moving database workload on cloud with a fallback mechanism could be desired for a mission critical workload. Using Oracle's golden gate cloud service we can maintain two transitionally consistent databases, Chapter will focus on implementation steps involved for such requirements.

No of pages:

Sub - Topics: 

1. Overview of GGCS 
2. Pre-requisites and preparation steps. 
3. Initial data sync on ExaCS.
4. GGCS instance configuration for replication.
5. Validating replicated data.
6. Summary.

Y V Ravi Kumar is an Oracle ACE Director and Oracle Certified Master (OCM) with 20 years of experience in Banking, Financial Services and Insurance (BFSI) vertical and played various roles like Senior Database Architect and Production DBA. He is also OCP in Oracle 8i, 9i, 10g, 11g & 12c and Certified in Golden Gate, RAC, and Performance Tuning & Oracle Exadata. He has written 90+ articles for OTN-Spanish, OTN-Portuguese, OTN-English, TOAD World, UKOUG, OTech Magazine and Redgate. He is a frequent Oracle speaker in @NYOUG, @OTN, AIOUG, Sangam and IOUG. He designed, architected and implemented Core Banking System (CBS) Database for Central Banks of two countries - India & Mahe, Seychelles. 

Nassyam Basha is a technology expert with 11 years of Oracle Database experience. He holds a master’s degree in computer science. In 2014 he became an Oracle Database 11g Certified Master. Nassyam was honored with the title of Oracle ACE Director in 2015 based on his extraordinary contributions to the Oracle community. He was the second Oracle ACE Director in India in the area of database management. He is board member of the Oracle RACSIG team. He actively participates in Oracle-related forums, such as OTN, Oracle Lists (with the status of Super Hero), and Oracle Support (with the title of Guru), and acts as an OTN moderator. He has deep knowledge in the business fields of finance, retail, health, manufacturing, and consulting.

KM Krishna Kumar is a Database Administrator. He holds master's degree in Business administration from Anna University. He started working with oracle technologies from 2004 as DBA and worked with Oracle Corporation for 5+ years. He had involved in Beta testing of Database upgrade and written knowledge articles. He is an Oracle 11g and 12c certified professional and having good knowledge in Oracle technologies such as Installation, patching, DB upgrade using various methods, Data Guard, RM

Contains hands-on examples on Oracle Exadata and ODA

Covers cloning/snap database scenarios to reduce minimum downtime

Shows Data Guard scenarios with the latest features of 12c R2 including EM 13c