Oracle Autonomous Database

 

Oracle Autonomous Database

 

Completed Database Automation

• ·        Provisioning
• ·        Scale-up and Scale-out
• ·         Tuning
• ·         Security and Patching
• ·         Fault Tolerance

 

Uses Machine Learning plus advanced and Proven Technologies.

• ·         RAC
• ·         Dataguard
• ·         Database Vault
• ·         Parallel SQL
• ·         In-Memory
• ·         Multitenant

 

Mission Critical, Simple, Low Risk, Low Cost

DEPLOYMENT OPTIONS

·         SHARED Exadata Infrastructure (Get Results Fast)

·         Dedicated Exadata Infrastructure (Rethink IT) -exclusive Hardware

Autonomous Database: SHARED Infrastructure

Primary Goals (Benefits)

Easy :-

• ·         Oracle Automates and Manages Everything.
• ·         Deployment, life cycle, software updates etc.
• ·         Customer simply chooses database compute, storage, and region.

Elastic:-

• ·         Low Minimum Size – 1 OCPU
• ·         Low Minimum time commitment – 1 hour
• ·         Automatically scales Online for true pay-per use

 

Autonomous Database: - Dedicated Infrastructure

Primary Goals (Benefits)

Provides your own Database cloud running on dedicated Exadata Infrastructure

Runs all your databases- any size, scale, or criticality.

Customizable Isolation

·         Isolates workloads using separate Exadata Machines, Virtual Machines or Container Databases.

Customizable Operational Policies

·         Control provisioning, updates, availability, and density.

Oracle Autonomous Database -What and How ?

 

1.      Provision à Rapidly and easily creates Mission-critical databases.

-         Creates Exadata (cloud Infrastructure)

-         RAC (scale-out databases)

-         Active Data Guard standby

2.      Secure -> Protects data from all external and internal threats

-         Apply security updates online,

-         Prevents admin snooping with DB Vault

-         Encrypts all data.

3.      Manage – Automates all Infrastructure and all database Maintenance

-         Patches all software online

-         Tunes settings

-         Performs all OS and SYSDBA operations

-         Diagnoses errors

4.      Protect- Recoers froms any failure without downtime

-         Autmates backup,restore,application transparent failover within cluster or to remote standby.

5.      Secure – Scales online for highest performance and lowest cost

-         Instant,automatic,online scaling of compute and storage enables true pay-per-use

-         Optimize -Optimally runs workloads without human direction.

-         Automatically optimizes,data formats ,indexes, parallelism and plans for each workload.

6.      Optimize – Optimally runs workloads without human direction

Automatically optimizes,data formats,indexes,parallelism and plans for each workload

 

 

 

Autonomous Database Dedicated -Primary Benefits

Dedicated Network Architecture

Autonomous Database -Cloud @customer Primary Benefits

Autonomous DB feature Comparison

Managing and maintaining Autonomous Database

Connecting to Autonomous Database

 

 

Autonomous Database – REST APIs

Autonomous Database -Using OCI-CLI

Autonomous Database -Using OCI-CLI Requirements

 

Autonomous Database -Auto-Index Creation is Inherently Better

Automatic Indexing

Oracle Data Safe

Security Zones of control

Autonomous Database Tools (Development Environment)

 

 

OPTIONS AND CONSIDERATIONS FOR MIGRATING TO ADB’s

Migration to Autonomous Database

Autonomous Migration Methods Overview

Autonomouns :- Database Migration Service