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