Oracle Database Enterprise Edition High Performance

1 view
Skip to first unread message

In Libman

unread,
Jul 31, 2024, 7:21:05 AM7/31/24
to inovecbrij

Once you've created an OCI account, you must first create a virtual cloud network (VCN) prior to creating your first database. A VCN is a virtual, private network that you set up in Oracle data centers. It closely resembles a traditional network, with firewall rules and specific types of communication gateways that you can choose to use. From there, you can create an Oracle database in a database system using the console, REST APIs, CLI and SDKs.

The service supports Oracle's Universal Credit Model (UCM) with 'license included' and 'bring your own license' (BYOL) pricing. Pricing is flexible, with pay-as-you-go (PAYG) and Oracle Annual Universal Credit options available. Pricing depends on the selected database edition, database shape, number of OCPUs, and storage capacity you choose. Refer to pricing for virtual machines section for more details. Existing metered/non-metered tenancies will be billed under their existing plan until converted to a Universal Credit Model tenancy.

oracle database enterprise edition high performance


Download Filehttps://fenlaekdiaho.blogspot.com/?mu=2zV29N



All editions include Oracle Database Transparent Data Encryption, Oracle Machine Learning, Graph, Spatial, and Oracle APEX. With Oracle Database 23ai, this expands to include AI Vector Search, JSON-relational duality, and other features.

Database systems are available with AMD Standard E5 Flex, Intel X9 Standard 3 Flex, or Ampere Standard A1 Flex shapes. For the latest details on available shapes, refer to About virtual machine database systems in the documentation.

Yes. Two-node Oracle RAC on virtual machines within a virtual cloud network is available. Oracle RAC on virtual machines is configurable by setting the "total number of nodes" as 2 when selecting the options for provisioning a database system.

No. The virtual machines for two-node Oracle RAC are deployed on separate servers and racks within the same availability domain. Storage is shared across both database instances. This setup protects against server failures and rack power failures. For higher availability, it is recommended that you enable Oracle Data Guard with a standby two-node Oracle RAC virtual machine database system in a separate availability domain.

Virtual machine database systems only contain one container database (CDB). However, the container database can have multiple pluggable databases (PDBs). A single CDB with a single PDB is created by default when the virtual machine database system is created. The service offers integrated PDB lifecycle management.

Yes, you can scale the number of OCPUs up and down as required. However, scaling the OCPUs will require changing the virtual machine shape and will result in a database outage. For 2-node RAC virtual machine database systems, the shape is changed one virtual machine at a time in a rolling manner.

Yes. A virtual machine database system uses block volume storage, so you can configure available storage anywhere from 256 GB to 80 TB. You can scale up the storage capacity without downtime. Scaling the storage down requires migrating to a new virtual machine database system.

Yes, you can clone a virtual machine database system that uses either Logical Volume Manager (LVM) or Grid Infrastructure/ASM for storage management software. Cloning a virtual machine database system creates a copy of the source database at the time of the cloning operation, including software and database volumes.

For virtual machine database systems, there are three metering components: OCPU usage and Block Volume storage usage are required. Oracle Database Autonomous Recovery Service and Oracle Cloud Infrastructure (OCI) Object Storage are optional.

Both license-included and bring your own license (BYOL) licensing models are charged based on OCPU usage. OCPU usage per hour is billed based on virtual machine database system shape. Each partial OCPU hour consumed is billed as partial hour with a one-minute minimum.

Virtual machine database systems use remote block volume storage. You can attach up to 100 TB total storage which consists of up to 80 TB for data storage and up to 20 TB for recovery storage. You pay for the total storage. You can choose block storage volumes with either higher performance or balanced performance. Block storage volumes with higher performance is defined as 1 unit of block volume storage with 20 units of block volume performance per gigabyte per month. Block storage volumes with balanced performance is defined as 1 unit of block volume storage with 10 units of block volume performance per gigabyte per month.

