Installing Oracle 19c RAC on VirtualBox – silent installation – Part 4

With a working 19c Grid Infrastructure cluster, the only remaining tasks left are installing the database software and creating a database.

Part 1 – https://balazspapp.wordpress.com/2020/04/05/installing-oracle-19c-rac-on-virtualbox-silent-installation-part-1/
Part 2 – https://balazspapp.wordpress.com/2020/04/05/installing-oracle-19c-rac-on-virtualbox-silent-installation-part-2/
Part 3 – https://balazspapp.wordpress.com/2020/04/05/installing-oracle-19c-rac-on-virtualbox-silent-installation-part-3/
Part 4 – https://balazspapp.wordpress.com/2020/04/05/installing-oracle-19c-rac-on-virtualbox-silent-installation-part-4/

Installing Oracle 19c RAC on VirtualBox – silent installation – Part 3

After setting up the virtual machines, time has come for installing Grid Infrastructure.

Part 1 – https://balazspapp.wordpress.com/2020/04/05/installing-oracle-19c-rac-on-virtualbox-silent-installation-part-1/
Part 2 – https://balazspapp.wordpress.com/2020/04/05/installing-oracle-19c-rac-on-virtualbox-silent-installation-part-2/
Part 3 – https://balazspapp.wordpress.com/2020/04/05/installing-oracle-19c-rac-on-virtualbox-silent-installation-part-3/
Part 4 – https://balazspapp.wordpress.com/2020/04/05/installing-oracle-19c-rac-on-virtualbox-silent-installation-part-4/

Installing Oracle 19c RAC on VirtualBox – silent installation – Part 2

This part covers preparing the operating system for installation, configuring shared storage and DNS.

Part 1 – https://balazspapp.wordpress.com/2020/04/05/installing-oracle-19c-rac-on-virtualbox-silent-installation-part-1/
Part 2 – https://balazspapp.wordpress.com/2020/04/05/installing-oracle-19c-rac-on-virtualbox-silent-installation-part-2/
Part 3 – https://balazspapp.wordpress.com/2020/04/05/installing-oracle-19c-rac-on-virtualbox-silent-installation-part-3/
Part 4 – https://balazspapp.wordpress.com/2020/04/05/installing-oracle-19c-rac-on-virtualbox-silent-installation-part-4/

Installing Oracle 19c RAC on VirtualBox – silent installation – Part 1

Installing Oracle RAC can be quite a challenge for people new to Oracle databases because of the extra infrastructural requirements.
So here is a walkthrough for installing a 2-node Oracle RAC on a standard cluster, using VirtualBox (Oracle Linux 7 as guests), for “educational purposes”. Keep in mind, this is just a sandbox environment, so I kept the steps simple. In a real environment, we need to do better than here.
Some basic knowledge of Linux administration, networking and VirtualBox is required.
I prefer using the commandline for such installations (because it is much simpler to document the steps this way, instead of using screenshots), so prepare to see a lot of commands and their outputs, but no pictures at all.

Part 1 – https://balazspapp.wordpress.com/2020/04/05/installing-oracle-19c-rac-on-virtualbox-silent-installation-part-1/
Part 2 – https://balazspapp.wordpress.com/2020/04/05/installing-oracle-19c-rac-on-virtualbox-silent-installation-part-2/
Part 3 – https://balazspapp.wordpress.com/2020/04/05/installing-oracle-19c-rac-on-virtualbox-silent-installation-part-3/
Part 4 – https://balazspapp.wordpress.com/2020/04/05/installing-oracle-19c-rac-on-virtualbox-silent-installation-part-4/

Oracle Database 18c – Read-Only Oracle Homes

Starting with Oracle Database 18c, an Oracle home can be configured in read only mode. In such homes, configuration and log files are located outside the Oracle home.

18c Data Guard NOLOGGING options – Part 2: NOLOGGING FOR DATA AVAILABILITY

In Part 1, I saw that the NOLOGGING FOR DATA AVAILABILITY option worked as expected.

18c Data Guard NOLOGGING options – Part 1: Introduction

In versions before 18c, when configuring Data Guard, the only option we had for the logging property of the databases other than the default, was enabling FORCE LOGGING as:

ALTER DATABASE FORCE LOGGING;

Starting with 18c, we have the following new options:

ALTER DATABASE SET STANDBY NOLOGGING FOR DATA AVAILABILITY;

or

ALTER DATABASE SET STANDBY NOLOGGING FOR LOAD PERFORMANCE;

You may not run MultiNode RAC because it is not supported or certified

So I have a perfectly working 2-node cluster:

Oracle 18.2 RU install

The patch number for Oracle 18.2 is 27676517.

Oracle 18c – RECOVER STANDBY DATABASE FROM SERVICE

Oracle 12c introduced a RMAN feature: RECOVER/RESTORE … FROM SERVICE. When rolling forward a standby database, this involved the below steps on the standby database: