Quick Overview of Cloud Database
About Oracle Database Cloud Service
When you create a database deployment, Database Cloud Service creates compute nodes to host the database, using computing, storage and networking resources provided by various Oracle Cloud infrastructure services
Two service levels are available
Oracle Database Cloud Service - Virtual Image
Oracle Database Cloud Service
Oracle Database Cloud Service - Virtual Image
· A compute environment with pre-installed virtual machine images that include all software needed to create and run an Oracle Database You connect to the virtual machine and run the Oracle (DBCA) to create your database. All subsequent maintenance operations, including backup, patching and upgrades, are performed by you.
· Install this software yourself.
· Responsible for all maintenance operations for this software.
· Provided root privilege, so you can load and run software in the compute environment.
· Full administrative privileges for the Oracle database.
Oracle Database Cloud Service
· Everything in Virtual Image, plus a database created according to specifications you provide in the Create Service wizard, plus cloud tooling that provides automatic and on-demand backups, patching and upgrading, and point-in-time recovery for your Oracle Databases.
· Includes Oracle Database and supporting software.
· Software is installed for you, an Oracle database is created using values you provide when creating the database deployment, and the database is started.
· You can direct Database Cloud Service to set up automatic backups.
· Deployment includes cloud tooling that simplifies backup, recovery, patching and upgrade operations. Provided root privilege, so you can load and run software in the compute environment.
· Full administrative privileges for the Oracle database.
· End User responsible for recovery operations in the event of a failure.
· Database Cloud Service relies on an underlying component of Oracle Cloud named Platform Service Manager (PSM) to provide its service console and its REST API.
· (PSM) component of Oracle Cloud uses SSH to access the compute nodes that comprise your database deployments, to perform predefined Platform Service actions like backup and patching.
Cloud Tooling for Database Cloud Service
Database Cloud Service offers the following tools on the compute nodes associated with the Oracle
Database Cloud Service service level:
Simple Automated Backups: use the bkup_api utility (raccli on deployments that use Oracle RAC) to perform on-demand backups and to change how automatic backups are configured.
Simple Automated Recovery: use the orec subcommand of the dbaascli utility to restore from backups.
Simple Automated Patching: use the dbpatchm subcommand of the dbaascli utility to apply
patches.
New DBaaS Monitor: use the Oracle DBaaS Monitor web application to monitor the Oracle database and computing resources
Note: Oracle DBaaS Monitor is not available on deployments that use Oracle Real Application Clusters
Metering Frequency
Hourly: Pay only for the number of hours used during your billing period.
Monthly: Pay one price for the full month irrespective of the number of hours used.
Oracle Database Software Release
When creating a database deployment on Oracle Database Cloud Service, you choose one of the following Oracle Database software releases:
• Oracle Database 11g R2
• Oracle Database 12c R1
• Oracle Database 12c R2
Note: Oracle Database 12c R2 (12.2) is not available at the Oracle Database Cloud Service - Virtual Image service level
Oracle Database Software Edition
When creating a database deployment on Oracle Database Cloud Service, you choose one of the following Oracle Database software editions.
Standard Edition: It delivers unprecedented ease of use, power, and performance for workgroup, department level, and Web applications, includes all the facilities necessary to build business-critical applications.
Enterprise Edition: which provides the performance, availability, scalability, and security required for mission-critical applications such as high-volume online transaction processing (OLTP) applications, query-intensive data warehouses, and demanding Internet applications.
Enterprise Edition - High Performance: provides all the features of EE, plus many of the available Oracle Database options and management packs.
Enterprise Edition - Extreme Performance: provides all the features EE, plus all of the Oracle Database options and management packs appropriate for use in Oracle Database Cloud Service.
Oracle Database Type
Single Instance: A single Oracle Database instance and database data store hosted on one compute node.
Database Clustering with RAC: A two-node clustered database using Oracle RAC technology, two compute nodes each host an Oracle Database instance, and the two instances access the same shared database data store.
Single Instance with Data Guard Standby: Two single-instance databases, one acting as the primary database and one acting as the standby database in an Oracle Data Guard configuration.
Database Clustering with RAC and Data Guard Standby: Two two-node Oracle RAC databases, one acting as the primary database and one acting as the standby database in an Oracle Data Guard configuration.
Data Guard Standby for Hybrid DR: Single-instance database acting as the standby database in an Oracle Data Guard configuration. The primary database is on your own system.
(Not available on Oracle Cloud at Customer and Oracle Cloud Infrastructure).
Not all types are available with all combinations of service level and software edition:
· Single Instance is the only type supported by the Oracle Database Cloud Service - Virtual Image service level.
· Single Instance is the only type supported by the Standard Edition software edition.
· The two types that use Oracle RAC are available only with Enterprise Edition - Extreme Performance software edition.
Computing Power
When creating a database deployment on Oracle Database Cloud Service, you choose the computing power for the associated compute node or nodes from a list of supported OCPU (Oracle CPU) and processor RAM combinations. The combinations you can choose from depends on the infrastructure you are creating the deployment in:
In Oracle Cloud Infrastructure:
· VM.Standard1.1 - 1.0 OCPU, 7.0 GB RAM
· VM.Standard1.2 - 2.0 OCPU, 14.0 GB RAM
· VM.Standard1.4 - 4.0 OCPU, 28.0 GB RAM
· VM.Standard1.8 - 8.0 OCPU, 56.0 GB RAM
· VM.Standard1.16 - 16.0 OCPU, 112.0 GB RAM
· BM.Standard1.32 - 36.0 OCPU, 256.0 GB RAM
In Oracle Cloud Infrastructure Classic:
· General Purpose:
· OC3 - 1 OCPU, 7.5 GB RAM
· OC4 - 2 OCPU, 15 GB RAM
· OC5 - 4 OCPU, 30 GB RAM
· OC6 - 8 OCPU, 60 GB RAM
· OC7 - 16 OCPU, 120 GB RAM
High Memory:
· OC1M - 1 OCPU, 15 GB RAM
· OC2M - 2 OCPU, 30 GB RAM
· OC3M - 4 OCPU, 60 GB RAM
· OC4M - 8 OCPU, 120 GB RAM
· OC5M - 16 OCPU, 240 GB RAM
Database Storage
When creating a database deployment on Oracle Database Cloud Service, you choose the amount of usable data storage you want for your database. You can create a database of up to 1200 GB with backups to both cloud and local storage or up to 2048 GB (2 TB) with backups to cloud storage only or no backups.
After you create the database deployment, you can add more data storage as needed and create much larger databases.
In Oracle Cloud Infrastructure Classic, which supports 5 scale-up operations, you can create a database of up to 4.7 TB with backups to both cloud and local storage or up to 10 TB (7.7 TB in Oracle RAC deployments) with backups to cloud storage only or no backups.
In Oracle Cloud Infrastructure, which supports 26 scale-up operations, you can create a database of up to 19 TB with backups to both cloud and local storage or up to 48 TB with backups to cloud storage only or no backups. However, if you need databases of such large sizes, you should consider using Oracle Database Exadata Cloud Service instead of Oracle Database Cloud Service.
Automatic Backup Configuration
When creating a new database deployment on Oracle Database Cloud Service, you choose whether you want automatic backups to be configured for the database. Your choices are:
Both Cloud Storage and Local Storage: 30 days worth of backups are kept, with the 7 most recent days' worth available directly on the compute node’s local storage.
Cloud Storage Only: 30 days worth of backups are kept, with all backups on cloud storage.
None: Automatic backups are not configured.
If you choose either of the cloud storage options, you must specify a cloud storage location:
· For deployments in OCI, specify an existing OCI Object Storage bucket.
· For deployments in OCI Classic, specify an existing OCI Object Storage Classic container or create one as part of the database deployment creation.
·
Reference: Oracle® Cloud Administering Oracle Database Cloud Service E48368-49
Subscribe to:
Post Comments
(
Atom
)
No comments :
Post a Comment