The most important part of FSDR are the machines itself. Oracle OCI has a restriction, that there is no possibility to add Oracle Standard Edition machine to FSDR stack. There are 2 ways to overcome this restriction.
We can create primary and standby machines as compute instance, install Oracle Database software there and add these machines to FSDR.
Or we can use the prebuilt Oracle Standard Edition Database machine types. We will create 2 machines - primary and standby. We will drop the database on the standby machine. These won’t be added to the FSDR stack due to FSDR restrictions. Next to these machines we have to create one compute instance, which will be used only for FSDR purposes. This compute instance will be registerd as member of FSDR groups and this instance will run the Switchover and Failover scripts through ssh.
Create Primary Database Machine
To create the database machines, press Top left menu, then Oracle Database and click on the Oracle Base Database Service.
Click Create DB System:
Fill in following things:
Compartment
Name of the Machine
Availability Domain
Shape of the Machine
Standard Oracle Database Edition
Define a method for access. Either create new keys, upload your own key, or paste the public key
Choose the VCN - Virtual Cloud Network
Select either public or private interface. If you are going to login from internet, choose the public one
Enter prefix of the machine network name
Press Next
In the Database Creation Menu:
Fill in the desired Database Name
Choose a password for sys user. Hint: #1mpoSSible_Pssw0rd
Disable database backups, if the machine is only for testing purposes
Press Create DB System
Create Standby Database Machine
Repeat the same steps as for Primary Machine. Make sure you choose different OCI region or availability domain for the standby database machine if you want a real DR solution.
Also please enter the same database name during standby database machine creation.
New DB unique name will be issued. Remember to note this down.
Create Compute Instance Machine
Press the Top Left menu and choose Compute and then Instances:
Press the Create instance button:
In the instance Creation Menu, choose following things:
Name: Control Center - since this instance won’t be used at all, we will use it as a Control Center (GUI) for Dbvisit Management
Choose correct Compartment
Choose desired placement of the instance
Choose shape with the lowest costs
Select correct VCN
Assign Public interface to the machine
Define how to upload ssh key for further ssh access
Let Live Migration set
Press Create Instance
Now that we have all the machines involved in the FSDR stack, we need to make custom adjustments to them.