This post is the First video of a Multi-Part Video Series on “Oracle Autonomous Database Cloud for DBAs & APPS DBAs”. Show
This post also helps you to clear Autonomous Database Certification 1Z0-931, In this post, I will be covering Overview of Autonomous Database, Types of Autonomous database (Autonomous data warehouse & Autonomous Transaction Processing) and Autonomous offering as Serverless & Dedicated Infrastructure. Note: Know more about Oracle Autonomous Database Cloud Certified Specialist [1Z0-931]. Note: This post is part of Video series of Roles and Responsibility or Tasks of DBA, if you haven’t seen my previous post then click on the link to watch the previous video post here What is Autonomous DatabaseOracle Autonomous Database is a combination of Exadata with database and Infrastructure Automation running on Oracle Gen 2 Cloud i.e Oracle Cloud Infrastructure (OCI). It is a Cloud database that uses machine learning to automate database tuning, security, backups, updates, and other routine management tasks traditionally performed by database administrators (DBAs). It is self-driving, self-securing, self-repairing database service.
Why Autonomous Database is beneficial to you?
Note: Know more about backup of databases. Types of Autonomous DatabaseWhen you configure the database system on the basis of workload, Oracle Autonomous Database is categorized into two types as Autonomous Data Warehouse (ADW) and Autonomous Transaction Processing (ATP)
1. Autonomous Data Warehouse (ADW)Autonomous Data Warehouse is a fully managed database tuned and optimized for data warehouse workloads with the market-leading performance of Oracle Database. It is Easy, Fast and Elastic scaling of compute and storage, without downtime. Autonomous Data Warehouse uses the same Oracle Database software and technology that runs your existing on-premises workloads. Check out this for more details information on Autonomous Data warehouse (ADW).  2. Autonomous Transaction Processing (ATP)The Autonomous Transaction Processing (ATP) workload type configures the database for a transactional workload, with a bias towards high volumes of random data access. eg: Transactions, Batch, Reporting, Machine Learning etc. Autonomous Deployment Options:Oracle Autonomous Database offers two deployment options Serverless or Dedicated.
1. Serverless Oracle Autonomous DB is Ultra-Simple and Elastic. In Serverless you don’t know where is the Exadata server present this means you don’t own the infrastructure. With this option, you simply select what type of database you want (Data Warehouse or Transaction Processing), which region in the Oracle Cloud you want the database deployed, and the base compute and storage resources and then Oracle automatically takes care of everything for you. 2. Autonomous Database Dedicated is Customizable Private Cloud in Public Cloud. You can customize the software update/patching policy etc. With Autonomous Database Dedicated, you get your own Exadata infrastructure in the Oracle Cloud also you can simply specify the size, region and availability domain where you want your dedicated Exadata infrastructure provisioned. Stay tuned for my next blog in which I’ll be covering Autonomous Database for WHO & WHY? How To Provision Database on Oracle Cloud1) Register & Log into the Oracle Cloud account, click here Note: First, you should have an Account at Oracle Cloud and if you don’t have one, then you can register FREE using my step-by-step video & guide. You can get it by visiting here 2) Click on the hamburger menu, and Under ‘Database’, you will get the option to provision DB. For Autonomous Database, click on ‘Autonomous (ADW & ATP),’ & the other two for User-managed database Bare Metal, VM & Exadata Note: To know further step to provision Autonomous database click here Note: To know how to provision VMDB system click here Related/References
Next Task For YouIf you want to upgrade your career from an Oracle DBA to Oracle Cloud DBA, and wants to clear Oracle Cloud Database Service Specialist[1Z0-1093-21] & Oracle Cloud Autonomous Database Certification[1Z0-931-21] with 18 Hands-On labs, then register for a FREE class, and don’t miss an opportunity to gain a plethora of insights on becoming a certified Oracle Cloud DBA. Which are the three types of autonomous database you can deploy?According to Oracle, the Oracle Cloud Infrastructure's Autonomous Database (ADB) is a fully-managed, preconfigured database environment with three workload types available; Autonomous Transaction Processing, Autonomous Data Warehouse and Autonomous JSON Database.
Which three types of DB systems can you deploy on Oracle cloud infrastructure?Oracle offers the following managed database services running in Oracle Cloud Infrastructure: Oracle Exadata Cloud Service. Oracle Cloud Infrastructure Database. Oracle Database Cloud Service.
What are the 3 key capabilities of the autonomous database?Automatic encryption for the entire database, backups and all network connections. No access to OS or admin privileges prevents phishing attacks. Protects the system from both cloud operations and any malicious internal users. Automatic daily backup of database or on-demand.
Which deployment choices are available in autonomous database?Oracle Autonomous Database can be deployed in 2 ways – dedicated and serverless.
|
