Forum Stats

  • 3,780,546 Users
  • 2,254,409 Discussions
  • 7,879,379 Comments

Discussions

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?

Tagged:

Answers

  • JohnWatson2
    JohnWatson2 Member Posts: 4,355 Silver Crown

    I would usually do something like this,


    expdp system/oracle full=y include=audit_trails file=aud.dmp

  • chileme88
    chileme88 Member Posts: 52 Blue Ribbon

    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

  • User_C0IWG
    User_C0IWG Member Posts: 2 Red Ribbon

    Any solution for this? I am facing the same error.

  • Solomon Yakobson
    Solomon Yakobson Member Posts: 19,005 Red Diamond

    Did you try exporting using non-common user?

    SY.

  • User_C0IWG
    User_C0IWG Member Posts: 2 Red Ribbon

    Thanks Solomon,

    Yes i have tried with non common user. but facing the same error. My user is a local pdb user.

  • Solomon Yakobson
    Solomon Yakobson Member Posts: 19,005 Red Diamond

    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.