Oracle Autonomous Database in Enterprise Architecture

Oracle Autonomous Database in Enterprise Architecture

by Bal Mukund Sharma, Krishnakumar KM, Rashmi Panda
Released December 2022
Publisher(s): Packt Publishing
ISBN: 9781801072243

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Book description

Get up to speed with Oracle's Autonomous Databases and implementation strategies for any workload or use case, including transactional, data warehousing, and non-relational databases

Key Features

  • Explore ADB, its business benefits, and architectural considerations
  • Migrate the existing workload to ADB, explore high availability, and use cloud native methods for monitoring and event notifications
  • Leverage APEX, JSON, the REST API, and SQL Developer Web features for rapid development

Book Description

Oracle Autonomous Database (ADB) is built on the world’s fastest Oracle Database Platform, Exadata, and is delivered on Oracle Cloud Infrastructure (OCI), customer data center (ExaCC), and Oracle Dedicated Region Cloud. This book is a fast-paced, hands-on introduction to the most important aspects of OCI Autonomous Databases.

You'll get to grips with concepts needed for designing disaster recovery using standby database deployment for Autonomous Databases. As you progress, you'll understand how you can take advantage of automatic backup and restore. The concluding chapters will cover topics such as the security aspects of databases to help you learn about managing Autonomous Databases, along with exploring the features of Autonomous Database security such as Data Safe and customer-managed keys for Vaults.

By the end of this Oracle book, you’ll be able to build and deploy an Autonomous Database in OCI, migrate databases to ADB, comfortably set up additional high-availability features such as Autonomous Data Guard, and understand end-to-end operations with ADBs.

What you will learn

  • Explore migration methods available for Autonomous Databases, using both online and offline methods
  • Create standby databases, RTO and RPO objectives, and Autonomous Data Guard operations
  • Become well-versed with automatic and manual backups available in ADB
  • Implement best practices relating to network, security, and IAM policies
  • Manage database performance and log management in ADB
  • Understand how to perform data masking and manage encryption keys in OCI's Autonomous Databases

Who this book is for

This book is for decision makers, enterprise cloud architects, solution consultants, cloud engineers, implementation partners, and technology students, as well as anyone who wants to learn about Oracle’s Autonomous Databases delivered on Oracle Cloud Infrastructure (OCI). Beginner-level knowledge of Linux and OCI and networking concepts and databases, along with hands-on experience in OCI environments is required before getting started with this book.

