Issue :
OCI Restore fails during Recreate Controlfile step while adding tempfile to PDB
SYMPTOMS :
Create new DB System from backup fails duringย Recreate Controlfile script execution.
Reason :
In DCS Agent Debug log, we can see more details about the error. Specifically, it errors out while trying to add tempfile to a PDB:
ALTER SESSION SET CONTAINER = PDBXXXX ;
Session altered.
ALTER TABLESPACE TEMP ADD TEMPFILE
*
ERROR at line 1:
ORA-65114: space usage in container is too high
Fix :
+ If MAX_SIZE is 0, it means the PDB can use unlimited storage, there is no restriction. However, if MAX_SIZE is set to a non-zero value, the PDB cannot use storage beyond the set MAX_SIZE. Any attempt to add files beyond the MAX_SIZE will error out with ORA-65114
+ If the feature is not needed, we can set MAX_SIZE to unlimited for the problematic PDB:
ALTER SESSION SET CONTAINER = PDBXXXX ;
ALTER PLUGGABLE DATABASE STORAGE(MAXSIZE UNLIMITED);
+ If you need to use MAX_SIZE feature, ensure to provide enough headroom over and above the current PDB size to create tempfiles for the restore procedure. Example syntax for setting custom MAX_SIZE
ALTER SESSION SET CONTAINER = PDBXXXX ;
ALTER PLUGGABLE DATABASE STORAGE(MAXSIZE 32G);
+ After making the change for the problematic PDB and any other PDB’s which might be having the same issue, ensure to create a new backup and then use the new backup for cloning in OCI console.
