Tuesday, November 30, 2021

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