Table of contents

  1. Oracle Autonomous Database in Enterprise Architecture
  2. Contributors
  3. About the authors
  4. About the reviewers
  5. Preface
    1. Who this book is for
    2. What this book covers
    3. To get the most out of this book
    4. Download the color images
    5. Conventions used
    6. Get in touch
    7. Share Your Thoughts
    8. Download a free PDF copy of this book
  6. Part 1 – Understanding Autonomous Database in OCI
  7. Chapter 1: Introduction to Oracle's Autonomous Database
    1. Technical requirements
    2. Learning what an Autonomous Database is
      1. Always Free ADB
    3. Technology building blocks – ADB
      1. Oracle DBEE
      2. Oracle Exadata Database Machine
      3. OCI
      4. Oracle best practices
      5. Oracle knowledge base
      6. ML
    4. Classification of ADB based on workload
      1. ADW
      2. ATP
      3. AJD
    5. ADB infrastructure deployment choices – shared and dedicated
      1. Shared
      2. Dedicated
      3. ADB on Exadata Cloud@Customer
    6. Understanding why to use an Autonomous Database
      1. Decades of innovation in the ML capabilities of Oracle Database
      2. Autonomous Database value proposition
    7. Reviewing use cases for ADB
    8. Understanding the business benefits of using ADB
      1. Improved business performance gains
      2. Improved DBA and system administrator productivity
      3. Reduced development cycle time
      4. Reduced non-compliance risks – data
      5. Reduced planned downtime
      6. Reduced unplanned downtime
      7. Reduced IT infrastructure acquisition
      8. Reduced IT infrastructure maintenance and support
    9. BOM and SKUs for autonomous databases
    10. Summary
    11. Questions
    12. Further reading
    13. Answers
  8. Chapter 2: Autonomous Database Deployment Options in OCI
    1. Technical requirements
    2. OCI’s Free tier account
      1. OCI Free Trial
      2. Always Free resources on OCI
      3. Creating an Always Free ADB
    3. Networking, IAM, and security for shared and dedicated deployments
      1. Prerequisites – IAM considerations
      2. Policy requirements for your ADB
      3. Networking considerations
      4. Deploying a serverless shared ADB
      5. Deploying a dedicated Exadata infrastructure
    4. Summary
  9. Part 2 – Migration and High Availability with Autonomous Database
  10. Chapter 3: Migration to Autonomous Database
    1. Migration considerations
      1. About the Zero-Downtime Migration tool
      2. Migrating on-premises database to Autonomous Database using ZDM
      3. Implementing migration to Autonomous Database using ZDM
      4. Installing and configuring ZDM software on a dedicated host
      5. Target Autonomous Database creation
      6. Generating an OCI API key pair in the pem format
      7. Installing the OCI CLI
      8. Preparing an SSH key pair
      9. Creating an Object Store bucket
      10. Creating an OCI user authentication token
      11. Keeping the same time zone
      12. Database character set
      13. Setting up the GoldenGate Microservices hub in the OCI marketplace
      14. Setting up the OCI CLI in the source database server for file transfer
      15. Preparing a ZDM response file for migration
      16. A dry run of ZDM
      17. Run the migration job
    2. Summary
    3. Questions
    4. Answers
  11. Chapter 4: ADB Disaster Protection with Autonomous Data Guard
    1. Overview and associated terminologies
    2. AuDG
      1. Local standby
      2. Remote standby (cross-region standby)
    3. Associated specifications in AuDG
      1. Region and roles specification
      2. RTO and RPO in an AuDG configuration
      3. Status and operation in AuDG
    4. Implementing AuDG
      1. Enabling AuDG
      2. Performing a manual switchover operation – local standby
      3. Performing a manual switchover operation – remote standby
      4. Disabling AuDG
      5. Leveraging OCI Events Service for AuDG operations
      6. Points to remember about AuDG
    5. Summary
    6. Questions
    7. Answers
    8. Further reading:
  12. Chapter 5: Backup and Restore with Autonomous Database in OCI
    1. Technical requirements
    2. Understanding the backup types
      1. Working with automated backup in the OCI portal
      2. Learning how to take a manual backup
    3. Restoring database backups
    4. Manual database backup using Data Pump
      1. Creating a dump set
      2. Creating a Data Pump backup directly to object storage
      3. Data Pump import backup
      4. Refreshing Autonomous Database schemas
      5. Database links between autonomous databases
    5. Summary
    6. Questions
    7. Further reading
    8. Answers
  13. Chapter 6: Managing Autonomous Databases
    1. Technical requirements
    2. Autonomous database actions
    3. Starting or stopping an autonomous database
    4. Autonomous database connection
    5. Performance Hub
      1. ASH Analytics
      2. SQL monitoring
      3. Workload
      4. Blocking Sessions
    6. Scale Up/Down
    7. Cloning
      1. Updated Network Access
      2. Access control list
      3. Administrator password
      4. Updating the license type
      5. Renaming a database
      6. Move Resource
      7. The service console
      8. Changing the workload type
      9. Enabling Operations Insights
      10. Terminate
      11. Registering autonomous databases with Oracle Data Safe
      12. Security Assessment
    8. Summary
  14. Part 3 – Security and Compliance with Autonomous Database
  15. Chapter 7: Security Features in Autonomous Database
    1. Operating system access restriction
      1. Dedicated ADMIN users for the database
      2. Private endpoint
      3. NSG
    2. Data Safe
    3. Security Assessment
      1. User Assessment
    4. Data Discovery
    5. Data Masking
    6. Activity Auditing
    7. Data encryption
      1. Encryption of data at rest
      2. Encryption of data in transit
      3. Database backup encryption
      4. Access control lists
      5. SQL*Net Connection
      6. SQL command restrictions
      7. Automatic security patch update
    8. Summary
    9. FAQs
  16. Index
    1. Why subscribe?
  17. Other Books You May Enjoy
    1. Packt is searching for authors like you
    2. Share Your Thoughts
    3. Download a free PDF copy of this book

Product information

  • Title: Oracle Autonomous Database in Enterprise Architecture
  • Author(s): Bal Mukund Sharma, Krishnakumar KM, Rashmi Panda
  • Release date: December 2022
  • Publisher(s): Packt Publishing
  • ISBN: 9781801072243