My Oracle Support Banner

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

Last updated on MARCH 29, 2019

Applies to:

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


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.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.