Skip to main content
Delphix

How to Access Oracle dSource Archive Logs from the Delphix Appliance (KBA5482)

 

KBA

KBA# 5482

 

Issue

At times, it may be necessary to retrieve/restore the archivelogs of an Oracle dSource for a number of reasons, including but not limited to, recovery of a production database.  The method described below will allow access to a copy of the dSource's current ingested archives logs which will be shared and mounted to a target server using NFS.  Currently the dSource archivelogs are only shared during provisioning from a snapshot of the dSource, to a filesystem (/provision-mount-point/source-archive).  The time this filesystem is available is dependent on the length of the recovery of the VDB, which in most instances will not be sufficient for copying the needed archive logs from this location.

Prerequisites

You must have a target Oracle environment compatible with the version of the Oracle dSource ingested.

Applicable Delphix Versions

Click here to view the versions of the Delphix engine to which this article applies
Major Release All Sub Releases
6.0 6.0.0.0
5.3 5.3.0.0, 5.3.0.1, 5.3.0.2, 5.3.0.3, 5.3.1.0, 5.3.1.1, 5.3.1.2, 5.3.2.0, 5.3.3.0, 5.3.3.1, 5.3.4.0, 5.3.5.0 5.3.6.0, 5.3.7.0, 5.3.7.1, 5.3.8.0
5.2 5.2.2.0, 5.2.2.1, 5.2.3.0, 5.2.4.0, 5.2.5.0, 5.2.5.1, 5.2.6.0, 5.2.6.1
5.1 5.1.0.0, 5.1.1.0, 5.1.2.0, 5.1.3.0, 5.1.4.0, 5.1.5.0, 5.1.5.1, 5.1.6.0, 5.1.7.0, 5.1.8.0, 5.1.8.1, 5.1.9.0, 5.1.10.0
5.0 5.0.1.0, 5.0.1.1, 5.0.2.0, 5.0.2.1, 5.0.2.2, 5.0.2.3, 5.0.3.0, 5.0.3.1, 5.0.4.0, 5.0.4.1 ,5.0.5.0, 5.0.5.1, 5.0.5.2, 5.0.5.3, 5.0.5.4
4.3 4.3.1.0, 4.3.2.0, 4.3.2.1, 4.3.3.0, 4.3.4.0, 4.3.4.1, 4.3.5.0
4.2 4.2.0.0, 4.2.0.3, 4.2.1.0, 4.2.1.1, 4.2.2.0, 4.2.2.1, 4.2.3.0, 4.2.4.0 , 4.2.5.0, 4.2.5.1
4.1 4.1.0.0, 4.1.2.0, 4.1.3.0, 4.1.3.1, 4.1.3.2, 4.1.4.0, 4.1.5.0, 4.1.6.0

Resolution

Select the latest dSource Snapshot and provision to a compatible Target Environment specifying a "Pre Start" Hook Point during the Provision workflow.  For example:

Screen Shot 2020-02-18 at 12.22.05 PM.png

In this example, a "Pre Start" Hook script called "Archive Log Retrieval" is created with the following script contents:

sleep 3600
exit 1

Please note, the argument to sleep is in seconds, so in this example, 3600 = 1 hour and should be modified for the length of time you think you will need to have access to the source-archive filesystem to copy the archivelog files off to a new location.   Once the limit configured by sleep has been reached, the script will exit with an exit code of 1 causing the VDB provision job to fail and rendering the VDB to be invalid/unstartable. At this point, the VDB can be removed from the Delphix Appliance.