The following pool cleanup operations can be performed by the SSA Admin:
Deactivate the CDB
If there are any issues with the newly activated CDB, the SSA Admin can deactivate them and use the old CDB as their member active CDB for new requests until the time the issue is sorted with the new CDB or they are removed from the pool (given that they do not service any PDB’s)
emcli db_cloud_maintenance -performOperation -purpose="DEACTIVATE_CDB" -pool_name="PDB_POOL" -pool_type="pdbaas_pool" -name="Deactivate the CDBs" -target_type=oracle_database/rac_database -description="Deactivates the newly created CDBs"
This step marks all the new CDBs in the pool that were created in the above step as Passive and their predecessor CDBs as Active. Any further SSA requests will be forwarded to the newly activated CDBs.
emcli db_cloud_maintenance -performOperation -purpose="DEACTIVATE_CDB" -pool_name="PDB_POOL" -pool_type="pdbaas_pool" -name="Deativate the CDBs" -target_type=oracle_database/rac_database -description="Deactivates the newly created CDBs" -target_list=”sales.us.oracle.com”
This step the given CDBs in the target_list as Passive and is predecessor CDBs as Active. Any further SSA requests will be forwarded to the newly activated CDB.
Rollback the PDB
In case the PDB update has any issues with the CDB to which it was updated, the admin (and admin only) can do a rollback of the PDB to the CDB that was the predecessor of the currently active CDB.
emcli db_cloud_maintenance -performOperation -purpose=" ROLLBACK_PDB" -pool_name="PDB_POOL" -pool_type="pdbaas_pool" -name="Activate the CDBs" -target_type= oracle_pdb -description="Rolls back the PDB to its parent CDB"
This step rolls back the PDBs associated with the pool to their respective parent CDBs.
emcli db_cloud_maintenance -performOperation -purpose=" ROLLBACK_PDB" -pool_name="PDB_POOL" -pool_type="pdbaas_pool" -name="Activate the CDBs" -target_type= oracle_pdb -description="Rolls back the PDB to its parent CDB" -target_list=”sales.us.oracle.com_FIN”
This step rolls back the given PDBs in the target_list to their parent CDB.