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