Sumário Itens Encontrados: 157 Part I: Cloud Computing Fundamentals 1 Chapter 1: Introduction to Cloud Computing 3 Chapter 2: Introduction to Database as a Service 11 Part II: Database Administration in Cloud 23 Chapter 3: Provisioning 25 Chapter 4: High Availability Options 51 Chapter 5: Disaster Recovery Options 71 Chapter 6: DB Security 87 Chapter 7: DB Migration to the Cloud 99 Chapter 8: Backup and Restore 139 Chapter 9: Manage and Monitor 173Epilogue 211Index 213Overview 3What Is Cloud Computing 3Benefits of Cloud Computing 4Challenges of Cloud Computing 4Cloud Computing Service Models 5Infrastructure as a Service (IaaS) 6Platform as a Service (PaaS) 6Software as a Service (SaaS) 6Cloud Deployment Models 6Public Cloud 6Private Cloud 8Hybrid Cloud 8Community Cloud 9Metering and Chargeback 10Summary 10What Is Database as a Service? 11DBaaS Public Cloud Offerings 12Oracle Public Cloud Offering 12AWS Public Cloud Offering 16Microsoft Azure Public Cloud Offering 18DBaaS in Private Cloud 19DBaaS in Managed Services Model 19Getting Started with Database as a Service 20Selecting Your DBaaS Vendor 20Selecting the DBaaS Services 20Choosing the Right DBaaS Subscription 20Getting Acquainted with the Basic Terminology inDatabase as a Service 21Oracle Cloud Terminology 21Amazon Web Services Terminology 21Microsoft Azure Terminology 22Summary 22Database Provisioning Overview 25Database Provisioning in Oracle Cloud 26Creating Oracle Cloud Subscription 26Selecting Oracle Database Cloud Offering 29Creating the Service 30Accessing Your Database 36Database Provisioning in AWS 39Selecting the Proper Engine 39Specifying the DB Environment 41Specifying the DB Details 41Configuring the Advanced Settings 44Accessing Your AWS RDS Instance 47Summary 50Need for High Availability with Cloud-Based DBs 51Database High Availability Overview 51HA Options in Oracle Cloud 53Oracle RAC Provisioning in Oracle Cloud 53Connecting to Your RAC Database Servers Using PuTTY 59Connecting to Your RAC Database UsingSQL Developer 60RAC HA Testing 64HA Options in AWS 64Overview of Oracle RAC Provisioning in AWS 64Overview of the Multi-AZ Deployment Option 65Multi-AZ Deployment Method 66Failover in Multi-AZ Deployment 69Summary 70Need for Disaster Recovery with Cloud-Based DBs 71Database Disaster Recovery (DR) Overview 71DR Options in Oracle Cloud 72Provisioning of DataGuard in Oracle Cloud 73DataGuard Administration in Oracle Cloud 75Checking the DG Configuration Details 76Performing DB Switchover Using the Console 76Performing DB Switchover Using dbaascli 78Performing DB Failover Using the Console 82Reinstating Failed Primary Database 83DR Options in AWS 85Summary 85Need for Database Security with Cloud-Based DB 87Cloud Security Model 87Security Configurations in Oracle Cloud 88Transparent Data Encryption (TDE) 89SQL*Net Encryption 90Security Configurations in AWS 90Security at the Account Level 91Security for Oracle Running on Amazon RDS 93Security for Oracle Running on Amazon EC2 95Security Best Practices 98Summary 98DB Migration Key Considerations 99Migration Lifecycle 101Migration Approach 102Backup 102Transfer 102Restore 103Migration Options 103Migration Using Tools 103Traditional Migration Methods 105Lesser Known Migration Methods 106Comparison of Migration Methods 107Detailed Migration Steps for Data Migration fromthe Local Database to Amazon RDS 107Detailed Migration Steps for Data Migration UsingOracle Data Pump Utility 113Sample Comparison Between SQL Developer andData Pump Migration 116Migration Using RMAN Backup Restore 117Migration By Cloning a PDB into the Cloud 118Multitenant Setup On-Premise (Local) 119Create Oracle 12c PDB Database in Oracle Public Cloud 120Clone LocalPDB (Optional) 120Open the Cloned LocalPDB in READWRITE Mode (Optional) 122Close LocalPDB 123Convert LocalPDB into READONLY Mode 123Unplug LocalPDB 124Copy the XML and Data Files to the Cloud DB Server 124Using EM Express to Plug LocalPDB into the Cloud 129Open LocalPDB in the Cloud 131Migration Using DMS 132Migration Using AWS Snowball 135Migration Best Practices 137Summary 137Chapter 8: Backup and Restore 139Overview of Database Backup and Restore fromthe Cloud Perspective 139Using the Cloud as a Backup Destination foran On-Premise Database 140Using Backup and Restore Options (Within the Cloud)for a Cloud Database 141DB Backup and Restore in Oracle Cloud 141Oracle Database Cloud Backup Service 142DB Snapshots 147Oracle Database Backup Service 149Database Recovery in Oracle Cloud 155DB Backup and Restore in AWS 162On-Premise Backup to Amazon Cloud Using Amazon S3 162DB Backup and Restore in Amazon RDS 167DB Backup and Restore in Amazon EC2 172Backup and Restore Best Practices 172Summary 172Overview of Cloud DB Monitoring and Management 173DB Monitoring and Management in Oracle Cloud 174DBaaS Monitor 176EM Express 185Command-Line Interfaces 194SQL Developer 197DB Monitoring and Management in AWS 199AWS RDS Monitoring Using OEM 201AWS CloudWatch 204DB Monitoring and Management Best Practices 209Summary 209