Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Please ask technical questions in the appropriate category. Thank you!

expdp fails export SYS.AUD$

chileme88Oct 12 2020

Hi I've a 19.7 rac database with 2 pdbs.
Every night I run a shell script that call expdp in both pdbs:
expdp C##DBABACKUP/*********@${PDB} dumpfile=${DUMPFILE}_%U.dmp logfile=${DUMPFILE}.log encryption_password=${PASSWORD} PARFILE=${PARFILE}
The content of ${PARFILE} is:
*************************************************************
full=Y \
EXCLUDE=SCHEMA:"LIKE 'STORICO'" \
directory=export \
parallel=4 \
compression=all \
encryption_algorithm=aes256 \
VERSION=19.0.0 \
LOGTIME=ALL \
**************************************************************

All the tables of the 2 pdbs are exported but not the AUD$ tables.
In both log I find:
10-OCT-20 04:51:32.830: ORA-31693: Table data object "SYS"."AUD$" failed to load/unload and is being skipped due to error:
ORA-00942: table or view does not exist

In both pdbs I changed the AUD$ tablespace with:
BEGIN DBMS_AUDIT_MGMT.SET_AUDIT_TRAIL_LOCATION(
audit_trail_type => DBMS_AUDIT_MGMT.AUDIT_TRAIL_AUD_STD,
audit_trail_location_value => 'DBAAUDIT_BIGTBSDAT');
END;
/

What's wrong?

Comments
Post Details
Added on Oct 12 2020
7 comments
834 views