Yesterday I was doing an import for a pluggable database and it ran out of space so I tried to resize one of the datafile and got below error while doing it :-
SQL> ALTER DATABASE DATAFILE '+DATA1/AMIT_CON/3933D120863A61B7E0531609900AE4EE/DATAFILE/AMIT.786.919009661' RESIZE 100g;
ALTER DATABASE DATAFILE '+DATA1/AMIT_CON/3933D120863A61B7E0531609900AE4EE/DATAFILE/AMIT.786.919009661' RESIZE 100g
*
ERROR at line 1:
ORA-65114: space usage in container is too high
Cause :-
This error generally comes when total size of PDB after resize of the datafile is more than the size you have allocated to a PDB while creating.
Solution :-
Change the allocation storage for a PDB and then try to resize the datafile.
Note :- while changing the storage for a PDB , check if space is available in ASM disks.
Allocation storage of a PDB can be changed by logging in to the PDB :-
SQL> alter session set container=AMIT;
Session altered.
Either change the allocation storage to a required value or change it to unlimited.
SQL> ALTER PLUGGABLE DATABASE STORAGE UNLIMITED;
Pluggable database altered.
OR
SQL> alter pluggable database storage (MAXSIZE 120G);
Pluggable database altered.
Now try to resize the datafile
SQL> ALTER DATABASE DATAFILE '+DATA1/AMIT_CON/3933D120863A61B7E0531609900AE4EE/DATAFILE/amit.786.919009661' RESIZE 100556633088;
Database altered.
SQL> ALTER DATABASE DATAFILE '+DATA1/AMIT_CON/3933D120863A61B7E0531609900AE4EE/DATAFILE/AMIT.786.919009661' RESIZE 100g;
ALTER DATABASE DATAFILE '+DATA1/AMIT_CON/3933D120863A61B7E0531609900AE4EE/DATAFILE/AMIT.786.919009661' RESIZE 100g
*
ERROR at line 1:
ORA-65114: space usage in container is too high
Cause :-
This error generally comes when total size of PDB after resize of the datafile is more than the size you have allocated to a PDB while creating.
Solution :-
Change the allocation storage for a PDB and then try to resize the datafile.
Note :- while changing the storage for a PDB , check if space is available in ASM disks.
Allocation storage of a PDB can be changed by logging in to the PDB :-
SQL> alter session set container=AMIT;
Session altered.
Either change the allocation storage to a required value or change it to unlimited.
SQL> ALTER PLUGGABLE DATABASE STORAGE UNLIMITED;
Pluggable database altered.
OR
SQL> alter pluggable database storage (MAXSIZE 120G);
Pluggable database altered.
Now try to resize the datafile
SQL> ALTER DATABASE DATAFILE '+DATA1/AMIT_CON/3933D120863A61B7E0531609900AE4EE/DATAFILE/amit.786.919009661' RESIZE 100556633088;
Database altered.
Comments
Post a Comment