Database Software

Hello,

In Oracle 12.1.0.1 (RHEL OS) environment, I'm getting unexpected errors ORA-08180 and ORA-06512  when using DBMD_AUDIT_MGMT to cleanup files using LAST_ARCHIVE_TS (USE_LAST_ARCH_TIME=TRUE).  Below is SQL:

SQL> select min(event_timestamp) from unified_audit_trail;

MIN(EVENT_TIMESTAMP)

---------------------------------------------------------------------------

21-AUG-14 12.03.56.861360 PM

SQL> select count(*) from unified_audit_trail;

COUNT(*)

----------

2083

SQL> exec DBMS_AUDIT_MGMT.SET_LAST_ARCHIVE_TIMESTAMP ( -

AUDIT_> TRAIL_TYPE => DBMS_AUDIT_MGMT.AUDIT_TRAIL_UNIFIED, -

LAST> _ARCHIVE_TIME => SYSTIMESTAMP-6)

PL/SQL procedure successfully completed.

SQL> SELECT * FROM dba_audit_mgmt_last_arch_ts;

AUDIT_TRAIL RAC_INSTANCE

-------------------- ------------

LAST_ARCHIVE_TS

---------------------------------------------------------------------------

UNIFIED AUDIT TRAIL 0

22-AUG-14 02.10.27.000000 PM +00:00

SQL> exec DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL( -

> AUDIT_TRAIL_TYPE => DBMS_AUDIT_MGMT.AUDIT_TRAIL_UNIFIED, -

USE_LAST_> ARCH_TIMESTAMP => TRUE)

BEGIN DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL( AUDIT_TRAIL_TYPE => DBMS_AUDIT_MGMT.AUDIT_TRAIL_UNIFIED, USE_LAST_ARCH_TIMESTAMP => TRUE); END;

*

ERROR at line 1:

ORA-08180: no snapshot found based on specified time

ORA-06512: at "SYS.DBMS_AUDIT_MGMT", line 4425

ORA-06512: at "SYS.DBMS_AUDIT_MGMT", line 825

ORA-06512: at line 1

Thanks in advance.