You can use the backup/restore feature to configure backups for your databases to Database Autonomous Recovery Service or OCI Object Storage. The billing for the backups is based on the total amount of storage in use.

Yes. Stop billing is supported on virtual machine database systems. To take advantage of this capability, go to the virtual machine database system and select the desired node to stop. The database remains intact while the node is stopped. You are not billed for hours the node is not running.

A VCN is a customizable private network in OCI. Just like a traditional data center network, a VCN provides you with complete control over your network environment. This includes assigning your own private IP address space, creating subnets, creating routing tables and configuring stateful firewalls. A single tenant can have multiple VCNs, which will provide grouping and isolation of related resources.

We highly recommend that you create separate subnets in each availability domain and place your database systems in those subnets. This allows you to precisely define inbound/outbound security lists for the subnet and control network access.

Database systems are configured with TDE by default during provisioning. Refer to the TDE FAQ for more details regarding TDE. You also have the flexibility to log in and control other security policies on the database system.

With Oracle Identity and Access Management (IAM), you can configure your cloud environment to support your security and compliance requirements. From a database perspective, you configure IAM policies that allow you to restrict access to database systems only to a select set of users (DBAs). Refer to the documentation on how to use Oracle IAM.

Yes. With full root access to the database system you can configure auditing for all operations on the database system. The service provides robust audit support in all editions of the database. Audit records include information about the operation that was audited, the user performing the operation, and the date and time of the operation. Audit records can be stored in the database audit trail or in files on the operating system. Standard auditing includes operations on privileges, schemas, objects, and statements. In addition, you can use OCI Audit to audit all the API management calls that were made on your tenancy.

The updating feature simplifies the steps required to update your database systems and databases. You can use the OCI console and APIs to view applicable updates for your database system or database and submit an updating request. The service will then run the end-to-end updating steps while displaying the status. You can view all updates that have been applied, and if required, rollback or reapply an update. In addition, you can use Oracle Identity and Access Management (IAM) controls to manage access to updating features.

Service-specific updates for database systems and databases can be applied. Database systems have only the latest update available. Databases have both the latest update as well as older database updates available. You can find the list of currently available database system and database updates in Update a database system.

Use custom database software images to apply interim updates or one-offs. We recommend that you do not apply on-premises quarterly bundle updates using the OPatch utility. These updates may not work without applying additional cloud specific updates. Instead, you should apply cloud-customized quarterly updates that are available through the Oracle Cloud Infrastructure console and REST APIs.

Yes. There will be downtime for 1-node virtual machine database systems. 2-node RAC virtual machine database system updating is rolling, 1-node at a time. You can also configure Oracle Data Guard to minimize downtime. Follow the Maximum Availability Architecture (MAA) best practices.

Yes, your database system should be on the same or higher version than your database. To avoid version conflicts, you should apply database system updates first, followed by database updates. If you do not follow this order, you will get an error message while applying the update.

Yes. Oracle Database bundle updates and database system database updates are different. Database system database updates are a superset containing Oracle Database bundle updates and OCI updates, along with other updates.

OS updates are currently not supported through the OCI console or APIs using the patching feature. You must access the host directly to manually update the OS through the command line. Refer to the documentation for virtual machine database system OS updates.

Oracle Database Autonomous Recovery Service and Oracle Cloud Infrastructure (OCI) Object Storage can be used as backup destinations. Refer to Recovery Service Concepts and OCI Object Storage Overview for more details.

Autonomous Recovery Service provides an optimized policy-driven automatic backup and recovery solution. Zero Data Loss Autonomous Recovery Service is an optional feature for Autonomous Recovery Service that offers real-time data protection to protect databases with zero data loss recovery in the event of a database failure. Real-time Data Protection is the continuous transfer of redo changes from a protected database to Autonomous Recovery Service. This feature reduces data loss and provides an RPO near 0. Since the real-time data protection feature is an extra-cost option, you can choose to enable or disable it when you are configuring automatic database backups.

93ddb68554
Reply all
Reply to author
Forward
0 new messages