Skip to main content
Delphix

FAQ: Provisioning Oracle Virtual Databases (KBA1433)

 

 

KBA

KBA# 1433

What are the supported Oracle versions for Provisioning? 

Please refer to Supported DBMS Versions

What do the Provisioning Job Progress Percentages mean? 

The provisioning job keeps updating its percentage completion. A rough breakdown of the updates are:

 

Snip20220901_4.png

Is it possible to provision a virtual database (VDB) to either a particular point in time or a particular SCN?

Yes. Please refer to Provisioning a Virtual Database for the procedure.

What is the fastest way to provision a VDB? 

Oracle recovery is usually the single biggest contributor to the total provisioning time. Provisioning using a Snapshot does the least amount of recovery. Please refer to Provisioning a Virtual Database for the procedure to provision using a Snapshot.

Can I Provision a VDB from an Encrypted Oracle Database? 

Yes. Delphix Engine supports provisioning from a dSource added from a physical database encrypted with Oracle’s Transparent Database Encryption (TDE), which can be used to encrypt columns or tablespaces. Please refer to Provisioning from an Encrypted Database for more details.

Can I Provision a VDB from an Encrypted Multitenant Database (PDB)? 

Yes. From 6.0.6.0 Delphix allows provision of TDE-enabled vPDBs. Please refer to Provisioning a TDE-enabled vPDB for more details. 

Can a VDB be provisioned from another VDB? 

Yes. The timeflow of the VDB will be used to achieve this.

Any known issues when Provisioning with SQLPLUS settings? 

Provisioning fails when the "feedback" option is ON in the glogin.sql/login.sql files. Delphix provisioning tools rely on the format of output from sqlplus, and the "feedback" option can change the format of the output.  SQL queries within the glogin.sql/login.sql files that generate output, for example, SELECT statements, can also lead to the failure of provision jobs.

My VDB non-RMAN backups are failing. Can Delphix be doing something at around the same time to cause this? 

Delphix puts the VDB in hot backup mode when taking a Snapshot. And this can interfere with the non-RMAN type backups which also put the VDB in hot backup modeThis situation can be avoided if you can schedule the VDB Snapshot to happen outside the expected non-RMAN backup window.

My VDB startup is failing stating the control file cannot be locked. How to resolve this? 

The database startup fails like this:

Screen shot 2012-06-28 at 8.08.53 PM.png

Please refer to Knowledge Base Article KBA-1563. If you require further assistance then please contact Delphix Support.

Can Delphix perform cross-platform provisioning (XPP)? 

No. This feature was deprecated from Release 6.0.0.0.

Can Delphix provision to a 2 or greater than 2 node RAC? 

Yes. This is fully supported. 

What if I want to use an SPFILE instead of a PFILE for my VDB? 

Delphix uses PFILEs for VDBs.

After the VDB is provisioned, standard Oracle commands can be run to create SPFILE from a PFILE. From then on, Oracle will look for SPFILE as the first thing during the startup.

Can Flashback be utilized when provisioning a VDB? 

Yes, but only if the following conditions are met:

  • Source is a standby
  • Flashback is on 
  • Flashback logs are managed by ASM 
  • The target host has an ASM instance to which the VDB can connect 
  • Delphix can read the flashback logs referenced by the backup controlfile.

Otherwise there will be problems using Flashback