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