Skip to main content
Delphix

FAQ: Virtual Database (VDB) Datafiles (KBA1073)

 

My VDB tablespace is full, how do I add a datafile?  Would i be able to add a new tablespace?

Yes. 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:

<delphix_mount_point>/<virtual_database_name>/datafile/<source_file_structure>
Ex:  /mnt/provision/VPROD/datafile/u01/oradata/data100.dbf

Using normal DBA commands (create tablespace, alter tablespaces add datafile) you can create additional datafiles and tablespaces under this area.

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.

Before:

 Created a new tablespace with 500MB datafile: 

After:

Delphix provisions sparse files for VDBs on Linux (and all platforms) using only space on the 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:

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 for which you have enough storage. Using the bigfile keyword, you can instruct Oracle to create a 32G datafile:

The file is created without issue: