Muutke küpsiste eelistusi

E-raamat: Oracle High Availability, Disaster Recovery, and Cloud Services: Explore RAC, Data Guard, and Cloud Technology

  • Formaat: PDF+DRM
  • Ilmumisaeg: 16-May-2019
  • Kirjastus: APress
  • Keel: eng
  • ISBN-13: 9781484243510
Teised raamatud teemal:
  • Formaat - PDF+DRM
  • Hind: 80,26 €*
  • * hind on lõplik, st. muud allahindlused enam ei rakendu
  • Lisa ostukorvi
  • Lisa soovinimekirja
  • See e-raamat on mõeldud ainult isiklikuks kasutamiseks. E-raamatuid ei saa tagastada.
  • Formaat: PDF+DRM
  • Ilmumisaeg: 16-May-2019
  • Kirjastus: APress
  • Keel: eng
  • ISBN-13: 9781484243510
Teised raamatud teemal:

DRM piirangud

  • Kopeerimine (copy/paste):

    ei ole lubatud

  • Printimine:

    ei ole lubatud

  • Kasutamine:

    Digitaalõiguste kaitse (DRM)
    Kirjastus on väljastanud selle e-raamatu krüpteeritud kujul, mis tähendab, et selle lugemiseks peate installeerima spetsiaalse tarkvara. Samuti peate looma endale  Adobe ID Rohkem infot siin. E-raamatut saab lugeda 1 kasutaja ning alla laadida kuni 6'de seadmesse (kõik autoriseeritud sama Adobe ID-ga).

    Vajalik tarkvara
    Mobiilsetes seadmetes (telefon või tahvelarvuti) lugemiseks peate installeerima selle tasuta rakenduse: PocketBook Reader (iOS / Android)

    PC või Mac seadmes lugemiseks peate installima Adobe Digital Editionsi (Seeon tasuta rakendus spetsiaalselt e-raamatute lugemiseks. Seda ei tohi segamini ajada Adober Reader'iga, mis tõenäoliselt on juba teie arvutisse installeeritud )

    Seda e-raamatut ei saa lugeda Amazon Kindle's. 

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

About the Authors xvii
About the Technical Reviewer xxi
Acknowledgments xxiii
Chapter 1 Introduction to High Availability and Disaster Recovery with Cloud Technology
1(22)
Why High Availability?
3(4)
Best Practices for a High Availability Environment
7(3)
Data Guard
10(1)
Maximum Performance
10(1)
Maximum Protection
10(1)
Maximum Availability
10(1)
Importance of HA and DR
11(1)
Evolution of Cloud Technologies
11(4)
Advantages of Having a Cloud Environment
15(4)
Centralized Location
15(1)
Setup Cost
15(1)
Operational Cost
16(1)
Duration to Create the Setup
17(1)
Scalability
17(1)
Optimization and Modification
17(1)
Ease of Handling
18(1)
Migration
18(1)
Security
18(1)
Variety of Applications
19(1)
Free from Operations Headaches: Licensing Expiration
19(1)
Differences Between On-Premises, IaaS, PaaS, and SaaS
19(2)
On-Premise
20(1)
IaaS
20(1)
PaaS
21(1)
SaaS
21(1)
Summary
21(2)
Chapter 2 Oracle Active Data Guard with Cloud Services
23(68)
Types of DR Databases
24(2)
Physical Standby Databases
24(1)
Logical Standby Databases
25(1)
DR Activity Attributes
26(2)
Log Destination
26(1)
ARCH
26(1)
Log Writer Process
27(1)
LNS
27(1)
RFS
27(1)
Behavior of the DR Activity
28(1)
Maximum Protection
28(1)
Maximum Availability
28(1)
Maximum Performance
28(1)
Differences Between Modes
29(1)
Switchover
29(3)
Failover
32(1)
Data Guard Broker
33(2)
DG Setup in the Cloud
35(15)
DBaaS Tool Update
35(3)
Dbaascli Commands to Data Guard
38(2)
Dbaascli Data Guard Switchover
40(2)
Dbaascli Data Guard Failover
42(2)
Dbaascli Data Guard Reinstate
44(2)
Data Guard Switchover Through the GUI
46(4)
Data Guard Failover Through the GUI
50(3)
Hybrid DR
53(15)
Automatic Approach
54(8)
Manual Approach
62(6)
Backup Utility for the Primary Database in Cloud
68(3)
Backing Up to Cloud Storage
68(1)
Backing Up to Disk and Cloud Storage
69(2)
Managing DR Instances Through DBaaS Monitor/Oracle SQL Developer Web
71(18)
Enable the Login Schema
73(4)
Using the Schema
77(1)
Using the GUI
77(12)
Summary
89(2)
Chapter 3 High Availability for Cloud Control 13c
91(96)
OEM Agent High Availability Setup
91(4)
Directory Structures and Their Purpose
91(1)
Checking the Current Agent High Availability Configuration
92(1)
Changing the Agent's High Availability Configuration
93(2)
HA and MAA Best Practices for the OEM 13c Repository Database
95(34)
Creating the Repository in a 12.2 Primary Database on a RAC Database
95(1)
Setting Recommended Parameters for the Primary Database
96(1)
Creating a Data Guard Standby of the OEMREPO Database with OEM 13.2 Cloud Control
97(32)
OMS High Availability Setup
129(49)
Adding a Second OMS Server
130(36)
Configuring the Application Servers for Disaster Recovery
166(12)
OEM Always-On Monitoring
178(8)
Configuring AOM
178(7)
Starting AOM
185(1)
Bug 25132376
185(1)
Enabling Notifications
186(1)
Summary
186(1)
Chapter 4 GI and RAC Options
187(70)
ASM Filter Driver
187(7)
Configuring the ASM Filter Driver
188(1)
Manual Configuration of the ASM Filter Driver
189(5)
ACFS Snapshot Replication
194(13)
ACFS Creation on the Source Cluster
194(2)
ACFS Creation on the Standby
196(2)
Public Keys
198(3)
Initiating Replication on the Standby
201(3)
Initiating Replication on the Primary
204(1)
Testing the Replication
205(2)
HANFS Filesystems (NFS v3)
207(10)
HANFS (NFS v3) Server-Side Setup
207(8)
HANFS (NFS v3) Client-Side Setup
215(2)
Oracle Flex Clusters
217(15)
Adding a Leaf Node to a Freshly Installed Cluster
219(13)
Flex Redundancy Disk groups
232(8)
Creating a Flex Disk group
232(2)
Filegroup
234(6)
Rapid Home Provisioning
240(15)
Configuring the RHP Server Resource
241(2)
Using the Existing RDBMS and GI Installations on the RHP Server as Golden Images
243(1)
Provisioning a Working Copy of the GI Home
244(4)
ORACLE_HOME for 12.2 GI Provisioning
248(2)
Converting the Target Cluster into an RHP Cluster
250(1)
Provisioning a Working Copy of the RDBMS Home
251(2)
Provisioning a Database on the Client Cluster
253(2)
Database SYS/SYSTEM Passwords
255(1)
Summary
255(2)
Chapter 5 Troubleshooting and Conducting Health Checks for High Availability
257(36)
Cluster Verification Utility
257(5)
Software Home Checks
258(2)
File System Space Checks
260(2)
Cluster Verification Utility Health Checks
262(14)
Database Health Checks
262(8)
Cluster Health Checks
270(3)
Cluster Verification Utility Baselines
273(3)
Orachk
276(5)
Upgrading Orachk
277(1)
Orachk/Exachk and Oracle RESTful Data Services
277(2)
Recommended Settings for Orachk Daemons
279(2)
Trace File Analyzer
281(9)
Upgrading TFA to Include the Support Tools Bundle
281(2)
Using Trace File Analyzer to Manage Logfiles
283(7)
New Health Check and Troubleshooting Features in 12.2
290(1)
Cluster Health Advisor
290(2)
Summary
292(1)
Chapter 6 Best Practices in Oracle Data Guard with Tips and Techniques
293(42)
Creating a Standby Database Using DBCA
293(2)
Expected Error Messages per Limitations
293(1)
Example of a DBCA-Created Standby
294(1)
Alternative Ways to Supply the SYS Password
295(1)
Diagnostic Pack on Active Data Guard
295(7)
The SYS$UMF User
296(1)
Creating the DB Links
297(1)
Configuring the Remote Management Framework Topology
298(1)
Viewing the Topology information
299(1)
Taking AWR Snapshots on ADG Databases
300(1)
Creating AWR Reports for the Standby Database
300(2)
SQL Tuning Advisor in ADG Databases
302(4)
Creating a Database Link for the SQL Tuning Advisor
302(1)
Tuning a Query
303(3)
RMAN Support for NONLOGGED BLOCK recovery
306(5)
Creating a Table with the NOLOGGING Clause
306(2)
The Effect of NOLOGGING Operations on the Physical Standby
308(1)
Fixing the Problem
309(2)
Data Guard Support for Multiple Observers
311(3)
Starting Multiple Observers
312(1)
Determining the Master Observer
312(2)
Manually Changing the Master Observer
314(1)
Data Guard Multi-instance Apply
314(1)
Broker Example
315(1)
SQLPLUS Example
315(1)
Selectively Applying Redo for PDBs in Data Guard
315(4)
Effects of the ENABLED_PDBS_ON_STANDBY Parameter
316(3)
Disabling Redo Apply for an Existing PDB
319(1)
Data Guard Database Compare
319(4)
Using DBMS_DBCOMP to Detect Nologging Operations
320(1)
Contents of the dbcomp.txt File
321(2)
Password File Change Synchronization
323(3)
Checksums Prior to the SYS Password Change
324(1)
Changing the Password
324(1)
Checksums After to the SYS Password Change
324(1)
In-Memory Columnar Store for ADG Instances
325(1)
Role Transition Connection Preservation
326(2)
Establishing the Connection
326(1)
Performing the Role Transition
327(1)
Checking the Existing Session
327(1)
PDB Migrate
328(5)
ALTCDB Broker Configuration
329(1)
Broker Configuration
329(1)
The Migration
330(1)
Source Database Alert Log Entry
331(1)
Target Database Alert Log Entry
331(1)
State of ALTCDB Post-Migration
332(1)
Summary
333(2)
Chapter 7 Oracle Sharding
335(64)
Components of the Sharding Architecture
337(2)
Methods of Sharding
339(2)
Create Table Syntax in SDB
340(1)
Installation and Configuration
341(42)
Add the DNS or Hosts File Entries
343(1)
Add a Disk for Database Storage, Create LVM on It, and Mount It
343(1)
Calculate the Size of /dev/shm
344(1)
Disable iptables and Firewalls on All Hosts
344(1)
Disable IPv6
345(1)
Install the Oracle RDBMS Pre-installation RPM on All Hosts
345(1)
Create the Necessary Directories on Each Sharded Database (shdb1 and shdb2) and Catalog/GSM Nodes (shcat)
345(1)
Install the Database Software in Silent Mode on Each Sharded Database (shdb[ 1-4]) and Catalog/GSM Node (shcat)
346(1)
Create a Noncontainer Database Using DBCA and a Local Listener Using NETCA on the Catalog/GSM Node Only
347(5)
Install the GSM Software on the Catalog/GSM Node (shcat)
352(5)
Create a Shard Catalog Schema in the SHRCAT Database in the SHCAT Node
357(3)
Start the Scheduler Agents on Sharding Nodes
360(3)
Using GSDCTL to Create the Shard Catalog
363(2)
Create the Shard Group, Director, and Shards
365(3)
Deploy Shards Using GSDCTL
368(5)
Create the Global Service
373(1)
Disable the FSFO-Observer (Optional)
374(4)
Create Tablespaces, Schemas, and Tables
378(5)
Testing the Methodology
383(10)
Troubleshooting
393(3)
High Availability with Oracle Sharded Databases
396(1)
Backup and Recovery for SDBs
397(1)
Summary
398(1)
Chapter 8 Oracle Engineered Systems for High Availability
399(118)
Oracle Database Appliance Performance Optimization
402(1)
Technical Specifications of the ODA x7-2 Family
402(1)
Oracle Database Appliance x7-2-HA Architecture and Storage Specifications
403(3)
ODA Deployment Models
406(4)
ODA Bare-Metal Components
406(1)
ODA Virtualized Components
407(2)
Options for ODA Virtualized Environments
409(1)
Deployment in ODA
410(13)
The Flow of Deployment in ODA
411(1)
ODA Deployment in a Bare-Metal Environment
411(7)
ODA Deployment in a Virtualized Environment
418(5)
Purging LOGs in ODA
423(1)
Management and Diagnostics of ODA
424(5)
Auto Service Request (ASR)
424(1)
ODA ORACHK
424(1)
OEM ODA Plug-In
425(1)
Diagnostics Collection
425(1)
Odaadmcli manage diagcollect
425(1)
System Check for ODA Environments
426(3)
Details of the ODA Assessment Report
429(1)
ODA Patching
429(22)
Prerequisites
431(1)
Applying the 12.1.2.10.0 Patch
431(13)
Using ODACLI Commands to Patch a System and Upgrade Databases
444(2)
Updating the Repository of Grid Infrastructure and Databases Using the ODACLI Command
446(3)
Updating the Databases to the Latest PSU
449(1)
Upgrading Database Patchsets or to Major Releases
450(1)
ODACLI Commands
451(3)
Commands for Creating Databases
451(1)
Appliance Commands
451(1)
CPU Core Commands
452(1)
Database Commands
452(1)
DB Home Commands
453(1)
DB Storage Commands
453(1)
Odaadmcli Commands
454(1)
Storage Commands
454(1)
Hardware Monitoring
454(1)
Resize the ACFS File System in ODA
455(3)
Nondatabase Volumes
456(1)
Database Volumes
456(1)
Alert Received from EM Cloud Control
457(1)
Using the OAKCLI Command Utility with Databases
458(8)
Creating a Single-Instance Database
459(1)
Creating a RAC Database
460(2)
Upgrading the Database from Oracle 11g R2 (11.2.0.4.0) to Oracle 12c R2 (12.1.0.2.0)
462(1)
Creating a Snapshot Database
463(2)
Dropping a Snapshot Database
465(1)
Dropping a Database
465(1)
Dismounting an ACFS Filesystem
466(5)
gDBClone Package for Oracle Engineered Systems
471(4)
gDBClone Package RPM Installation
471(3)
Using gDBClone
474(1)
Oracle Exadata Database Machine
475(3)
Oracle Exadata Hardware Generation Advances from v1 to X7
476(1)
Oracle Exadata Database Machine x7-2 Component Specifications
476(2)
Oracle Exadata Unique Smart Database Software Features
478(1)
Enhancements and Features of Oracle Exadata x7-2
479(1)
Oracle Exadata x7 High vs. Normal Redundancy
480(1)
Oracle Exadata Deployment Assistant
480(35)
M.2 Hot-Swappable Boot Drives from Oracle Exadata x7-2
481(1)
Finding the Model of the Oracle Exadata
482(1)
Information on Oracle Exadata Database Machine Models
483(1)
Improved Oracle Database Deployment Assistant
483(1)
Oracle Exadata x7: Unique Fault-Tolerant In-Memory Databases
483(1)
Quorum Disks in Oracle Exadata
484(1)
Checking the Volumes (/ and /u01) in All Oracle Exadata Compute Nodes
485(2)
Configuring Hugepages in Oracle Exadata
487(1)
Generating Cell Events on Exadata Storage Server
488(2)
Configuring SSH Equivalence from Oracle Exadata Compute Nodes to All Exadata Storage Servers and IB Nodes for the Root User
490(2)
Disk Scrubbing Feature for Oracle Exadata Storage Server
492(6)
Deleting Trace Files from Oracle Exadata Storage Servers
498(2)
Oracle Exadata x7-2: Do-Not-Service LED Property
500(2)
Online Flash Disk Replacement in Oracle Exadata x7
502(1)
RAID 0 on Flash Disks in Oracle Exadata x7
503(1)
Oracle Exadata x7: Disk Controller CacheVault Flash Module Monitoring
504(1)
Exafusion Parameter on the Oracle Exadata Database Machine
505(2)
Oracle Exadata: Flash Cache Compression
507(1)
Flash Card Changes in Oracle Exadata x4-2/x6-2
508(4)
Oracle Exadata: Patch Backups Taking Up a Lot of Disk Space
512(1)
Snap Clone Feature in Oracle Exadata
513(2)
Summary
515(2)
Chapter 9 Oracle Cloud Overview
517(58)
General Cloud Concepts: What Is a Private Cloud?
518(2)
What Is a Public Cloud?
519(1)
What Is a Hybrid Cloud?
520(1)
What Is a Community Cloud?
520(1)
What Is the Oracle Public Cloud?
520(1)
What Is Oracle's Software as a Service?
520(1)
What Is Oracle's Platform as a Service?
520(1)
What Is Oracle's Infrastructure as a Service?
521(7)
Oracle Infrastructure as a Service (IaaS)
522(1)
Oracle Cloud Infrastructure Concepts
523(1)
Oracle Cloud Infrastructure Key Concepts
524(4)
Signing Up for Oracle Cloud Infrastructure Services
528(2)
Signing In to the Console
530(1)
Virtual Cloud Network
530(7)
Subnet
531(1)
Internet Gateway
531(1)
Dynamic Routing Gateway
531(1)
Security List
532(1)
Route Table
533(4)
Creating a Compute Instance in the Public Cloud
537(15)
Oracle Database Cloud Service Options
552(2)
Database Standard Edition
553(1)
Database Enterprise Edition
553(1)
Database Enterprise Edition High Performance
553(1)
Database Enterprise Edition Extreme Performance
554(1)
Database Cloud Deployment Scenarios
554(2)
Bronze Category
554(1)
Silver Category
555(1)
Gold Category
555(1)
Platinum Category
555(1)
Significance of a Maximum Availability Architecture
556(1)
Disaster Recovery Deployments with the Oracle Public Cloud
557(14)
Moving an On-Premise Database to the Oracle Database Cloud Service
571(3)
Summary
574(1)
Chapter 10 Exadata Cloud Provisioning
575(26)
Exadata Cloud Service on Oracle Cloud Infrastructure
576(1)
Exadata Cloud Service: Provisioning
577(22)
Using the Oracle Cloud Infrastructure Dashboard
578(10)
Recommended Configuration for Security Rules
588(6)
Creating the Exadata Database System
594(5)
Summary
599(2)
Chapter 11 Migrating Databases to Exadata Cloud Service Using DIPC
601(62)
Creating a DBCS Service
603(5)
Creating a DIPC Service (18.x.x)
608(38)
Generating a Secure Shell (SSH) Public/Private Key Pair on Linux
611(1)
Generate SSH Key Pair on Windows Using the PuTTYgen Program
612(4)
DIPC Remote Agent Deployment
616(3)
Configuring a Remote Agent for the On-Premise Host
619(22)
Configuration On-Premise
641(4)
Setting Up and Starting the SOCKS5 Proxy Tunnel for the PUMP Process
645(1)
Steps to Access DIPC VM and DBCS/EXACS
646(16)
Connecting to the DIPC VM via VNC
650(1)
Steps to connect to DBCS/EXACS from the DIPC VM
651(1)
Configuring the DIPCVM
652(8)
Starting the OGG Pump and Replicate Process
660(1)
Validating
660(1)
Gathering Stats
661(1)
Summary
662(1)
Chapter 12 Managing Exadata Cloud Service
663(6)
Agent Deployment on Exadata Cloud Service
665(3)
Creating the Credentials
666(1)
Deploying the Oracle Enterprise Manager Cloud Control Agent
667(1)
Standard Agent Deployment on ExaCS with a VPN
667(1)
Summary
668(1)
Index 669
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 masters 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 Telcos in India. He has lead various complex implementations at top banks and Talcos 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.