Oracle Autonomous Database Workshop
1. Autonomous Database Technical Overview
---Oracle Cloud Infrastructure
OCI Region - HA Building Blocks, Availability Domain(AD)
Fast and Scalable Bare Metal, VM, and GPU compute
Cluster Networking
Consistant Performance Storage
IoT, ADB, AI/ML, Analytics, Mobile Apps, Colud Native Architectures
---ADB Overview
ADB Revolutionizes data management
Innovate faster with lower costs
A. Data Warehouse (ADW), A. Transaction Processing (ATP)
---ADB Key Features
Lower cost, reduce risk, accelerates innovation
Simple, Fast, Elastic
Self-driving, Self-securing, Self-repairing
Gathering Satistics and Hints
Capture--identify--verify--decide--monitor
---ADB Architectural Components
Exadata system based on Region,
Oracle controls all patching, software version, and isolation
Low minimum size/cost - 1 OCPU and 1 TB of storage
Low minimum time commitment - 1 hour
OCI integration: Connection Manager services, Application Servicer, Oracle ML servers
Exadata Server, Storage Server
Connection to ADB, access from on-premises to ADB
Oracle ML built-in Notebooks
Oracle Data visualization Desktop
SQL Developer 17.4 or later, wallet using Cloud
Service Console
---typical workflow for using ADB
Load data throguh Amazon S3, Azure Blob Storage, Oracle OCI, Expdp/Impdp, Golden Gate
Application Migration (Ravllo tool for application migration)
2. Provisioning and Connectivity
---connect and navigate the OCI console
OCI services: Compute, Archive Storage, Audit, block volumne Container Engine for Kubernetes
Data Transfer, Datbase, Email Delivery File Storage, IAM, Load Balancing,
Internet Intelligence, Networking, Ojbect Storage, registry, Key management
---Provision an ADB service
---find and Download database credentials
Connect through SQL*Net, JDBC thick, ODBC/Oracle Call Interface, JDBC thin
---Connect to an ADB service
Security credentials wallet to connect
Predefined DB service Names: tpurgent, tp, high, medium, low
3. Migration and Data Loading into Autonomous Database
---Options and considerations for migrating to ADB
Manage DML performance
Consider Network Latency
https://cloudharmony.com/speedtest-for-oracle:storage
---Migrate to ADB using Data Pump
Recommand use schemas method.
Begin
dbms_cloud.create_credential(
credential_name => 'DEF_CRED_NAME',
username => 'adwc_user@oracle.com',
password => 'password'
);
End;
/
expdp sh/sh@orcl \
exclud=index, cluster, indextype, materialized_view, materialized_view_log \
materialized_zonemap, db_link \
data_options=group_partition_table_data \
parallel=16 \
schemas=sh \
dumpfile=export%u.dmp
impdp admin/password@ADW_high \
directory= data_pump_dir \
credential=def_cred_name \
dumpfile=https://swiftobjectsstorage.us-phoenix-1.oraclecloud.com/v1/adwc/adwc_user/export%u.dmp \
paralle=16 \
partition_option=merge \
transform=segment_attributes:n \
transform=dwcs_cvt_iots:y transform=constraint_user_default_index:y \
exclude=index, cluster, indextype, materialized_view, materialized_view_log \
materialized_zonemap, db_link
dbms_cloud.put_object
---Migrate to ADB using Golden Gate
No integert mode supported for ADB at this time.
Date Type limitations for DDL and DML replication
---Load data with Data Sync
---Load data using DBMS_CLOUD
SQL*Loader Parameter for old DB version
readsize=100M
bindszie=100M
direct=N
4. Managing and Maintaining Autonomous Database
---Manage users and suer privileges in ADB
---Start, stop and scale ADB
---Use rest APIs to manage ADB
---Use OCI command line to manage ADB
---Manage ADB backups and Restores
---Explore ADB using SQL Developer
5. Monitoring Autonomous Database
--- Monitor ADB using the OCI service Console
---understanding ADB consumer groups
6. Tools, Reporting and Analytics
---How to use ADW with 3rd party software
---Describe how to build analytic views
---Explain how to use Oracle Machine Learning
---Explain how to install and configure Oracle Analytics cloud and Data Visualization Desktop
--End of File--
Comments
Post a Comment