Oracle 视图 DBA_AUDIT_MGMT_LAST_ARCH_TS 官方解释,作用,如何使用详细说明

本站中文解释

G
Oracle视图DBA_AUDIT_MGMT_LAST_ARCH_TS用于显示系统中每个审计管理审计文件(XMF)最后一次归档的时间点。该视图包含一个叫XML_FILE_NAME的列,该列包含被归档的文件的XML名称;还有一列叫LAST_ARCHIVED_ON,它包含文件最后一次归档的时间,通常以格式DD-MM-YYYY HH24:MI:SS表示。

要使用DBA_AUDIT_MGMT_LAST_ARCH_TS视图,可以使用SELECT子句来检索此视图中的每个XML文件的最后归档时间。例如,下面的SELECT子句将检索系统中名为“AUD$_ORACLE_USER_yyyymmddhh24miss.xml”的审计文件的最后一次归档时间:

SELECT XML_FILE_NAME, LAST_ARCHIVED_ON
FROM DBA_AUDIT_MGMT_LAST_ARCH_TS
WHERE XML_FILE_NAME = ‘AUD$_ORACLE_USER_yyyymmddhh24miss.xml’
ORDER BY LAST_ARCHIVED_ON DESC;

官方英文解释

DBA_AUDIT_MGMT_LAST_ARCH_TS displays information about the last archive timestamps set for audit trail cleanup or purges.

Note:

This view is populated in any Oracle Database where auditing is enabled, regardless of whether pre-Oracle Database 12c auditing or unified auditing is enabled for the database.

  • See Oracle Database Security
    Guide
    for more information about unified auditing.

  • See Oracle Database Upgrade
    Guide
    for more information about migrating to unified auditing.

Column Datatype NULL Description

AUDIT_TRAIL

VARCHAR2(20)

Audit trail for which the last archive timestamp applies:

  • STANDARD AUDIT TRAIL

  • FGA AUDIT TRAIL

  • OS AUDIT TRAIL

  • XML AUDIT TRAIL

  • UNIFIED AUDIT TRAIL

RAC_INSTANCE

NUMBER

NOT NULL

Oracle RAC instance number for which the last archive timestamp applies; 0 implies not applicable

LAST_ARCHIVE_TS

TIMESTAMP(6) WITH TIME ZONE

Timestamp of the last audit record or audit file that has been archived

DATABASE_ID

NUMBER

NOT NULL

Database ID of the audit records to clean up

CONTAINER_GUID

VARCHAR2(33)

NOT NULL

GUID of the container of the audit records to clean up

Note:

In a read-only database, including an Oracle Active Data Guard physical standby database, this view is not populated when DBMS_AUDIT_MGMT.SET_LAST_ARCHIVE_TIMESTAMP is invoked. In such a case, use DBMS_AUDIT_MGMT.GET_LAST_ARCHIVE_TIMESTAMP to check for the timestamp, if it was configured for the database instance.

See Also:

Oracle Database PL/SQL
Packages and Types Reference
for more information about DBMS_AUDIT_MGMT subprograms


数据运维技术 » Oracle 视图 DBA_AUDIT_MGMT_LAST_ARCH_TS 官方解释,作用,如何使用详细说明