29 June, 2025

Creating a new PDB in RAC without Standby Protection

 I've published a new Video demonstration when you need to create a new PDB (even as a clone of an existing one) without requiring a Standby copy of the PDB.

(Use cases : Test environment for a day or two, it would take too long to create a new Test Server and clone the database, it would take too long to change Firewall rules to allow Applications to connect to the Test Server)

This in RAC with DataGuard Useful commands : Create new PDB :

CREATE PLUGGABLE DATABASE PRDAPPTST FROM PDB1  STANDBYS=NONE
Create Service :
srvctl add service -db RACDB  -service newtestpdb -preferred RACDB1,RACDB2 -tafpolicy BASIC -failovertype SELECT -clbgoal SHORT -pdb PRDAPPTST
Start Service :
srvctl enable service -db RACDB -service newtestpdb
srvctl status service -db RACDB -service newtestpdb
srvctl start service -db RACDB -service newtestpdb
srvctl status service -db RACDB -service newtestpdb

Always use custom Service Names instead of the default name derived from the PDB Name.

No comments: