In this blog post, I will talk about how you can perform workload routing across the standby databases based on Database role with GDS. GDS provides this functionality without requiring Oracle Clusterware to be installed. But if clusterware is installed then GDS automatically register the global service to GI home. When role transition happens in Data Guard Broker configuration, GDS relocates the global services automatically as per the role attribute. There is no need to write custom logic or database startup triggers to achieve this behavior. Continue reading → Global Data Services (GDS) with Active Data Guard – High Availability
What is Global Data Services??
Oracle 12c Database provides a powerful workload management feature called database services. Database services are named representations of one or more database instances. Database services allow you to group database workloads, ensure that client requests are routed to the optimal instance that offers a service, and provide high availability by transparently failing client connections over to surviving instances when a planned or unplanned instance outage occurs
Oracle Global Data Services (GDS) implements the Oracle Database service model across a set of replicated databases known as a Global Data Services configuration. The GDS is the replacement for the Oracle Grid Infrastructure for 11g database high availability. The GDC works perfectly with Oracle 12c CDB or PDB’s. Continue reading → Global Data Services (GDS) – Set Up
Oracle database backup service is cloud Storage Solution for your Oracle Database Backups. Oracle Database Backup Service provides a low-cost alternative for storing backups in an offsite location. It is an Oracle Public Cloud object-based storage offering that enables you to store your on-premises or cloud-deployed database backups.
If you are familiar with Oracle Recovery Manager (RMAN), it should take only a few minutes for you to start backing up your database to the cloud. Here’s all you need to do:
- Download Oracle Database Cloud Backup Module from OTN Site
- Unzip opc_installer.zip file.
With Oracle Database Cloud Service, you can change the backup destination for your database deployment after creating it. When a database is deployment, it is configured with one of the following backup destinations. I choose None during deployment and now would like to configure backups. Continue reading → Oracle Cloud (DBaaS) – Change the Backup Configuration for Single DB
For Cloud DBaaS instance, Oracle Cloud Service provision a VM and required file systems. Here is the file systems and other database related information.
- /u01 – Local file system – Oracle software binaries, DIAGNOSTIC_DEST
- /u02 – Cloud Storage – Database Files, Change tracking file
- /u03 – Cloud Storage – Fast Recovery Area, backup files, control file copy
- /u04 – Cloud Storage – Redo log files, Temporary files
The “dbaascli” utility is provided on Oracle Database Cloud Service deployments to perform a variety of life-cycle and administration operations. Using the “dbaascli” utility, you can perform operations like: Continue reading → Oracle database Cloud – The dbaascli Utility