AVDF Restore Script does not Restore the Offline Tablespaces (Doc ID 2225641.1)

Last updated on JANUARY 23, 2017

Applies to:

Oracle Audit Vault and Database Firewall - Version 12.1.0.0 to 12.2.0.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

In AVDF 12.1 and 12.2, the restore script of the Audit Vault Server skips offline tablespaces.

Restore failed during recover database and restore datafile when hitting offline datafiles. he tablespace is in offline status along with the datafile in offline status.

rman log file
datafile 6 not processed because file is offline
datafile 7 not processed because file is offline
datafile 10 not processed because file is offline


This causes the loss of the datafiles which are offline.

We expect the restore script to restore even the OFFLINE tablespaces because those might be archived and one should be able to perform an ILM restore operation on them.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms