Instance Recovery and RAC When an instance fails and the failure is detected by another instance, the second instance performs the following recovery steps: During the first phase of recovery, Global Enqueue Services remasters the enqueues. The Global Cache Services (GCS) remasters its resources. The GCS processes remaster only those resources that lose their masters. […]
Beginners Guide to Upgrading and Patching Oracle RAC
Patch and Patch Set: Overview Oracle issues product fixes for its software called patches. They are associated with particular releases and versions of Oracle products. The patching cycle involves downloading patches, applying patches, and verifying the applied patch to ensure that the bug fixes present in the patch reflect appropriately. Patching involves migrating from one […]
How to Modify initialization parameters in a Oracle RAC environment
RAC Initialization Parameter Files When you create the database, Oracle Database creates an SPFILE in the file location that you specify. This location can be either an Oracle ASM disk group or a cluster file system. If you manually create your database, then Oracle recommends that you create an SPFILE from an initialization parameter file […]
Oracle RAC 12c Administration using Enterprise Manager
Enterprise Manager Cloud Control Cluster Database Home Page The Enterprise Manager Cloud Control (EMCC) Cluster Database Home page serves as a crossroad for managing and monitoring all aspects of your RAC database. On this page, you find Summary, Performance, Diagnostics, Compliance, Instances, and Incidents sections for information that pertains to your cluster database as a […]
How to Convert a single-instance Oracle database to RAC
Single Instance–to-RAC Conversion A single-instance Oracle database can be converted using several methods, which include Database Configuration Assistant (DBCA), Enterprise Manager, and the RCONFIG utility. You can use one of these tools based on your needs. Before converting a single-instance database to a RAC database, ensure that your system meets the following conditions: It has […]
How to Install and Configure Oracle RAC 12c
Installing the Oracle Database Software The Oracle Universal Installer (OUI) is used to install the Oracle Database 12c software. Start the OUI by executing the runInstaller command from the root directory of the Oracle Database 12c CD-ROM or from the software staging location. $ /stage/database/runInstaller You can use the Configure Security Updates window to specify […]
How to Create an Oracle Data Guard Broker Configuration
Data Guard Broker: Requirements To use the Data Guard broker, you must comply with the following requirements: Use the Enterprise Edition of Oracle Database. Use a single-instance or multi-instance environment Set the COMPATIBLE initialization parameter to 12.1 to take advantage of new Oracle Database 12c Release 1 (12.1) features. Enterprise Manager automatically configures the Oracle […]
Beginners Guide to Oracle Data Guard Broker
The Oracle Data Guard broker is a distributed management framework. The broker automates and centralizes the creation, maintenance, and monitoring of Data Guard configurations. Oracle Data Guard Broker: Features The following are some of the operations that the broker automates and simplifies: Automated creation of Data Guard configurations incorporating a primary database, a new or […]
Creating a Logical Standby Database by Using Enterprise Manager
To create a logical standby database by using Enterprise Manager: 1. Click Add Standby Database on the Data Guard Overview page to invoke the Add Standby Database Wizard. Note: If the logical standby database is the first database to be created in your configuration, access the Add Standby Database Wizard by clicking “Setup and Manage” […]
Oracle Data Guard: Creating a Logical Standby Database
Benefits of Implementing a Logical Standby Database A logical standby database provides benefits in disaster recovery, high availability, and data protection that are similar to those of a physical standby database. It also provides the following specialized benefits: Efficient utilization of system resources A logical standby database is an open, independent, and active production database. […]