Oct 14 2019

Oracle 19c R3 Active Data Guard Installation on Oracle Linux 7.7

Category: DatabasesFatih Acar @ 10:49

Oracle Data Guard ensures high availability, data protection, and disaster recovery for enterprise data. Oracle Data Guard provides a comprehensive set of services that create, maintain, manage, and monitor one or more standby databases to enable production Oracle databases to survive disasters and data corruptions. Oracle Data Guard maintains these standby databases as copies of the production database.Then, if the production database becomes unavailable because of a planned or an unplanned outage, Oracle Data Guard can switch any standby database to the production role, minimizing the downtime associated with the outage. Oracle Data Guard can be used with traditional backup, restoration, and cluster techniques to provide a high level of data protection and data availability.

With Oracle Data Guard, administrators can optionally improve production database performance by offloading resource-intensive backup and reporting operations to standby systems.

Types of standby databases are Physical standby database, Logical standby database and Snapshot standby database.

I will demonstrate Physical standby database as working real time apply at this document. Most used type is Physical standby database type. You can investigate other types of standby database from Oracle docs.

I used Oracle RAC database as primary side and I used single instance database with asm file system as secondary side (Data Guard).

Firstly, you have to adjust system parameters of operating system on secondary side and create asm disks. After, you can start to install of grid infrastructure. You can create disk groups for DATA and FRA disk groups after install grid. After grid installation, you can install Oracle Data Guard database on grid infrastructure and ASM disks as software only. Finally you can configure parameter and listeners on both sides and start apply. I divide the stages of installation four steps.

You can find primary side (Oracle 19c R3 RAC) installation steps here. I will use this infrastructure as primary side.

First Step : Configure Operation System on Standby Server

1. Upgrade All Packages

yum upgrade

Continue reading “Oracle 19c R3 Active Data Guard Installation on Oracle Linux 7.7”

274 total views, no views today

Tags: Oracle 19c, Oracle 19c Data Guard, Oracle Administration


Oct 11 2019

Oracle 19c R3 Real Application Clusters (RAC) Installation Steps on Oracle Linux 7.7

Category: AdministrationFatih Acar @ 11:07

Oracle Real Application Clusters (RAC) provides high availability (HA) and scalability to the Oracle Database without requiring any application changes. Oracle RAC allows multiple instances running on different servers to access the same physical database stored on shared storage. Database spans multiple hardware systems and yet appears as a single unified database to the application. This enables utilization of commodity hardware to reduce total cost of ownership and to provide a scalable computing environment that supports various application workloads.

Top Benefits of Real Application Clusters (RAC)

  • Ability to spread CPU load across multiple servers
  • Continuous Availability / High Availability (HA)

– Protection from single instance failures

– Protection from single server failures

  • RAC can take advantage of larger SGA sizes than can be accommodated by a single instance commodity server
  • Scalability

I will use VMware virtualization to servers. You can add disk for oracle asm storage with different iscsi driver. You have to adjust iscsi driver as virtual.

Oracle 19c RAC installation steps are a bit long. Firstly, you have to adjust system parameters of operating system on both node and create asm disks. After, you can start to install of grid infrastructure. You can create disk groups for DATA and FRA disk groups after install grid. Finally you can install Oracle RAC database on grid infrastructure and ASM disks. I divide the stages of installation three steps.

First Step : Configure Operation System on Both Servers

1. Upgrade All Packages

yum upgrade

Continue reading “Oracle 19c R3 Real Application Clusters (RAC) Installation Steps on Oracle Linux 7.7”

320 total views, no views today

Tags: Oracle, Oracle 19c, Oracle 19c RAC, Oracle Administration, Oracle RAC