My Oracle Support Banner

Encrypted tablespaces cannot be archived in non-upgraded AVDF 12.2 environment (Doc ID 2422587.1)

Last updated on MARCH 27, 2019

Applies to:

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

Symptoms

NOTE: In the images and/or the document content below, the user information and data used represents fictitious data from the Oracle sample schema(s) or Public Documentation delivered with an Oracle database product. Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner. 

When running an archive job of encrypted tablespace which are in offline periods, archive job is successfully completed but archiving is failed by following error.

Tablespace AV_ILM_0572_0578 is not yet encrypted. Please try again after running avdf_data_encryption.sh script.

 

Also, [Settings] - [Repository Encryption] - [Tablespace and Encryption Status] in Web console shows this tablespace as Encryption Status is "NO".

 

However, DBA_TABLESPACES shows as this tablespace is already encrypted.

SQL> select TABLESPACE_NAME, ENCRYPTED from dba_tablespaces order by 1;

TABLESPACE_NAME                               ENC

--------------------------------------------- ---
      :
AV_ILM_0572_0578                              YES

 

This env is not upgraded from AVDF 12.1.x. In AVDF 12.2 (non-upgraded env), all of tablespaces are encrypted as a default, hence the results of DBA_TABLESPACES is correct. 

ILM patch cannot help this case.

How To solve Most of the ILM Issues (Doc ID 2222205.1)

 

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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