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) |
|
|
3 | (4) |
|
Best Practices for a High Availability Environment |
|
|
7 | (3) |
|
|
10 | (1) |
|
|
10 | (1) |
|
|
10 | (1) |
|
|
10 | (1) |
|
|
11 | (1) |
|
Evolution of Cloud Technologies |
|
|
11 | (4) |
|
Advantages of Having a Cloud Environment |
|
|
15 | (4) |
|
|
15 | (1) |
|
|
15 | (1) |
|
|
16 | (1) |
|
Duration to Create the Setup |
|
|
17 | (1) |
|
|
17 | (1) |
|
Optimization and Modification |
|
|
17 | (1) |
|
|
18 | (1) |
|
|
18 | (1) |
|
|
18 | (1) |
|
|
19 | (1) |
|
Free from Operations Headaches: Licensing Expiration |
|
|
19 | (1) |
|
Differences Between On-Premises, IaaS, PaaS, and SaaS |
|
|
19 | (2) |
|
|
20 | (1) |
|
|
20 | (1) |
|
|
21 | (1) |
|
|
21 | (1) |
|
|
21 | (2) |
|
Chapter 2 Oracle Active Data Guard with Cloud Services |
|
|
23 | (68) |
|
|
24 | (2) |
|
Physical Standby Databases |
|
|
24 | (1) |
|
Logical Standby Databases |
|
|
25 | (1) |
|
|
26 | (2) |
|
|
26 | (1) |
|
|
26 | (1) |
|
|
27 | (1) |
|
|
27 | (1) |
|
|
27 | (1) |
|
Behavior of the DR Activity |
|
|
28 | (1) |
|
|
28 | (1) |
|
|
28 | (1) |
|
|
28 | (1) |
|
Differences Between Modes |
|
|
29 | (1) |
|
|
29 | (3) |
|
|
32 | (1) |
|
|
33 | (2) |
|
|
35 | (15) |
|
|
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) |
|
|
53 | (15) |
|
|
54 | (8) |
|
|
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) |
|
|
73 | (4) |
|
|
77 | (1) |
|
|
77 | (12) |
|
|
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) |
|
|
178 | (8) |
|
|
178 | (7) |
|
|
185 | (1) |
|
|
185 | (1) |
|
|
186 | (1) |
|
|
186 | (1) |
|
Chapter 4 GI and RAC Options |
|
|
187 | (70) |
|
|
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) |
|
|
198 | (3) |
|
Initiating Replication on the Standby |
|
|
201 | (3) |
|
Initiating Replication on the Primary |
|
|
204 | (1) |
|
|
205 | (2) |
|
HANFS Filesystems (NFS v3) |
|
|
207 | (10) |
|
HANFS (NFS v3) Server-Side Setup |
|
|
207 | (8) |
|
HANFS (NFS v3) Client-Side Setup |
|
|
215 | (2) |
|
|
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) |
|
|
234 | (6) |
|
|
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) |
|
|
255 | (2) |
|
Chapter 5 Troubleshooting and Conducting Health Checks for High Availability |
|
|
257 | (36) |
|
Cluster Verification Utility |
|
|
257 | (5) |
|
|
258 | (2) |
|
|
260 | (2) |
|
Cluster Verification Utility Health Checks |
|
|
262 | (14) |
|
|
262 | (8) |
|
|
270 | (3) |
|
Cluster Verification Utility Baselines |
|
|
273 | (3) |
|
|
276 | (5) |
|
|
277 | (1) |
|
Orachk/Exachk and Oracle RESTful Data Services |
|
|
277 | (2) |
|
Recommended Settings for Orachk Daemons |
|
|
279 | (2) |
|
|
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) |
|
|
290 | (2) |
|
|
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) |
|
|
296 | (1) |
|
|
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) |
|
|
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) |
|
|
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) |
|
|
315 | (1) |
|
|
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) |
|
|
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) |
|
|
328 | (5) |
|
ALTCDB Broker Configuration |
|
|
329 | (1) |
|
|
329 | (1) |
|
|
330 | (1) |
|
Source Database Alert Log Entry |
|
|
331 | (1) |
|
Target Database Alert Log Entry |
|
|
331 | (1) |
|
State of ALTCDB Post-Migration |
|
|
332 | (1) |
|
|
333 | (2) |
|
Chapter 7 Oracle Sharding |
|
|
335 | (64) |
|
Components of the Sharding Architecture |
|
|
337 | (2) |
|
|
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) |
|
|
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) |
|
|
383 | (10) |
|
|
393 | (3) |
|
High Availability with Oracle Sharded Databases |
|
|
396 | (1) |
|
Backup and Recovery for SDBs |
|
|
397 | (1) |
|
|
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) |
|
|
406 | (4) |
|
ODA Bare-Metal Components |
|
|
406 | (1) |
|
ODA Virtualized Components |
|
|
407 | (2) |
|
Options for ODA Virtualized Environments |
|
|
409 | (1) |
|
|
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) |
|
|
423 | (1) |
|
Management and Diagnostics of ODA |
|
|
424 | (5) |
|
Auto Service Request (ASR) |
|
|
424 | (1) |
|
|
424 | (1) |
|
|
425 | (1) |
|
|
425 | (1) |
|
Odaadmcli manage diagcollect |
|
|
425 | (1) |
|
System Check for ODA Environments |
|
|
426 | (3) |
|
Details of the ODA Assessment Report |
|
|
429 | (1) |
|
|
429 | (22) |
|
|
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) |
|
|
451 | (3) |
|
Commands for Creating Databases |
|
|
451 | (1) |
|
|
451 | (1) |
|
|
452 | (1) |
|
|
452 | (1) |
|
|
453 | (1) |
|
|
453 | (1) |
|
|
454 | (1) |
|
|
454 | (1) |
|
|
454 | (1) |
|
Resize the ACFS File System in ODA |
|
|
455 | (3) |
|
|
456 | (1) |
|
|
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) |
|
|
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) |
|
|
465 | (1) |
|
Dismounting an ACFS Filesystem |
|
|
466 | (5) |
|
gDBClone Package for Oracle Engineered Systems |
|
|
471 | (4) |
|
gDBClone Package RPM Installation |
|
|
471 | (3) |
|
|
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) |
|
|
515 | (2) |
|
Chapter 9 Oracle Cloud Overview |
|
|
517 | (58) |
|
General Cloud Concepts: What Is a Private Cloud? |
|
|
518 | (2) |
|
|
519 | (1) |
|
|
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) |
|
|
530 | (7) |
|
|
531 | (1) |
|
|
531 | (1) |
|
|
531 | (1) |
|
|
532 | (1) |
|
|
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) |
|
|
554 | (1) |
|
|
555 | (1) |
|
|
555 | (1) |
|
|
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) |
|
|
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) |
|
|
599 | (2) |
|
Chapter 11 Migrating Databases to Exadata Cloud Service Using DIPC |
|
|
601 | (62) |
|
|
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) |
|
|
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) |
|
|
652 | (8) |
|
Starting the OGG Pump and Replicate Process |
|
|
660 | (1) |
|
|
660 | (1) |
|
|
661 | (1) |
|
|
662 | (1) |
|
Chapter 12 Managing Exadata Cloud Service |
|
|
663 | (6) |
|
Agent Deployment on Exadata Cloud Service |
|
|
665 | (3) |
|
|
666 | (1) |
|
Deploying the Oracle Enterprise Manager Cloud Control Agent |
|
|
667 | (1) |
|
Standard Agent Deployment on ExaCS with a VPN |
|
|
667 | (1) |
|
|
668 | (1) |
Index |
|
669 | |