Discussions
Categories
- 382.5K All Categories
- 2.1K Data
- 212 Big Data Appliance
- 1.9K Data Science
- 448.4K Databases
- 221.1K General Database Discussions
- 3.7K Java and JavaScript in the Database
- 25 Multilingual Engine
- 540 MySQL Community Space
- 469 NoSQL Database
- 7.8K Oracle Database Express Edition (XE)
- 2.9K ORDS, SODA & JSON in the Database
- 499 SQLcl
- 3.9K SQL Developer Data Modeler
- 186.3K SQL & PL/SQL
- 21.1K SQL Developer
- 293.8K Development
- 7 Developer Projects
- 128 Programming Languages
- 290.5K Development Tools
- 96 DevOps
- 3K QA/Testing
- 645.6K Java
- 24 Java Learning Subscription
- 36.9K Database Connectivity
- 151 Java Community Process
- 104 Java 25
- 22.1K Java APIs
- 137.9K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 17 Java Essentials
- 146 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 200 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 289 LiveLabs
- 36 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.8K Other Languages
- 2.3K Chinese
- 168 Deutsche Oracle Community
- 1.2K Español
- 1.9K Japanese
- 234 Portuguese
expdp fails export SYS.AUD$
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?
Answers
-
I would usually do something like this,
expdp system/oracle full=y include=audit_trails file=aud.dmp
-
I updated my parfile:
FULL=Y \
EXCLUDE=SCHEMA:"LIKE 'STORICO'" \
EXCLUDE=SCHEMA:"LIKE 'DBAAUDIT'" \
EXCLUDE=AUDIT_TRAILS \
DIRECTORY=export \
PARALLEL=4 \
COMPRESSION=all \
ENCRYPTION_ALGORITHM=aes256 \
VERSION=19.0.0 \
LOGTIME=ALL \
Now the expdp doesn't start and logs:
Export: Release 19.0.0.0.0 - Production on Sat Nov 21 04:00:03 2020
Version 19.8.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
21-NOV-20 04:00:12.182: Starting "C##DBABACKUP"."SYS_EXPORT_FULL_05": C##DBABACKUP/********@PDBBI2 dumpfile=PDBBI2_20201121_0400_expdp_%U.dmp logfile=PDBBI2_20201121_0400_expdp.log encryption_password=******** PARFILE=/home/oracle/scripts/expdp_parfile/PDBBI2_FULL.par
21-NOV-20 04:00:14.681: ORA-39126: Worker unexpected fatal error in KUPW$WORKER.CONFIGURE_METADATA_UNLOAD []
ORA-31600: invalid input value IN ('AUDIT_TRAILS') for parameter VALUE in function SET_FILTER
21-NOV-20 04:00:14.681: ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 12617
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA", line 7465
ORA-06512: at "SYS.KUPW$WORKER", line 9852
21-NOV-20 04:00:14.681: ----- PL/SQL Call Stack -----
object line object
handle number name
0x16c975528 33543 package body SYS.KUPW$WORKER.WRITE_ERROR_INFORMATION
0x16c975528 12651 package body SYS.KUPW$WORKER.DETERMINE_FATAL_ERROR
0x16c975528 10244 package body SYS.KUPW$WORKER.CONFIGURE_METADATA_UNLOAD
0x16c975528 3838 package body SYS.KUPW$WORKER.UNLOAD_METADATA
0x16c975528 13746 package body SYS.KUPW$WORKER.DISPATCH_WORK_ITEMS
0x16c975528 2439 package body SYS.KUPW$WORKER.MAIN
0x19f73a038 2 anonymous block
21-NOV-20 04:00:14.681: KUPW: Start sequence number:
21-NOV-20 04:00:14.681: KUPW: End sequence number:
21-NOV-20 04:00:14.681: KUPW: **NOT** Doing Parallel metadata
21-NOV-20 04:00:14.681: KUPW: In procedure CONFIGURE_METADATA_UNLOAD
21-NOV-20 04:00:14.681: KUPW: Phase: Filter Name: BEGIN_AFTER Filter Value:
21-NOV-20 04:00:14.681: DBMS_METADATA.OPEN19.0.0
21-NOV-20 04:00:14.681: DBMS_METADATA.OPEN19.0.0
21-NOV-20 04:00:14.681: DBMS_METADATA.SET_FILTER
21-NOV-20 04:00:14.681: DBMS_METADATA.SET_FILTER
21-NOV-20 04:00:14.681: KUPW: In procedure DETERMINE_FATAL_ERROR with ORA-31600: invalid input value IN ('AUDIT_TRAILS') for parameter VALUE in function SET_FILTER
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA", line 7465
21-NOV-20 04:00:16.153: ORA-39126: Worker unexpected fatal error in KUPW$WORKER.CONFIGURE_METADATA_UNLOAD []
ORA-31600: invalid input value IN ('AUDIT_TRAILS') for parameter VALUE in function SET_FILTER
21-NOV-20 04:00:16.153: ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 12617
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA", line 7465
ORA-06512: at "SYS.KUPW$WORKER", line 9852
21-NOV-20 04:00:16.153: ----- PL/SQL Call Stack -----
object line object
handle number name
0x16c975528 33543 package body SYS.KUPW$WORKER.WRITE_ERROR_INFORMATION
0x16c975528 12651 package body SYS.KUPW$WORKER.DETERMINE_FATAL_ERROR
0x16c975528 10244 package body SYS.KUPW$WORKER.CONFIGURE_METADATA_UNLOAD
0x16c975528 3838 package body SYS.KUPW$WORKER.UNLOAD_METADATA
0x16c975528 13746 package body SYS.KUPW$WORKER.DISPATCH_WORK_ITEMS
0x16c975528 2439 package body SYS.KUPW$WORKER.MAIN
0x19f73a038 2 anonymous block
21-NOV-20 04:00:16.153: KUPW: Start sequence number:
21-NOV-20 04:00:16.153: KUPW: End sequence number:
21-NOV-20 04:00:16.153: KUPW: **NOT** Doing Parallel metadata
21-NOV-20 04:00:16.153: KUPW: In procedure CONFIGURE_METADATA_UNLOAD
21-NOV-20 04:00:16.153: KUPW: Phase: Filter Name: BEGIN_AFTER Filter Value:
21-NOV-20 04:00:16.153: DBMS_METADATA.OPEN19.0.0
21-NOV-20 04:00:16.153: DBMS_METADATA.OPEN19.0.0
21-NOV-20 04:00:16.153: DBMS_METADATA.SET_FILTER
21-NOV-20 04:00:16.153: DBMS_METADATA.SET_FILTER
21-NOV-20 04:00:16.153: KUPW: In procedure DETERMINE_FATAL_ERROR with ORA-31600: invalid input value IN ('AUDIT_TRAILS') for parameter VALUE in function SET_FILTER
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA", line 7465
21-NOV-20 04:00:22.716: ORA-39126: Worker unexpected fatal error in KUPW$WORKER.CONFIGURE_METADATA_UNLOAD []
ORA-31600: invalid input value IN ('AUDIT_TRAILS') for parameter VALUE in function SET_FILTER
21-NOV-20 04:00:22.716: ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 12617
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA", line 7465
ORA-06512: at "SYS.KUPW$WORKER", line 9852
21-NOV-20 04:00:22.716: ----- PL/SQL Call Stack -----
object line object
handle number name
0x9c2fbd90 33543 package body SYS.KUPW$WORKER.WRITE_ERROR_INFORMATION
0x9c2fbd90 12651 package body SYS.KUPW$WORKER.DETERMINE_FATAL_ERROR
0x9c2fbd90 10244 package body SYS.KUPW$WORKER.CONFIGURE_METADATA_UNLOAD
0x9c2fbd90 3838 package body SYS.KUPW$WORKER.UNLOAD_METADATA
0x9c2fbd90 13746 package body SYS.KUPW$WORKER.DISPATCH_WORK_ITEMS
0x9c2fbd90 2439 package body SYS.KUPW$WORKER.MAIN
0x1468c2490 2 anonymous block
21-NOV-20 04:00:22.716: KUPW: Start sequence number:
21-NOV-20 04:00:22.716: KUPW: End sequence number:
21-NOV-20 04:00:22.716: KUPW: **NOT** Doing Parallel metadata
21-NOV-20 04:00:22.716: KUPW: In procedure CONFIGURE_METADATA_UNLOAD
21-NOV-20 04:00:22.716: KUPW: Phase: Filter Name: BEGIN_AFTER Filter Value:
21-NOV-20 04:00:22.716: DBMS_METADATA.OPEN19.0.0
21-NOV-20 04:00:22.716: DBMS_METADATA.OPEN19.0.0
21-NOV-20 04:00:22.716: DBMS_METADATA.SET_FILTER
21-NOV-20 04:00:22.716: DBMS_METADATA.SET_FILTER
21-NOV-20 04:00:22.716: KUPW: In procedure DETERMINE_FATAL_ERROR with ORA-31600: invalid input value IN ('AUDIT_TRAILS') for parameter VALUE in function SET_FILTER
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA", line 7465
21-NOV-20 04:00:23.978: ORA-39126: Worker unexpected fatal error in KUPW$WORKER.CONFIGURE_METADATA_UNLOAD []
ORA-31600: invalid input value IN ('AUDIT_TRAILS') for parameter VALUE in function SET_FILTER
21-NOV-20 04:00:23.978: ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 12617
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA", line 7465
ORA-06512: at "SYS.KUPW$WORKER", line 9852
21-NOV-20 04:00:23.978: ----- PL/SQL Call Stack -----
object line object
handle number name
0x16c975528 33543 package body SYS.KUPW$WORKER.WRITE_ERROR_INFORMATION
0x16c975528 12651 package body SYS.KUPW$WORKER.DETERMINE_FATAL_ERROR
0x16c975528 10244 package body SYS.KUPW$WORKER.CONFIGURE_METADATA_UNLOAD
0x16c975528 3838 package body SYS.KUPW$WORKER.UNLOAD_METADATA
0x16c975528 13746 package body SYS.KUPW$WORKER.DISPATCH_WORK_ITEMS
0x16c975528 2439 package body SYS.KUPW$WORKER.MAIN
0x19f73a038 2 anonymous block
21-NOV-20 04:00:23.978: KUPW: Start sequence number:
21-NOV-20 04:00:23.978: KUPW: End sequence number:
21-NOV-20 04:00:23.978: KUPW: **NOT** Doing Parallel metadata
21-NOV-20 04:00:23.978: KUPW: In procedure CONFIGURE_METADATA_UNLOAD
21-NOV-20 04:00:23.978: KUPW: Phase: Filter Name: BEGIN_AFTER Filter Value:
21-NOV-20 04:00:23.978: DBMS_METADATA.OPEN19.0.0
21-NOV-20 04:00:23.978: DBMS_METADATA.OPEN19.0.0
21-NOV-20 04:00:23.978: DBMS_METADATA.SET_FILTER
21-NOV-20 04:00:23.978: DBMS_METADATA.SET_FILTER
21-NOV-20 04:00:23.978: KUPW: In procedure DETERMINE_FATAL_ERROR with ORA-31600: invalid input value IN ('AUDIT_TRAILS') for parameter VALUE in function SET_FILTER
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA", line 7465
21-NOV-20 04:00:29.581: ORA-39126: Worker unexpected fatal error in KUPW$WORKER.CONFIGURE_METADATA_UNLOAD []
ORA-31600: invalid input value IN ('AUDIT_TRAILS') for parameter VALUE in function SET_FILTER
21-NOV-20 04:00:29.581: ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 12617
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA", line 7465
ORA-06512: at "SYS.KUPW$WORKER", line 9852
21-NOV-20 04:00:29.581: ----- PL/SQL Call Stack -----
object line object
handle number name
0x9c2fbd90 33543 package body SYS.KUPW$WORKER.WRITE_ERROR_INFORMATION
0x9c2fbd90 12651 package body SYS.KUPW$WORKER.DETERMINE_FATAL_ERROR
0x9c2fbd90 10244 package body SYS.KUPW$WORKER.CONFIGURE_METADATA_UNLOAD
0x9c2fbd90 3838 package body SYS.KUPW$WORKER.UNLOAD_METADATA
0x9c2fbd90 13746 package body SYS.KUPW$WORKER.DISPATCH_WORK_ITEMS
0x9c2fbd90 2439 package body SYS.KUPW$WORKER.MAIN
0x1468c2490 2 anonymous block
21-NOV-20 04:00:29.581: KUPW: Start sequence number:
21-NOV-20 04:00:29.581: KUPW: End sequence number:
21-NOV-20 04:00:29.581: KUPW: **NOT** Doing Parallel metadata
21-NOV-20 04:00:29.581: KUPW: In procedure CONFIGURE_METADATA_UNLOAD
21-NOV-20 04:00:29.581: KUPW: Phase: Filter Name: BEGIN_AFTER Filter Value:
21-NOV-20 04:00:29.581: DBMS_METADATA.OPEN19.0.0
21-NOV-20 04:00:29.581: DBMS_METADATA.OPEN19.0.0
21-NOV-20 04:00:29.581: DBMS_METADATA.SET_FILTER
21-NOV-20 04:00:29.581: DBMS_METADATA.SET_FILTER
21-NOV-20 04:00:29.581: KUPW: In procedure DETERMINE_FATAL_ERROR with ORA-31600: invalid input value IN ('AUDIT_TRAILS') for parameter VALUE in function SET_FILTER
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA", line 7465
21-NOV-20 04:00:30.908: ORA-39126: Worker unexpected fatal error in KUPW$WORKER.CONFIGURE_METADATA_UNLOAD []
ORA-31600: invalid input value IN ('AUDIT_TRAILS') for parameter VALUE in function SET_FILTER
21-NOV-20 04:00:30.908: ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 12617
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA", line 7465
ORA-06512: at "SYS.KUPW$WORKER", line 9852
21-NOV-20 04:00:30.908: ----- PL/SQL Call Stack -----
object line object
handle number name
0x16c975528 33543 package body SYS.KUPW$WORKER.WRITE_ERROR_INFORMATION
0x16c975528 12651 package body SYS.KUPW$WORKER.DETERMINE_FATAL_ERROR
0x16c975528 10244 package body SYS.KUPW$WORKER.CONFIGURE_METADATA_UNLOAD
0x16c975528 3838 package body SYS.KUPW$WORKER.UNLOAD_METADATA
0x16c975528 13746 package body SYS.KUPW$WORKER.DISPATCH_WORK_ITEMS
0x16c975528 2439 package body SYS.KUPW$WORKER.MAIN
0x19f73a038 2 anonymous block
21-NOV-20 04:00:30.908: KUPW: Start sequence number:
21-NOV-20 04:00:30.908: KUPW: End sequence number:
21-NOV-20 04:00:30.908: KUPW: **NOT** Doing Parallel metadata
21-NOV-20 04:00:30.908: KUPW: In procedure CONFIGURE_METADATA_UNLOAD
21-NOV-20 04:00:30.908: KUPW: Phase: Filter Name: BEGIN_AFTER Filter Value:
21-NOV-20 04:00:30.908: DBMS_METADATA.OPEN19.0.0
21-NOV-20 04:00:30.908: DBMS_METADATA.OPEN19.0.0
21-NOV-20 04:00:30.908: DBMS_METADATA.SET_FILTER
21-NOV-20 04:00:30.908: DBMS_METADATA.SET_FILTER
21-NOV-20 04:00:30.908: KUPW: In procedure DETERMINE_FATAL_ERROR with ORA-31600: invalid input value IN ('AUDIT_TRAILS') for parameter VALUE in function SET_FILTER
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA", line 7465
21-NOV-20 04:00:36.729: ORA-39126: Worker unexpected fatal error in KUPW$WORKER.CONFIGURE_METADATA_UNLOAD []
ORA-31600: invalid input value IN ('AUDIT_TRAILS') for parameter VALUE in function SET_FILTER
21-NOV-20 04:00:36.729: ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 12617
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA", line 7465
ORA-06512: at "SYS.KUPW$WORKER", line 9852
21-NOV-20 04:00:36.729: ----- PL/SQL Call Stack -----
object line object
handle number name
0x9c2fbd90 33543 package body SYS.KUPW$WORKER.WRITE_ERROR_INFORMATION
0x9c2fbd90 12651 package body SYS.KUPW$WORKER.DETERMINE_FATAL_ERROR
0x9c2fbd90 10244 package body SYS.KUPW$WORKER.CONFIGURE_METADATA_UNLOAD
0x9c2fbd90 3838 package body SYS.KUPW$WORKER.UNLOAD_METADATA
0x9c2fbd90 13746 package body SYS.KUPW$WORKER.DISPATCH_WORK_ITEMS
0x9c2fbd90 2439 package body SYS.KUPW$WORKER.MAIN
0x1468c2490 2 anonymous block
21-NOV-20 04:00:36.729: KUPW: Start sequence number:
21-NOV-20 04:00:36.729: KUPW: End sequence number:
21-NOV-20 04:00:36.729: KUPW: **NOT** Doing Parallel metadata
21-NOV-20 04:00:36.729: KUPW: In procedure CONFIGURE_METADATA_UNLOAD
21-NOV-20 04:00:36.729: KUPW: Phase: Filter Name: BEGIN_AFTER Filter Value:
21-NOV-20 04:00:36.729: DBMS_METADATA.OPEN19.0.0
21-NOV-20 04:00:36.729: DBMS_METADATA.OPEN19.0.0
21-NOV-20 04:00:36.729: DBMS_METADATA.SET_FILTER
21-NOV-20 04:00:36.729: DBMS_METADATA.SET_FILTER
21-NOV-20 04:00:36.729: KUPW: In procedure DETERMINE_FATAL_ERROR with ORA-31600: invalid input value IN ('AUDIT_TRAILS') for parameter VALUE in function SET_FILTER
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA", line 7465
21-NOV-20 04:00:38.329: ORA-39126: Worker unexpected fatal error in KUPW$WORKER.CONFIGURE_METADATA_UNLOAD []
ORA-31600: invalid input value IN ('AUDIT_TRAILS') for parameter VALUE in function SET_FILTER
21-NOV-20 04:00:38.329: ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 12617
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA", line 7465
ORA-06512: at "SYS.KUPW$WORKER", line 9852
21-NOV-20 04:00:38.329: ----- PL/SQL Call Stack -----
object line object
handle number name
0x16c975528 33543 package body SYS.KUPW$WORKER.WRITE_ERROR_INFORMATION
0x16c975528 12651 package body SYS.KUPW$WORKER.DETERMINE_FATAL_ERROR
0x16c975528 10244 package body SYS.KUPW$WORKER.CONFIGURE_METADATA_UNLOAD
0x16c975528 3838 package body SYS.KUPW$WORKER.UNLOAD_METADATA
0x16c975528 13746 package body SYS.KUPW$WORKER.DISPATCH_WORK_ITEMS
0x16c975528 2439 package body SYS.KUPW$WORKER.MAIN
0x19f73a038 2 anonymous block
21-NOV-20 04:00:38.329: KUPW: Start sequence number:
21-NOV-20 04:00:38.329: KUPW: End sequence number:
21-NOV-20 04:00:38.329: KUPW: **NOT** Doing Parallel metadata
21-NOV-20 04:00:38.329: KUPW: In procedure CONFIGURE_METADATA_UNLOAD
21-NOV-20 04:00:38.329: KUPW: Phase: Filter Name: BEGIN_AFTER Filter Value:
21-NOV-20 04:00:38.329: DBMS_METADATA.OPEN19.0.0
21-NOV-20 04:00:38.329: DBMS_METADATA.OPEN19.0.0
21-NOV-20 04:00:38.329: DBMS_METADATA.SET_FILTER
21-NOV-20 04:00:38.329: DBMS_METADATA.SET_FILTER
21-NOV-20 04:00:38.329: KUPW: In procedure DETERMINE_FATAL_ERROR with ORA-31600: invalid input value IN ('AUDIT_TRAILS') for parameter VALUE in function SET_FILTER
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA", line 7465
21-NOV-20 04:00:45.069: ORA-39126: Worker unexpected fatal error in KUPW$WORKER.CONFIGURE_METADATA_UNLOAD []
ORA-31600: invalid input value IN ('AUDIT_TRAILS') for parameter VALUE in function SET_FILTER
21-NOV-20 04:00:45.069: ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 12617
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA", line 7465
ORA-06512: at "SYS.KUPW$WORKER", line 9852
21-NOV-20 04:00:45.069: ----- PL/SQL Call Stack -----
object line object
handle number name
0x9c2fbd90 33543 package body SYS.KUPW$WORKER.WRITE_ERROR_INFORMATION
0x9c2fbd90 12651 package body SYS.KUPW$WORKER.DETERMINE_FATAL_ERROR
0x9c2fbd90 10244 package body SYS.KUPW$WORKER.CONFIGURE_METADATA_UNLOAD
0x9c2fbd90 3838 package body SYS.KUPW$WORKER.UNLOAD_METADATA
0x9c2fbd90 13746 package body SYS.KUPW$WORKER.DISPATCH_WORK_ITEMS
0x9c2fbd90 2439 package body SYS.KUPW$WORKER.MAIN
0x1468c2490 2 anonymous block
21-NOV-20 04:00:45.069: KUPW: Start sequence number:
21-NOV-20 04:00:45.069: KUPW: End sequence number:
21-NOV-20 04:00:45.069: KUPW: **NOT** Doing Parallel metadata
21-NOV-20 04:00:45.069: KUPW: In procedure CONFIGURE_METADATA_UNLOAD
21-NOV-20 04:00:45.069: KUPW: Phase: Filter Name: BEGIN_AFTER Filter Value:
21-NOV-20 04:00:45.069: DBMS_METADATA.OPEN19.0.0
21-NOV-20 04:00:45.069: DBMS_METADATA.OPEN19.0.0
21-NOV-20 04:00:45.069: DBMS_METADATA.SET_FILTER
21-NOV-20 04:00:45.069: DBMS_METADATA.SET_FILTER
21-NOV-20 04:00:45.069: KUPW: In procedure DETERMINE_FATAL_ERROR with ORA-31600: invalid input value IN ('AUDIT_TRAILS') for parameter VALUE in function SET_FILTER
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA", line 7465
21-NOV-20 04:00:46.579: ORA-39126: Worker unexpected fatal error in KUPW$WORKER.CONFIGURE_METADATA_UNLOAD []
ORA-31600: invalid input value IN ('AUDIT_TRAILS') for parameter VALUE in function SET_FILTER
21-NOV-20 04:00:46.579: ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 12617
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA", line 7465
ORA-06512: at "SYS.KUPW$WORKER", line 9852
21-NOV-20 04:00:46.579: ----- PL/SQL Call Stack -----
object line object
handle number name
0x16c975528 33543 package body SYS.KUPW$WORKER.WRITE_ERROR_INFORMATION
0x16c975528 12651 package body SYS.KUPW$WORKER.DETERMINE_FATAL_ERROR
0x16c975528 10244 package body SYS.KUPW$WORKER.CONFIGURE_METADATA_UNLOAD
0x16c975528 3838 package body SYS.KUPW$WORKER.UNLOAD_METADATA
0x16c975528 13746 package body SYS.KUPW$WORKER.DISPATCH_WORK_ITEMS
0x16c975528 2439 package body SYS.KUPW$WORKER.MAIN
0x19f73a038 2 anonymous block
21-NOV-20 04:00:46.579: KUPW: Start sequence number:
21-NOV-20 04:00:46.579: KUPW: End sequence number:
21-NOV-20 04:00:46.579: KUPW: **NOT** Doing Parallel metadata
21-NOV-20 04:00:46.579: KUPW: In procedure CONFIGURE_METADATA_UNLOAD
21-NOV-20 04:00:46.579: KUPW: Phase: Filter Name: BEGIN_AFTER Filter Value:
21-NOV-20 04:00:46.579: DBMS_METADATA.OPEN19.0.0
21-NOV-20 04:00:46.579: DBMS_METADATA.OPEN19.0.0
21-NOV-20 04:00:46.579: DBMS_METADATA.SET_FILTER
21-NOV-20 04:00:46.579: DBMS_METADATA.SET_FILTER
21-NOV-20 04:00:46.579: KUPW: In procedure DETERMINE_FATAL_ERROR with ORA-31600: invalid input value IN ('AUDIT_TRAILS') for parameter VALUE in function SET_FILTER
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA", line 7465
21-NOV-20 04:00:53.187: ORA-39126: Worker unexpected fatal error in KUPW$WORKER.CONFIGURE_METADATA_UNLOAD []
ORA-31600: invalid input value IN ('AUDIT_TRAILS') for parameter VALUE in function SET_FILTER
21-NOV-20 04:00:53.187: ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 12617
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA", line 7465
ORA-06512: at "SYS.KUPW$WORKER", line 9852
21-NOV-20 04:00:53.187: ----- PL/SQL Call Stack -----
object line object
handle number name
0x9c2fbd90 33543 package body SYS.KUPW$WORKER.WRITE_ERROR_INFORMATION
0x9c2fbd90 12651 package body SYS.KUPW$WORKER.DETERMINE_FATAL_ERROR
0x9c2fbd90 10244 package body SYS.KUPW$WORKER.CONFIGURE_METADATA_UNLOAD
0x9c2fbd90 3838 package body SYS.KUPW$WORKER.UNLOAD_METADATA
0x9c2fbd90 13746 package body SYS.KUPW$WORKER.DISPATCH_WORK_ITEMS
0x9c2fbd90 2439 package body SYS.KUPW$WORKER.MAIN
0x1468c2490 2 anonymous block
21-NOV-20 04:00:53.187: KUPW: Start sequence number:
21-NOV-20 04:00:53.187: KUPW: End sequence number:
21-NOV-20 04:00:53.187: KUPW: **NOT** Doing Parallel metadata
21-NOV-20 04:00:53.187: KUPW: In procedure CONFIGURE_METADATA_UNLOAD
21-NOV-20 04:00:53.187: KUPW: Phase: Filter Name: BEGIN_AFTER Filter Value:
21-NOV-20 04:00:53.187: DBMS_METADATA.OPEN19.0.0
21-NOV-20 04:00:53.187: DBMS_METADATA.OPEN19.0.0
21-NOV-20 04:00:53.187: DBMS_METADATA.SET_FILTER
21-NOV-20 04:00:53.187: DBMS_METADATA.SET_FILTER
21-NOV-20 04:00:53.187: KUPW: In procedure DETERMINE_FATAL_ERROR with ORA-31600: invalid input value IN ('AUDIT_TRAILS') for parameter VALUE in function SET_FILTER
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA", line 7465
21-NOV-20 04:00:53.192: Job "C##DBABACKUP"."SYS_EXPORT_FULL_05" stopped due to fatal error at Sat Nov 21 04:00:53 2020 elapsed 0 00:00:48
-
Any solution for this? I am facing the same error.
-
Did you try exporting using non-common user?
SY.
-
Thanks Solomon,
Yes i have tried with non common user. but facing the same error. My user is a local pdb user.
-
Just for a sanity check, issue:
SELECT COUNT(*) FROM DATABASE_EXPORT_OBJECTS WHERE OBJECT_PATH = 'AUDIT_TRAILS';
If you get zero then there were issues with 19C upgrade (or some steps were missed).
SY.
