Yv Ravi Kumar, Nassyam Basha, Krishna Kumar K M, Bal Mukund Sharma, Konstantin Kerekovski

Oracle High Availability, Disaster Recovery, and Cloud Services

Explore Rac, Data Guard, and Cloud Technology
Mitarbeit:Ravikumar, Y. V.; Basha, Nassyam; Kumar, K. M. Krishna; Sharma, Bal Mukund; Kerekovski, Konstantin

• Broschiertes Buch

Produktbeschreibung

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 ForOracle database administrators

Produktdetails

• Verlag: Apress / Springer, Berlin
• Artikelnr. des Verlages: 978-1-4842-4350-3
• 1st ed.
• Seitenzahl: 679
• Erscheinungstermin: 16. Mai 2019
• Englisch
• Abmessung: 254mm x 178mm x 37mm
• Gewicht: 1308g
• ISBN-13: 9781484243503
• ISBN-10: 1484243501
• Artikelnr.: 54530478

Autorenporträt

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, RMAN, RAC. He has delivered presentations to customers through various channels. He actively participates in Oracle-related forums such as OTN communities. Bal Sharma is an Oracle Certified Professional (OCP) with 14 years of experience across various industries like Telecom, Healthcare, Financial Services and Insurance; played various roles like Database Manager and Technical lead DBA, Content Architect. He holds several certification across Oracle 10g/11g/12c and Certified in RAC and Oracle Exadata. In his recent role he has been advising customers on adoption of Hybrid Cloud platforms, primarily focusing on database technologies like High Availability and Engineered Systems. He has been in setting up a Database strategies for the largest Banks and Telco's in India. He has lead various complex implementations at top banks and Talco's in India. Bal is an avid technologist and believes customer satisfaction is of prime importance, his work across customers like State Bank of India, HDFC, Idea Cellular and Vodafone is a testimonial for the same. Besides this, Bal enjoys cooking for friends and family. Konstantin Kerekovski is an Oracle Professional with over 6 years of experience in the Financial Services Industry. Konstantin Kerekovski is a member of the Independent Oracle User Group, Suncoast. Oracle User Group and the New York Oracle User Group.. Konstantin Kerekovski has worked as a Senior and Lead Database Administrator with Production Support duties in the Financial Services Industry. Konstantin Kerekovski is a speaker at IOUG Collaborate 2017 as well as SOUG and NYOUG meetings.  Konstantin is an expert at oracle Real Application Cluster Technologies, ASM, Goldengate and Oracle 11g and 12c.

Inhaltsangabe

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 -Topics1. Introduction to High availability2. Options for Disaster Recovery3. Why we require HA & DR4. Difference between High availability and Disaster recovery5. Importance of HA & DR6. Evolution of Cloud technologies7. 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 introduction2. Oracle RAC 12 R2 new features3. Flex ASM and Flex Clusters4. Oracle Domain Services Clusters5. Cluster Health Advisor and the GIR6. Rapid Home Provisioning7. Oracle RAC Reader nodes8. Oracle ASM Filter Driver9. 12.2 ACFS Replication and new Features10. HACIFS11. Managing Clusterware with OEM12. 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 database2. Data guard configuration and protection levels3. Data guard Switchover4. Data guard Failover5. 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 DBCA2. Support for Diagnostic Pack with ADG3. Support for SQL Tuning Advisor4. No Logging Changes for Data Guard5. Multiple Observers6. Multiple Instance Redo Apply (MIRA) in RAC7. Subset Standbys8. Data Guard Database Compare9. Automatic Password File Synchronization10. in-Memory Support for ADG11. Minimize Impact to Primary Databases with Multiple Sync Standby Databases12. Duplicate Command Enhancements for DG13. Connection Preservation during Role Changes14. 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 configuration2. OEM Metrics & Monitoring3. Backup through OEM4. HA and MAA best practices for the OEM 13c repository Database5. OMS High Availability setup6. OEM Always On Monitoring7. 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 Option2. RAC Reader Nodes Finalization3. Configure Cluster Domain Services (DSC)4. Converting from Standard ASM to Flex ASM5. Installing ASM in Minimal nodes and Benefits6. Extended RAC Benefits and Pre-Reqs7. 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.22. Sharding Introduction3. Necessity of Sharding4. Sharding deployment5. Sharding Methods6. System Managed Sharding7. Composite Sharding8. User-Defined Sharding9. EM 13cR2 Support Sharding10. 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 ODA2. OAKCLI - Database creation3. OAKCLI - Snapshot database creation4. OAKCLI - Database deletion5. OAKCLI - Database upgrade6. Introduction HA in ODA7. Physical standby creation8. RAC Database creation9. 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 Methods2. Health-Check Methods3. Cluster Verification Utility (CVU)4. ORAChk/EXAChk5. 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 cloud2. What is cloud? Private, Public, Hybrid, Community.3. HA setup creation in Public cloud4. Disaster recovery setup creation in Cloud5. 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 OEM5. 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 ExaCS2. Protecting databases -Encryption best practices3. Protecting databases- Enforcing SOD4. Protecting databases- key management5. 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 & recommendations3. Using right testing tools-SPA, Consolidation Workbench, DB replay4. 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.