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?