Skip to main content

Oracle Virtual Database (VDB) Provisioning Performance May Degrade Due to Adding New Data Files (KBA1347)




Oracle Virtual Database (VDB) provisioning may take longer than expected when recovery includes adding new datafiles (which are registered in the controlfile but not yet in the filesystem). This can happen if new datafiles are added to a source database while a SnapSync operation is running.

Recovery will initially fail, Delphix will detect the failure, create the new file, and retry recovery. This will loop for each new file, which could significantly increase the total provisioning time.


Confirmation that recovery includes adding new datafiles can be seen by monitoring for "ORA-01244" events in the Oracle Alert Log during provisioning of the VDB.

An example of this can be seen below. 

ORA-00283: recovery session canceled due to errors
ORA-01244: unnamed datafile(s) added to control file by media recovery
ORA-01110: data file 2: '/u01/app/oracle/oradata/NEWMAN/datafile/o1_mf_t_d0cxn449_.dbf'

The Delphix Engine will detect the recovery failure and resolve it by creating the new datafile. This creation may take some time depending on the size of the datafile.

ORA-1112 signalled during: alter database recover cancel...
Tue Oct 18 03:27:20 2016
alter database create datafile 2 as new
Completed: alter database create datafile 2 as new

The Delphix Engine will then continue recovery. If recovery encounters another new datafile, the process will repeat.


To avoid this situation ensure a fresh SnapSync is taken as soon as possible after large datafiles are added to the dSource database. This will allow the starting provisioning point to include the new datafiles, avoiding the need to create and recover through these operations.