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