Renaming an Oracle RAC cluster is not an easy thing, unfortunately for me I had to do this today because the name chosen for the newly installed cluster was wrong.
Oracle does not provide a simple command to do this and you have to go through a deconfiguration/reconfiguration of the whole cluster.
Continue reading Renaming a RAC cluster →
Stopping all RAC databases running on an ORACLE_HOME at once and saving the state before shutting them down is really helpfull when you are doing patching on a server.
In my case I have databases running on some nodes and not the others, it’s getting complicated to keep track of which database is running where. With this method you will shutdown all databases at once and keep track of the databases running on that node before shutting them down.
Stopping all RAC databases of an ORACLE_HOME
This command will stop all databases running on the ORACLE_HOME specified and save the state before the shutdown in a state file.
srvctl stop home -oraclehome /opt/oracle/base/product/12.1.0/dbhome_1 -node node1 -statefile /tmp/node1_stop.dmp
Starting all RAC databases of an ORACLE_HOME
This command uses a state file to restart all databases previously running on a node.
srvctl start home -oraclehome /opt/oracle/base/product/12.1.0/dbhome_1 -node node1 -statefile /tmp/node1_stop.dmp
About ACFS filesystem
ACFS mean Automatic Storage Management Cluster File System. This filesystem volume resides inside the ASM database and can be used to store database files but also any type of files with or without direct relation to the database.
Oracle ACFS does not support Oracle Grid Infrastructure or Oracle Cluster Registry voting files.
The ACFS filesystem can be extended dynamically without any service interruption, you just need to add space to the diskgroup hosting the ACFS volume and then extend the filesystem. Continue reading Creating an ACFS filesystem →