Skip to main content
Delphix

KBA1319 How to resolve "Error: Archive logs cannot be retrieved due to deletion"

 

Issue

The following fault has occured for an attached Oracle RDBMS dSource :

Title: Cannot provision a database from a portion of TimeFlow
Details: Database "db112_stb" TimeFlow "default" has missing logs. Portions of the TimeFlow are unprovisionable.

The UI fault appears as:

These faults generally appear as a result of archivelogs associated with the dSource having been removed from the archive location at the source before Delphix log sync has had time to copy them across to the engine. This is typically associated with an aggressive archivelog deletion policy at the dSource site and an RMAN archivelog backup script that is removing all logs in the destination during its cleanup without setting a delay that would leave the most recent archive logs in place for a short period of time.

Timecards in the engine UI will show the following behaviour for any snapshots where this problem exists.

Resolution

Option 1:

Delphix provides a timeflow repair tool in both the UI and CLI that will allow you to capture the missing logs once they have been restored to the file system of the dSource target environment. Using this feature you will be able to add the missing logs back into the engine, repair the timecard and snapshot reporting missing logs and mark the fault as resolved once the logs are available to Delphix. The following documentation link details this process.

Timeflow Repair Operation

Option 2:

You can choose to ignore the fault however be warned this will leave you with timecards and snapshots in the dSources timeflow that cannot be provisioned from. Capturing another snapshot of the dSource where you know all archivelogs are present covering the time in the dSource it takes to take the new snapshot will provide you with a time card that can be used to provision a new VDB.  This will not correct earlier time cards and snapshots where the error is reported. Option 1 is the only way to correct the missing logs errors for the older time cards.

Related Documentation 

Provisioning a VDB