Q: My VDB tablespace is full, how do I add a datafile? Can I add a new tablespace?
You can add datafiles to a VDB just as you would a physical database. You can also add new tablespaces which don't exist in the dSource.
Delphix organizes the datafiles using the following convention on Unix systems:
You can create additional datafiles and tablespaces under this area, using normal DBA commands (create tablespace, alter tablespaces add datafile)
You can also setup autoextend feature to allow datafiles to grow.
In all cases, Delphix uses thin provisioning and compression to reduce the impact to your storage savings.
Created a new tablespace with 500MB datafile:
Delphix provisions sparse files for VDBs on Linux (and all platforms). So it would only use space on disk which is needed initially. Here we see the space utilization changed by only 4M after adding the 500M file:
Long listing of the file shows the expected 500+M, however:
Q: Does Delphix support Bigfile tablespaces ? And can it support datafiles > 32 GB in size ?
When trying to create a datafile > 32G in Oracle, you may encounter an error like:
This error is not an indication that the Delphix Engine can't accommodate the file size. Generally, Delphix will allow for any file size Oracle supports that you have enough storage for. Using the bigfile keyword, we can instruct Oracle to create our 32G datafile:
As you can see, the file created without issue: