How to export and import Unified Audit Trail from > Oracle 18c
==================================================================
Via old method
exp \"/ as sysdba\" file=expaudtable.dmp log=expaudtable.log tables=sys.aud$
https://anuj-singh.blogspot.com/2016/11/oracle-datapump-dir-grant-info.html
expdp \"/ as sysdba\" full=y directory=ORACLE_BASE logfile=unified_audit_trail.dmp.log dumpfile=unified_audit_trail.dmp INCLUDE=AUDIT_TRAILS
Export: Release 19.0.0.0.0 - Production on Sun Feb 23 14:03:48 2025
Version 19.16.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Warning: Oracle Data Pump operations are not typically needed when connected to the root or seed of a container database.
FLASHBACK automatically enabled to preserve database integrity.
Starting "SYS"."SYS_EXPORT_FULL_01": "/******** AS SYSDBA" full=y directory=ORACLE_BASE logfile=unified_audit_trail.dmp.log dumpfile=unified_audit_trail.dmp INCLUDE=AUDIT_TRAILS
Processing object type DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/TABLE_DATA
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA
Processing object type DATABASE_EXPORT/PRE_SYSTEM_IMPCALLOUT/MARKER
Processing object type DATABASE_EXPORT/PRE_INSTANCE_IMPCALLOUT/MARKER
Processing object type DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE
Processing object type DATABASE_EXPORT/EARLY_POST_INSTANCE_IMPCALLOUT/MARKER
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/TABLE
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE
Processing object type DATABASE_EXPORT/NORMAL_POST_INSTANCE_IMPCALLOUT/MARKER
Processing object type DATABASE_EXPORT/FINAL_POST_INSTANCE_IMPCALLOUT/MARKER
Processing object type DATABASE_EXPORT/POST_SYSTEM_IMPCALLOUT/MARKER
. . exported "SYS"."KU$_USER_MAPPING_VIEW" 6.078 KB 36 rows
. . exported "AUDSYS"."AUD$UNIFIED":"SYS_P5177" 204.5 MB 664247 rows
. . exported "AUDSYS"."AUD$UNIFIED":"SYS_P5986" 106.6 MB 350671 rows
. . exported "AUDSYS"."AUD$UNIFIED":"SYS_P5831" 84.63 MB 275667 rows
. . exported "AUDSYS"."AUD$UNIFIED":"SYS_P5347" 40.27 MB 124343 rows
. . exported "AUDSYS"."AUD$UNIFIED":"SYS_P5513" 30.60 MB 95274 rows
. . exported "AUDSYS"."AUD$UNIFIED":"SYS_P181" 41.19 MB 31632 rows
. . exported "AUDSYS"."AUD$UNIFIED":"SYS_P6152" 26.15 MB 85764 rows
. . exported "AUDSYS"."AUD$UNIFIED":"SYS_P5665" 24.40 MB 77046 rows
. . exported "AUDSYS"."AUD$UNIFIED":"SYS_P3069" 3.388 MB 7075 rows
. . exported "AUDSYS"."AUD$UNIFIED":"SYS_P457" 8.178 MB 3558 rows
. . exported "AUDSYS"."AUD$UNIFIED":"SYS_P3256" 1.510 MB 3023 rows
. . exported "AUDSYS"."AUD$UNIFIED":"SYS_P4655" 1.249 MB 2205 rows
. . exported "AUDSYS"."AUD$UNIFIED":"SYS_P5002" 1.159 MB 3171 rows
. . exported "AUDSYS"."AUD$UNIFIED":"SYS_P3966" 1.178 MB 2198 rows
. . exported "AUDSYS"."AUD$UNIFIED":"SYS_P4151" 813.7 KB 1985 rows
. . exported "AUDSYS"."AUD$UNIFIED":"SYS_P4325" 714.2 KB 1261 rows
. . exported "AUDSYS"."AUD$UNIFIED":"SYS_P4836" 507.6 KB 869 rows
. . exported "AUDSYS"."AUD$UNIFIED":"SYS_P3796" 483.1 KB 854 rows
. . exported "AUDSYS"."AUD$UNIFIED":"SYS_P2745" 646.2 KB 434 rows
. . exported "AUDSYS"."AUD$UNIFIED":"SYS_P4485" 293.0 KB 462 rows
. . exported "AUDSYS"."AUD$UNIFIED":"SYS_P3630" 218.0 KB 352 rows
. . exported "AUDSYS"."AUD$UNIFIED":"SYS_P3454" 115.6 KB 149 rows
. . exported "AUDSYS"."AUD$UNIFIED":"SYS_P2499" 109.2 KB 105 rows
. . exported "AUDSYS"."AUD$UNIFIED":"SYS_P2912" 84.62 KB 70 rows
. . exported "AUDSYS"."AUD$UNIFIED":"SYS_P1987" 67.64 KB 42 rows
. . exported "AUDSYS"."AUD$UNIFIED":"SYS_P1335" 65.55 KB 32 rows
. . exported "AUDSYS"."AUD$UNIFIED":"SYS_P2227" 59.61 KB 19 rows
. . exported "AUDSYS"."AUD$UNIFIED":"SYS_P1130" 51.52 KB 2 rows
. . exported "SYS"."DAM_CLEANUP_JOBS$" 7.242 KB 1 rows
. . exported "SYS"."DAM_CONFIG_PARAM$" 6.585 KB 18 rows
. . exported "AUDSYS"."AUD$UNIFIED":"AUD_UNIFIED_P0" 0 KB 0 rows
. . exported "SYS"."AUD$" 0 KB 0 rows
. . exported "SYS"."DAM_CLEANUP_EVENTS$" 0 KB 0 rows
. . exported "SYS"."AUDTAB$TBS$FOR_EXPORT" 5.953 KB 2 rows
. . exported "SYS"."FGA_LOG$FOR_EXPORT" 0 KB 0 rows
Master table "SYS"."SYS_EXPORT_FULL_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYS.SYS_EXPORT_FULL_01 is:
/u01/app/oracle/unified_audit_trail.dmp
Job "SYS"."SYS_EXPORT_FULL_01" successfully completed at Sun Feb 23 14:07:13 2025 elapsed 0 00:03:18
ls -lthr /u01/app/oracle/unified_audit_trail.dmp
-rw-r----- 1 oracle asmadmin 581M Feb 23 14:07 /u01/app/oracle/unified_audit_trail.dmp
===================
with datapump api
declare
l_datapump_handle NUMBER; -- Data Pump job handle
l_datapump_dir VARCHAR2(20) := 'ORACLE_BASE'; -- Data Pump Directory
l_status varchar2(200); -- Data Pump Status
begin
l_datapump_handle := dbms_datapump.open(operation => 'EXPORT', -- operation = EXPORT, IMPORT, SQL_FILE
job_mode =>'FULL', -- job_mode = FULL, SCHEMA, TABLE, TABLESPACE, TRANSPORTABLE
job_name => 'AUD FULL EXPORT JOB RUN 002', -- job_name = NULL (default) or: job name (max 30 chars)
version => 'latest'); -- version = COMPATIBLE (default), LATEST (dbversion), a value (11.0.0 or 12)
dbms_datapump.add_file(handle => l_datapump_handle,filename => 'exp_FULL_AUD_%U.dmp',directory => l_datapump_dir);
dbms_datapump.add_file(handle => l_datapump_handle,filename => 'exp_FULL_AUD.log' ,directory => l_datapump_dir ,filetype => DBMS_DATAPUMP.ku$_file_type_log_file);
dbms_datapump.metadata_filter(handle => l_datapump_handle, name => 'EXCLUDE_PATH_EXPR', value => 'IN(''AUDIT_TRAILS'')');
dbms_datapump.set_parameter(l_datapump_handle,'CLIENT_COMMAND','Full Consistent Data Pump Export of AUD Schema HR with PARALLEL 8');
dbms_datapump.set_parameter(l_datapump_handle,'FLASHBACK_TIME','SYSTIMESTAMP');
dbms_datapump.set_parallel(l_datapump_handle,8); -----<<< parallel
dbms_datapump.start_job(handle => l_datapump_handle);
dbms_datapump.wait_for_job(handle => l_datapump_handle,
job_state => l_status );
dbms_output.put_line( l_status );
end;
/
-rw-r--r-- 1 oracle asmadmin 0 Feb 23 14:14 exp_FULL_AUD.log
-rw-r----- 1 oracle asmadmin 16384 Feb 23 14:15 exp_FULL_AUD_07.dmp
-rw-r----- 1 oracle asmadmin 36864 Feb 23 14:15 exp_FULL_AUD_03.dmp
-rw-r----- 1 oracle asmadmin 57344 Feb 23 14:16 exp_FULL_AUD_02.dmp
-rw-r----- 1 oracle asmadmin 20480 Feb 23 14:16 exp_FULL_AUD_04.dmp
-rw-r----- 1 oracle asmadmin 28672 Feb 23 14:16 exp_FULL_AUD_01.dmp
-rw-r----- 1 oracle asmadmin 24576 Feb 23 14:16 exp_FULL_AUD_06.dmp
-rw-r----- 1 oracle asmadmin 16384 Feb 23 14:16 exp_FULL_AUD_05.dmp
No comments:
Post a Comment