RAC

How to Restore 12c RAC Database by a Backup Set

Posted on
For 10g RAC database restoration, you may check: How to Restore 10g RAC Database by a Backup Set. Suppose we have restored 12c clusterware back. Now we can start to restore 12c cluster database. Our goal in this post is to use a backup set on one of RAC nodes to restore the database. First […]
Clusterware

How to Restore 12c Clusterware OCR Voting Disk

Posted on
For 10g clusterware, you may check: How to Restore 10g Clusterware. Suppose we have lost all disk groups as well as OCR data, voting disk and management database (MGMTDB) in a disaster, we have to rebuild 12c clusterware nearly from the ground up for later 12c RAC database restoration. The only thing that you must […]
ACFS

How to Create a ACFS File System on 18c

Posted on
Create ACFS File System First of all, make sure everything is ready on grid-level. [root@primary01 ~]# su – grid [grid@primary01 ~]$ crsctl check crs [grid@primary01 ~]$ crsctl status resource -t Create a Volume In this case, We allocate 80GB for the new volume ORADATA1 from a ASM disk group, DATA. [grid@primary01 ~]$ asmcmd volcreate -G […]
Public IP

How to Change Public IP within Same Subnet of Grid

Posted on
Identify which interface that you should modify[grid@oda0 ~]$ oifcfg getif -globalbond0  10.0.18.0  global  publicibbond0  192.168.2.0  global  cluster_interconnect,asmOK, we found bond0 is the public IP interface.Modify /etc/sysconfig/network-scripts/ifcfg-bond0[root@oda0 ~]$ vi /etc/sysconfig/network-scripts/ifcfg-bond0…IPADDR=10.0.18.5#IPADDR=10.0.18.218…Modify /etc/hosts and DNS[root@oda0 ~]$ vi /etc/hosts…10.0.18.5    oda0 oda0.example.com#10.0.18.218    oda0 oda0.example.comRestart network[root@oda0 ~]$ service network restartYou may lost connection to the console.Restart clusterware stack by […]
RAC

How to Automatically Startup RAC Database after System Reboots

Posted on
After installing grid infrastructure, you will have Oracle Clusterware, also called Cluster Ready Service, CRS controls all Oracle cluster components as resources, and manages the dependencies among resources, so it can coordinate their start and stop priority. Restarting a database server will bring CRS up (ohasd), once CRS is up, CRS will arrange the resources […]