Database Error Messages

OCI-46410

The value of LAST_ARCHIVE_TIME provided (last_archive_time) is a future timestamp. The current time is (current_timestamp)
  • last_archive_time: The value of LAST_ARCHIVE_TIME provided.
  • current_timestamp: The current timestamp.

Cause

The value of LAST_ARCHIVE_TIME provided in the DBMS_AUDIT_MGMT.SET_LAST_ARCHIVE_TIMESTAMP procedure is a future timestamp, which is not allowed. Please note that the LAST_ARCHIVE_TIME must be specified in Coordinated Universal Time (UTC) when the audit trail types are AUDIT_TRAIL_AUD_STD, AUDIT_TRAIL_FGA_STD, AUDIT_TRAIL_UNIFIED_FILES or AUDIT_TRAIL_UNIFIED_TABLE and the LAST_ARCHIVE_TIME must be specified as the local time zone time when the audit trail types are AUDIT_TRAIL_OS or AUDIT_TRAIL_XML.


Action

Provide a value of LAST_ARCHIVE_TIME which is not in the future. Make sure you specify the value in the correct time zone based on the value of audit trail type.