19c CDB架构下使用具有SYSBACKUP权限用户执行DataPump-expdp报ORA-01045和ORA-39406
适用范围
Oracle Database 19c
问题概述
19c CDB架构中使用具有sysbackup权限的用户或者sysbackup角色用户执行expdp报以下错误
再次执行expdp
FULL=Y
[oracle@19cdb01 ~]$ expdp 'C##BACKUPUSER/<your_password>@hrpdb' directory=IMP_DIR dumpfile=hrpdb_full_20260706.dmp full=y logfile=hrpdb_full_log_20260706.log logtime=all Export: Release 19.0.0.0.0 - Production on Mon Jul 06 18:08:40 2026 Version 19.27.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 06-JUL-26 18:08:45.659: Starting "C##BACKUPUSER"."SYS_EXPORT_FULL_01": C##BACKUPUSER/********@hrpdb directory=IMP_DIR dumpfile=hrpdb_full_20260706.dmp full=y logfile=hrpdb_full_log_20260706.log logtime=all 06-JUL-26 18:08:51.565: Processing object type DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA 06-JUL-26 18:08:52.837: Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/TABLE_DATA 06-JUL-26 18:08:53.860: Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA 06-JUL-26 18:08:55.125: Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA 06-JUL-26 18:08:55.435: Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/INDEX_STATISTICS 06-JUL-26 18:08:55.631: Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/FUNCTIONAL_INDEX/INDEX_STATISTICS 06-JUL-26 18:08:55.775: Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/BITMAP_INDEX/INDEX_STATISTICS 06-JUL-26 18:08:55.927: Processing object type DATABASE_EXPORT/SCHEMA/TABLE/STATISTICS/TABLE_STATISTICS 06-JUL-26 18:09:01.318: Processing object type DATABASE_EXPORT/STATISTICS/MARKER 06-JUL-26 18:09:01.972: Processing object type DATABASE_EXPORT/PRE_SYSTEM_IMPCALLOUT/MARKER 06-JUL-26 18:09:02.078: Processing object type DATABASE_EXPORT/PRE_INSTANCE_IMPCALLOUT/MARKER 06-JUL-26 18:09:02.378: Processing object type DATABASE_EXPORT/TABLESPACE 06-JUL-26 18:09:02.662: Processing object type DATABASE_EXPORT/PROFILE 06-JUL-26 18:09:02.844: Processing object type DATABASE_EXPORT/SCHEMA/USER 06-JUL-26 18:09:03.271: Processing object type DATABASE_EXPORT/ROLE 06-JUL-26 18:09:03.480: Processing object type DATABASE_EXPORT/RADM_FPTM 06-JUL-26 18:09:04.301: Processing object type DATABASE_EXPORT/GRANT/SYSTEM_GRANT/PROC_SYSTEM_GRANT 06-JUL-26 18:09:04.503: Processing object type DATABASE_EXPORT/SCHEMA/GRANT/SYSTEM_GRANT 06-JUL-26 18:09:04.657: Processing object type DATABASE_EXPORT/SCHEMA/ROLE_GRANT 06-JUL-26 18:09:04.812: Processing object type DATABASE_EXPORT/SCHEMA/DEFAULT_ROLE 06-JUL-26 18:09:04.934: Processing object type DATABASE_EXPORT/SCHEMA/ON_USER_GRANT 06-JUL-26 18:09:05.139: Processing object type DATABASE_EXPORT/SCHEMA/TABLESPACE_QUOTA 06-JUL-26 18:09:05.231: Processing object type DATABASE_EXPORT/RESOURCE_COST 06-JUL-26 18:09:05.591: Processing object type DATABASE_EXPORT/TRUSTED_DB_LINK 06-JUL-26 18:09:05.754: Processing object type DATABASE_EXPORT/SCHEMA/SEQUENCE/SEQUENCE 06-JUL-26 18:09:07.579: Processing object type DATABASE_EXPORT/DIRECTORY/DIRECTORY 06-JUL-26 18:09:08.192: Processing object type DATABASE_EXPORT/DIRECTORY/GRANT/OWNER_GRANT/OBJECT_GRANT 06-JUL-26 18:09:09.477: Processing object type DATABASE_EXPORT/SCHEMA/SYNONYM 06-JUL-26 18:09:09.676: Processing object type DATABASE_EXPORT/SCHEMA/TYPE/INC_TYPE 06-JUL-26 18:09:10.572: Processing object type DATABASE_EXPORT/SCHEMA/TYPE/TYPE_SPEC 06-JUL-26 18:09:11.106: Processing object type DATABASE_EXPORT/SCHEMA/TYPE/GRANT/OWNER_GRANT/OBJECT_GRANT 06-JUL-26 18:09:11.999: Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIONS/PROCACT_SYSTEM 06-JUL-26 18:09:12.360: Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PROCOBJ 06-JUL-26 18:09:28.548: Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/POST_SYSTEM_ACTIONS/PROCACT_SYSTEM 06-JUL-26 18:09:28.716: Processing object type DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMA 06-JUL-26 18:09:36.740: Processing object type DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE 06-JUL-26 18:09:36.815: Processing object type DATABASE_EXPORT/EARLY_POST_INSTANCE_IMPCALLOUT/MARKER 06-JUL-26 18:09:37.444: Processing object type DATABASE_EXPORT/SCHEMA/XMLSCHEMA/XMLSCHEMA 06-JUL-26 18:09:53.050: Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/TABLE 06-JUL-26 18:10:20.106: Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE 06-JUL-26 18:10:35.976: Processing object type DATABASE_EXPORT/NORMAL_POST_INSTANCE_IMPCALLOUT/MARKER 06-JUL-26 18:10:38.397: Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE 06-JUL-26 18:11:08.472: Processing object type DATABASE_EXPORT/SCHEMA/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT 06-JUL-26 18:11:09.430: Processing object type DATABASE_EXPORT/SCHEMA/TABLE/COMMENT 06-JUL-26 18:11:10.757: Processing object type DATABASE_EXPORT/SCHEMA/FUNCTION/FUNCTION 06-JUL-26 18:11:12.336: Processing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/PROCEDURE 06-JUL-26 18:11:14.019: Processing object type DATABASE_EXPORT/SCHEMA/FUNCTION/ALTER_FUNCTION 06-JUL-26 18:11:14.124: Processing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/ALTER_PROCEDURE 06-JUL-26 18:11:16.102: Processing object type DATABASE_EXPORT/SCHEMA/VIEW/VIEW 06-JUL-26 18:11:16.715: Processing object type DATABASE_EXPORT/SCHEMA/VIEW/GRANT/OWNER_GRANT/OBJECT_GRANT 06-JUL-26 18:11:17.519: Processing object type DATABASE_EXPORT/SCHEMA/VIEW/COMMENT 06-JUL-26 18:11:17.928: Processing object type DATABASE_EXPORT/SCHEMA/TYPE/TYPE_BODY 06-JUL-26 18:11:19.103: Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/INDEX 06-JUL-26 18:11:19.876: Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/FUNCTIONAL_INDEX/INDEX 06-JUL-26 18:11:21.694: Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/CONSTRAINT 06-JUL-26 18:11:24.905: Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/REF_CONSTRAINT 06-JUL-26 18:11:25.468: Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/BITMAP_INDEX/INDEX 06-JUL-26 18:11:27.480: Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/DOMAIN_INDEX/INDEX 06-JUL-26 18:11:27.696: Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TRIGGER 06-JUL-26 18:11:27.789: Processing object type DATABASE_EXPORT/SCHEMA/VIEW/TRIGGER 06-JUL-26 18:11:49.986: Processing object type DATABASE_EXPORT/SCHEMA/MATERIALIZED_VIEW 06-JUL-26 18:12:09.300: Processing object type DATABASE_EXPORT/SCHEMA/DIMENSION 06-JUL-26 18:12:10.148: Processing object type DATABASE_EXPORT/FINAL_POST_INSTANCE_IMPCALLOUT/MARKER 06-JUL-26 18:12:10.334: Processing object type DATABASE_EXPORT/SCHEMA/TABLE/POST_INSTANCE/PROCACT_INSTANCE 06-JUL-26 18:12:10.616: Processing object type DATABASE_EXPORT/SCHEMA/TABLE/POST_INSTANCE/PROCDEPOBJ 06-JUL-26 18:12:11.108: Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCOBJ 06-JUL-26 18:12:11.748: Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCACT_SCHEMA 06-JUL-26 18:12:17.120: Processing object type DATABASE_EXPORT/AUDIT_UNIFIED/AUDIT_POLICY_ENABLE 06-JUL-26 18:12:17.376: Processing object type DATABASE_EXPORT/POST_SYSTEM_IMPCALLOUT/MARKER 06-JUL-26 18:12:18.245: . . exported "SYS"."KU$_USER_MAPPING_VIEW" 6.226 KB 49 rows 06-JUL-26 18:12:18.617: . . exported "AUDSYS"."AUD$UNIFIED":"SYS_P221" 14.89 MB 7085 rows 06-JUL-26 18:12:18.669: . . exported "AUDSYS"."AUD$UNIFIED":"SYS_P508" 160.7 KB 132 rows 06-JUL-26 18:12:18.742: . . exported "AUDSYS"."AUD$UNIFIED":"SYS_P401" 85.50 KB 62 rows 06-JUL-26 18:12:18.802: . . exported "AUDSYS"."AUD$UNIFIED":"SYS_P768" 68.09 KB 27 rows 06-JUL-26 18:12:18.848: . . exported "AUDSYS"."AUD$UNIFIED":"SYS_P588" 67.69 KB 33 rows 06-JUL-26 18:12:18.890: . . exported "AUDSYS"."AUD$UNIFIED":"SYS_P728" 58.75 KB 12 rows 06-JUL-26 18:12:18.934: . . exported "AUDSYS"."AUD$UNIFIED":"SYS_P708" 56.49 KB 15 rows 06-JUL-26 18:12:18.980: . . exported "AUDSYS"."AUD$UNIFIED":"SYS_P441" 52.66 KB 1 rows 06-JUL-26 18:12:19.026: . . exported "AUDSYS"."AUD$UNIFIED":"SYS_P381" 51.32 KB 1 rows 06-JUL-26 18:12:19.069: . . exported "SYSTEM"."REDO_DB" 25.59 KB 1 rows 06-JUL-26 18:12:19.104: . . exported "SYS"."AUD$" 24.10 KB 5 rows 06-JUL-26 18:12:19.153: . . exported "WMSYS"."WM$WORKSPACES_TABLE$" 12.10 KB 1 rows 06-JUL-26 18:12:19.187: . . exported "WMSYS"."WM$HINT_TABLE$" 9.984 KB 97 rows 06-JUL-26 18:12:19.237: . . exported "LBACSYS"."OLS$INSTALLATIONS" 6.960 KB 2 rows 06-JUL-26 18:12:19.272: . . exported "WMSYS"."WM$WORKSPACE_PRIV_TABLE$" 7.078 KB 11 rows 06-JUL-26 18:12:19.299: . . exported "SYS"."DAM_CONFIG_PARAM$" 6.531 KB 14 rows 06-JUL-26 18:12:19.331: . . exported "SYS"."TSDP_SUBPOL$" 6.328 KB 1 rows 06-JUL-26 18:12:19.383: . . exported "WMSYS"."WM$NEXTVER_TABLE$" 6.375 KB 1 rows 06-JUL-26 18:12:19.417: . . exported "LBACSYS"."OLS$PROPS" 6.234 KB 5 rows 06-JUL-26 18:12:19.450: . . exported "WMSYS"."WM$ENV_VARS$" 6.015 KB 3 rows 06-JUL-26 18:12:19.481: . . exported "SYS"."TSDP_PARAMETER$" 5.953 KB 1 rows 06-JUL-26 18:12:19.523: . . exported "SYS"."TSDP_POLICY$" 5.921 KB 1 rows 06-JUL-26 18:12:19.561: . . exported "WMSYS"."WM$VERSION_HIERARCHY_TABLE$" 5.984 KB 1 rows 06-JUL-26 18:12:19.589: . . exported "WMSYS"."WM$EVENTS_INFO$" 5.812 KB 12 rows 06-JUL-26 18:12:19.621: . . exported "LBACSYS"."OLS$AUDIT_ACTIONS" 5.757 KB 8 rows 06-JUL-26 18:12:19.650: . . exported "LBACSYS"."OLS$DIP_EVENTS" 5.539 KB 2 rows 06-JUL-26 18:12:19.690: . . exported "AUDSYS"."AUD$UNIFIED":"AUD_UNIFIED_P0" 50.95 KB 0 rows 06-JUL-26 18:12:19.732: . . exported "AUDSYS"."AUD$UNIFIED":"SYS_P828" 57.49 KB 19 rows 06-JUL-26 18:12:19.739: . . exported "LBACSYS"."OLS$AUDIT" 0 KB 0 rows 06-JUL-26 18:12:19.746: . . exported "LBACSYS"."OLS$COMPARTMENTS" 0 KB 0 rows 06-JUL-26 18:12:19.753: . . exported "LBACSYS"."OLS$DIP_DEBUG" 0 KB 0 rows 06-JUL-26 18:12:19.761: . . exported "LBACSYS"."OLS$GROUPS" 0 KB 0 rows 06-JUL-26 18:12:19.769: . . exported "LBACSYS"."OLS$LAB" 0 KB 0 rows 06-JUL-26 18:12:19.776: . . exported "LBACSYS"."OLS$LEVELS" 0 KB 0 rows 06-JUL-26 18:12:19.781: . . exported "LBACSYS"."OLS$POL" 0 KB 0 rows 06-JUL-26 18:12:19.787: . . exported "LBACSYS"."OLS$POLICY_ADMIN" 0 KB 0 rows 06-JUL-26 18:12:19.794: . . exported "LBACSYS"."OLS$POLS" 0 KB 0 rows 06-JUL-26 18:12:19.802: . . exported "LBACSYS"."OLS$POLT" 0 KB 0 rows 06-JUL-26 18:12:19.809: . . exported "LBACSYS"."OLS$PROFILE" 0 KB 0 rows 06-JUL-26 18:12:19.817: . . exported "LBACSYS"."OLS$PROFILES" 0 KB 0 rows 06-JUL-26 18:12:19.822: . . exported "LBACSYS"."OLS$PROG" 0 KB 0 rows 06-JUL-26 18:12:19.834: . . exported "LBACSYS"."OLS$SESSINFO" 0 KB 0 rows 06-JUL-26 18:12:19.841: . . exported "LBACSYS"."OLS$USER" 0 KB 0 rows 06-JUL-26 18:12:19.848: . . exported "LBACSYS"."OLS$USER_COMPARTMENTS" 0 KB 0 rows 06-JUL-26 18:12:19.854: . . exported "LBACSYS"."OLS$USER_GROUPS" 0 KB 0 rows 06-JUL-26 18:12:19.858: . . exported "LBACSYS"."OLS$USER_LEVELS" 0 KB 0 rows 06-JUL-26 18:12:19.888: . . exported "SYS"."DAM_CLEANUP_EVENTS$" 7.187 KB 0 rows 06-JUL-26 18:12:19.933: . . exported "SYS"."DAM_CLEANUP_JOBS$" 7.171 KB 0 rows 06-JUL-26 18:12:19.941: . . exported "SYS"."TSDP_ASSOCIATION$" 0 KB 0 rows 06-JUL-26 18:12:19.948: . . exported "SYS"."TSDP_CONDITION$" 0 KB 0 rows 06-JUL-26 18:12:19.954: . . exported "SYS"."TSDP_FEATURE_POLICY$" 0 KB 0 rows 06-JUL-26 18:12:19.964: . . exported "SYS"."TSDP_PROTECTION$" 0 KB 0 rows 06-JUL-26 18:12:19.975: . . exported "SYS"."TSDP_SENSITIVE_DATA$" 0 KB 0 rows 06-JUL-26 18:12:19.990: . . exported "SYS"."TSDP_SENSITIVE_TYPE$" 0 KB 0 rows 06-JUL-26 18:12:19.997: . . exported "SYS"."TSDP_SOURCE$" 0 KB 0 rows 06-JUL-26 18:12:20.005: . . exported "SYSTEM"."REDO_LOG" 0 KB 0 rows 06-JUL-26 18:12:20.013: . . exported "WMSYS"."WM$BATCH_COMPRESSIBLE_TABLES$" 0 KB 0 rows 06-JUL-26 18:12:20.022: . . exported "WMSYS"."WM$CONSTRAINTS_TABLE$" 0 KB 0 rows 06-JUL-26 18:12:20.030: . . exported "WMSYS"."WM$CONS_COLUMNS$" 0 KB 0 rows 06-JUL-26 18:12:20.035: . . exported "WMSYS"."WM$LOCKROWS_INFO$" 0 KB 0 rows 06-JUL-26 18:12:20.043: . . exported "WMSYS"."WM$MODIFIED_TABLES$" 0 KB 0 rows 06-JUL-26 18:12:20.050: . . exported "WMSYS"."WM$MP_GRAPH_WORKSPACES_TABLE$" 0 KB 0 rows 06-JUL-26 18:12:20.057: . . exported "WMSYS"."WM$MP_PARENT_WORKSPACES_TABLE$" 0 KB 0 rows 06-JUL-26 18:12:20.064: . . exported "WMSYS"."WM$NESTED_COLUMNS_TABLE$" 0 KB 0 rows 06-JUL-26 18:12:20.070: . . exported "WMSYS"."WM$RESOLVE_WORKSPACES_TABLE$" 0 KB 0 rows 06-JUL-26 18:12:20.077: . . exported "WMSYS"."WM$RIC_LOCKING_TABLE$" 0 KB 0 rows 06-JUL-26 18:12:20.085: . . exported "WMSYS"."WM$RIC_TABLE$" 0 KB 0 rows 06-JUL-26 18:12:20.092: . . exported "WMSYS"."WM$RIC_TRIGGERS_TABLE$" 0 KB 0 rows 06-JUL-26 18:12:20.098: . . exported "WMSYS"."WM$UDTRIG_DISPATCH_PROCS$" 0 KB 0 rows 06-JUL-26 18:12:20.106: . . exported "WMSYS"."WM$UDTRIG_INFO$" 0 KB 0 rows 06-JUL-26 18:12:20.117: . . exported "WMSYS"."WM$VERSION_TABLE$" 0 KB 0 rows 06-JUL-26 18:12:20.130: . . exported "WMSYS"."WM$VT_ERRORS_TABLE$" 0 KB 0 rows 06-JUL-26 18:12:20.142: . . exported "WMSYS"."WM$WORKSPACE_SAVEPOINTS_TABLE$" 0 KB 0 rows 06-JUL-26 18:12:20.291: . . exported "MDSYS"."RDF_PARAM$" 6.515 KB 3 rows 06-JUL-26 18:12:20.531: . . exported "SYS"."AUDTAB$TBS$FOR_EXPORT" 5.960 KB 2 rows 06-JUL-26 18:12:20.546: . . exported "SYS"."DBA_SENSITIVE_DATA" 0 KB 0 rows 06-JUL-26 18:12:20.557: . . exported "SYS"."DBA_TSDP_POLICY_PROTECTION" 0 KB 0 rows 06-JUL-26 18:12:20.565: . . exported "SYS"."FGA_LOG$FOR_EXPORT" 0 KB 0 rows 06-JUL-26 18:12:20.621: . . exported "SYS"."NACL$_ACE_EXP" 0 KB 0 rows 06-JUL-26 18:12:20.765: . . exported "SYS"."NACL$_HOST_EXP" 6.914 KB 1 rows 06-JUL-26 18:12:20.773: . . exported "SYS"."NACL$_WALLET_EXP" 0 KB 0 rows 06-JUL-26 18:12:20.782: . . exported "SYS"."SQL$TEXT_DATAPUMP" 0 KB 0 rows 06-JUL-26 18:12:20.790: . . exported "SYS"."SQL$_DATAPUMP" 0 KB 0 rows 06-JUL-26 18:12:20.799: . . exported "SYS"."SQLOBJ$AUXDATA_DATAPUMP" 0 KB 0 rows 06-JUL-26 18:12:20.807: . . exported "SYS"."SQLOBJ$DATA_DATAPUMP" 0 KB 0 rows 06-JUL-26 18:12:20.815: . . exported "SYS"."SQLOBJ$PLAN_DATAPUMP" 0 KB 0 rows 06-JUL-26 18:12:20.824: . . exported "SYS"."SQLOBJ$_DATAPUMP" 0 KB 0 rows 06-JUL-26 18:12:20.886: . . exported "SYSTEM"."SCHEDULER_JOB_ARGS" 0 KB 0 rows 06-JUL-26 18:12:20.916: . . exported "SYSTEM"."SCHEDULER_PROGRAM_ARGS" 0 KB 0 rows 06-JUL-26 18:12:23.991: . . exported "WMSYS"."WM$EXP_MAP" 7.718 KB 3 rows 06-JUL-26 18:12:25.923: . . exported "WMSYS"."WM$METADATA_MAP" 0 KB 0 rows 06-JUL-26 18:12:26.022: . . exported "HFXF"."BAK_TMP_HIST_SESS" 10.66 MB 25488 rows 06-JUL-26 18:12:26.137: . . exported "SH"."CUSTOMERS" 10.27 MB 55500 rows 06-JUL-26 18:12:26.244: . . exported "OE"."PRODUCT_DESCRIPTIONS" 2.379 MB 8640 rows 06-JUL-26 18:12:26.360: . . exported "SH"."SALES":"SALES_Q4_2001" 2.257 MB 69749 rows 06-JUL-26 18:12:26.436: . . exported "SH"."SALES":"SALES_Q3_1999" 2.166 MB 67138 rows 06-JUL-26 18:12:26.504: . . exported "SH"."SALES":"SALES_Q3_2001" 2.130 MB 65769 rows 06-JUL-26 18:12:26.571: . . exported "SH"."SALES":"SALES_Q2_2001" 2.051 MB 63292 rows 06-JUL-26 18:12:26.684: . . exported "SH"."SALES":"SALES_Q1_1999" 2.071 MB 64186 rows 06-JUL-26 18:12:26.774: . . exported "SH"."SALES":"SALES_Q1_2001" 1.965 MB 60608 rows 06-JUL-26 18:12:26.844: . . exported "SH"."SALES":"SALES_Q4_1999" 2.014 MB 62388 rows 06-JUL-26 18:12:26.931: . . exported "SH"."SALES":"SALES_Q1_2000" 2.012 MB 62197 rows 06-JUL-26 18:12:27.002: . . exported "SH"."SALES":"SALES_Q3_2000" 1.910 MB 58950 rows 06-JUL-26 18:12:27.130: . . exported "SH"."SALES":"SALES_Q4_2000" 1.814 MB 55984 rows 06-JUL-26 18:12:27.215: . . exported "SH"."SALES":"SALES_Q2_2000" 1.802 MB 55515 rows 06-JUL-26 18:12:27.297: . . exported "SH"."SALES":"SALES_Q2_1999" 1.754 MB 54233 rows 06-JUL-26 18:12:27.359: . . exported "SH"."SALES":"SALES_Q3_1998" 1.634 MB 50515 rows 06-JUL-26 18:12:27.411: . . exported "SH"."SALES":"SALES_Q4_1998" 1.581 MB 48874 rows 06-JUL-26 18:12:27.459: . . exported "SH"."SALES":"SALES_Q1_1998" 1.413 MB 43687 rows 06-JUL-26 18:12:27.505: . . exported "SH"."SALES":"SALES_Q2_1998" 1.160 MB 35758 rows 06-JUL-26 18:12:27.593: . . exported "SH"."SUPPLEMENTARY_DEMOGRAPHICS" 697.6 KB 4500 rows 06-JUL-26 18:12:27.679: . . exported "SH"."TIMES" 381.7 KB 1826 rows 06-JUL-26 18:12:27.725: . . exported "SH"."FWEEK_PSCAT_SALES_MV" 419.9 KB 11266 rows 06-JUL-26 18:12:27.768: . . exported "SH"."COSTS":"COSTS_Q4_2001" 278.5 KB 9011 rows 06-JUL-26 18:12:27.825: . . exported "SH"."COSTS":"COSTS_Q3_2001" 234.6 KB 7545 rows 06-JUL-26 18:12:27.880: . . exported "SH"."COSTS":"COSTS_Q1_2001" 228.0 KB 7328 rows 06-JUL-26 18:12:27.926: . . exported "SH"."COSTS":"COSTS_Q2_2001" 184.7 KB 5882 rows 06-JUL-26 18:12:27.971: . . exported "SH"."COSTS":"COSTS_Q1_1999" 183.7 KB 5884 rows 06-JUL-26 18:12:28.014: . . exported "SH"."COSTS":"COSTS_Q4_2000" 160.4 KB 5088 rows 06-JUL-26 18:12:28.052: . . exported "SH"."COSTS":"COSTS_Q4_1999" 159.2 KB 5060 rows 06-JUL-26 18:12:28.096: . . exported "SH"."COSTS":"COSTS_Q3_2000" 151.6 KB 4798 rows 06-JUL-26 18:12:28.160: . . exported "SH"."COSTS":"COSTS_Q4_1998" 144.8 KB 4577 rows 06-JUL-26 18:12:28.206: . . exported "SH"."COSTS":"COSTS_Q1_1998" 139.6 KB 4411 rows 06-JUL-26 18:12:28.250: . . exported "SH"."COSTS":"COSTS_Q3_1999" 137.5 KB 4336 rows 06-JUL-26 18:12:28.285: . . exported "SH"."COSTS":"COSTS_Q2_1999" 132.7 KB 4179 rows 06-JUL-26 18:12:28.336: . . exported "SH"."COSTS":"COSTS_Q3_1998" 131.3 KB 4129 rows 06-JUL-26 18:12:28.387: . . exported "SH"."COSTS":"COSTS_Q2_2000" 119.1 KB 3715 rows 06-JUL-26 18:12:28.432: . . exported "SH"."COSTS":"COSTS_Q1_2000" 120.7 KB 3772 rows 06-JUL-26 18:12:28.581: ORA-39181: Only partial table data may be exported due to fine grain access control on "OE"."PURCHASEORDER" 06-JUL-26 18:12:28.601: . . exported "OE"."PURCHASEORDER" 0 KB 0 rows 06-JUL-26 18:12:28.659: . . exported "OE"."PRODUCT_INFORMATION" 73.05 KB 288 rows 06-JUL-26 18:12:28.690: . . exported "SH"."COSTS":"COSTS_Q2_1998" 79.68 KB 2397 rows 06-JUL-26 18:12:28.738: . . exported "OE"."CUSTOMERS" 81.17 KB 319 rows 06-JUL-26 18:12:28.780: . . exported "SH"."PROMOTIONS" 59.17 KB 503 rows 06-JUL-26 18:12:28.817: . . exported "SH"."PRODUCTS" 26.71 KB 72 rows 06-JUL-26 18:12:28.861: . . exported "HR"."PLAN_TABLE" 25.99 KB 8 rows 06-JUL-26 18:12:29.064: . . exported "PM"."PRINT_MEDIA" 190.6 KB 4 rows 06-JUL-26 18:12:29.143: . . exported "OE"."ORDER_ITEMS" 21.01 KB 665 rows 06-JUL-26 18:12:29.194: . . exported "OE"."INVENTORIES" 21.76 KB 1112 rows 06-JUL-26 18:12:29.227: . . exported "HR"."EMP3" 17.08 KB 107 rows 06-JUL-26 18:12:29.268: . . exported "HR"."EMPLOYEES" 17.08 KB 107 rows 06-JUL-26 18:12:29.503: . . exported "HR"."EMP2" 16.57 KB 107 rows 06-JUL-26 18:12:29.592: . . exported "PM"."TEXTDOCS_NESTEDTAB" 87.85 KB 12 rows 06-JUL-26 18:12:29.620: . . exported "OE"."PRODUCT_REF_LIST_NESTEDTAB" 12.57 KB 288 rows 06-JUL-26 18:12:29.650: . . exported "OE"."ORDERS" 12.59 KB 105 rows 06-JUL-26 18:12:29.679: . . exported "IX"."AQ$_STREAMS_QUEUE_TABLE_S" 11.57 KB 1 rows 06-JUL-26 18:12:29.708: . . exported "IX"."AQ$_ORDERS_QUEUETABLE_S" 11.30 KB 4 rows 06-JUL-26 18:12:29.739: . . exported "SH"."COUNTRIES" 10.46 KB 23 rows 06-JUL-26 18:12:29.776: . . exported "IX"."AQ$_ORDERS_QUEUETABLE_H" 0 KB 0 rows 06-JUL-26 18:12:29.783: . . exported "IX"."AQ$_ORDERS_QUEUETABLE_I" 0 KB 0 rows 06-JUL-26 18:12:29.846: . . exported "OE"."CATEGORIES_TAB" 14.43 KB 22 rows 06-JUL-26 18:12:29.880: . . exported "HR"."LOCATIONS" 8.437 KB 23 rows 06-JUL-26 18:12:30.065: . . exported "OE"."WAREHOUSES" 12.73 KB 9 rows 06-JUL-26 18:12:30.125: . . exported "SH"."CHANNELS" 7.414 KB 5 rows 06-JUL-26 18:12:30.154: . . exported "HR"."JOB_HISTORY" 7.195 KB 10 rows 06-JUL-26 18:12:30.193: . . exported "HR"."JOBS" 7.109 KB 19 rows 06-JUL-26 18:12:30.223: . . exported "HR"."DEPARTMENTS" 7.125 KB 27 rows 06-JUL-26 18:12:30.265: . . exported "OE"."SUBCATEGORY_REF_LIST_NESTEDTAB" 6.656 KB 21 rows 06-JUL-26 18:12:30.471: . . exported "HR"."COUNTRIES" 6.367 KB 25 rows 06-JUL-26 18:12:30.569: . . exported "SH"."CAL_MONTH_SALES_MV" 6.382 KB 48 rows 06-JUL-26 18:12:30.631: . . exported "HR"."REGIONS" 5.546 KB 4 rows 06-JUL-26 18:12:30.678: . . exported "OE"."PROMOTIONS" 5.570 KB 2 rows 06-JUL-26 18:12:30.738: . . exported "EXPOER"."SYS_EXPORT_FULL_01" 660.4 KB 3591 rows 06-JUL-26 18:12:30.790: . . exported "IX"."AQ$_ORDERS_QUEUETABLE_G" 0 KB 0 rows 06-JUL-26 18:12:30.828: . . exported "IX"."AQ$_ORDERS_QUEUETABLE_L" 0 KB 0 rows 06-JUL-26 18:12:30.867: . . exported "IX"."AQ$_ORDERS_QUEUETABLE_T" 0 KB 0 rows 06-JUL-26 18:12:30.878: . . exported "IX"."AQ$_STREAMS_QUEUE_TABLE_C" 0 KB 0 rows 06-JUL-26 18:12:30.889: . . exported "IX"."AQ$_STREAMS_QUEUE_TABLE_G" 0 KB 0 rows 06-JUL-26 18:12:30.896: . . exported "IX"."AQ$_STREAMS_QUEUE_TABLE_H" 0 KB 0 rows 06-JUL-26 18:12:30.901: . . exported "IX"."AQ$_STREAMS_QUEUE_TABLE_I" 0 KB 0 rows 06-JUL-26 18:12:30.948: . . exported "IX"."AQ$_STREAMS_QUEUE_TABLE_L" 0 KB 0 rows 06-JUL-26 18:12:31.010: . . exported "IX"."AQ$_STREAMS_QUEUE_TABLE_T" 0 KB 0 rows 06-JUL-26 18:12:31.019: . . exported "IX"."ORDERS_QUEUETABLE" 0 KB 0 rows 06-JUL-26 18:12:31.026: . . exported "IX"."STREAMS_QUEUE_TABLE" 0 KB 0 rows 06-JUL-26 18:12:31.089: . . exported "PM"."ONLINE_MEDIA" 0 KB 0 rows 06-JUL-26 18:12:31.098: . . exported "SH"."COSTS":"COSTS_1995" 0 KB 0 rows 06-JUL-26 18:12:31.104: . . exported "SH"."COSTS":"COSTS_1996" 0 KB 0 rows 06-JUL-26 18:12:31.109: . . exported "SH"."COSTS":"COSTS_H1_1997" 0 KB 0 rows 06-JUL-26 18:12:31.114: . . exported "SH"."COSTS":"COSTS_H2_1997" 0 KB 0 rows 06-JUL-26 18:12:31.119: . . exported "SH"."COSTS":"COSTS_Q1_2002" 0 KB 0 rows 06-JUL-26 18:12:31.125: . . exported "SH"."COSTS":"COSTS_Q1_2003" 0 KB 0 rows 06-JUL-26 18:12:31.131: . . exported "SH"."COSTS":"COSTS_Q2_2002" 0 KB 0 rows 06-JUL-26 18:12:31.136: . . exported "SH"."COSTS":"COSTS_Q2_2003" 0 KB 0 rows 06-JUL-26 18:12:31.142: . . exported "SH"."COSTS":"COSTS_Q3_2002" 0 KB 0 rows 06-JUL-26 18:12:31.146: . . exported "SH"."COSTS":"COSTS_Q3_2003" 0 KB 0 rows 06-JUL-26 18:12:31.151: . . exported "SH"."COSTS":"COSTS_Q4_2002" 0 KB 0 rows 06-JUL-26 18:12:31.156: . . exported "SH"."COSTS":"COSTS_Q4_2003" 0 KB 0 rows 06-JUL-26 18:12:31.162: . . exported "SH"."SALES":"SALES_1995" 0 KB 0 rows 06-JUL-26 18:12:31.173: . . exported "SH"."SALES":"SALES_1996" 0 KB 0 rows 06-JUL-26 18:12:31.183: . . exported "SH"."SALES":"SALES_H1_1997" 0 KB 0 rows 06-JUL-26 18:12:31.191: . . exported "SH"."SALES":"SALES_H2_1997" 0 KB 0 rows 06-JUL-26 18:12:31.197: . . exported "SH"."SALES":"SALES_Q1_2002" 0 KB 0 rows 06-JUL-26 18:12:31.206: . . exported "SH"."SALES":"SALES_Q1_2003" 0 KB 0 rows 06-JUL-26 18:12:31.213: . . exported "SH"."SALES":"SALES_Q2_2002" 0 KB 0 rows 06-JUL-26 18:12:31.220: . . exported "SH"."SALES":"SALES_Q2_2003" 0 KB 0 rows 06-JUL-26 18:12:31.225: . . exported "SH"."SALES":"SALES_Q3_2002" 0 KB 0 rows 06-JUL-26 18:12:31.231: . . exported "SH"."SALES":"SALES_Q3_2003" 0 KB 0 rows 06-JUL-26 18:12:31.237: . . exported "SH"."SALES":"SALES_Q4_2002" 0 KB 0 rows 06-JUL-26 18:12:31.242: . . exported "SH"."SALES":"SALES_Q4_2003" 0 KB 0 rows 06-JUL-26 18:12:33.550: Master table "C##BACKUPUSER"."SYS_EXPORT_FULL_01" successfully loaded/unloaded 06-JUL-26 18:12:33.583: ****************************************************************************** 06-JUL-26 18:12:33.583: Dump file set for C##BACKUPUSER.SYS_EXPORT_FULL_01 is: 06-JUL-26 18:12:33.588: /home/oracle/hrpdb_full_20260706.dmp 06-JUL-26 18:12:33.630: Job "C##BACKUPUSER"."SYS_EXPORT_FULL_01" completed with 1 error(s) at Mon Jul 06 18:12:33 2026 elapsed 0 00:03:52 [oracle@19cdb01 ~]$
FULL=Y全库级导出可以正常执行。
[oracle@19cdb01 ~]$ expdp C##BACKUPUSER/<your_password>@hrpdb directory=IMP_DIR dumpfile=hrpdb_hr_20260706.dmp schemas=hr logfile=hrpdb_hr_log_20260706.log logtime=all Export: Release 19.0.0.0.0 - Production on Mon Jul 06 20:04:02 2026 Version 19.27.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 18-JUN-26 20:04:06.679: Starting "C##BACKUPUSER"."SYS_EXPORT_SCHEMA_01": C##BACKUPUSER/********@hrpdb directory=IMP_DIR dumpfile=hrpdb_hr_20260706.dmp schemas=hr logfile=hrpdb_hr_log_20260706.log logtime=all 18-JUN-26 20:04:10.421: Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA 18-JUN-26 20:04:10.699: Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS 18-JUN-26 20:04:11.034: Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS 18-JUN-26 20:04:15.198: Processing object type SCHEMA_EXPORT/STATISTICS/MARKER 18-JUN-26 20:04:15.462: Processing object type SCHEMA_EXPORT/USER 18-JUN-26 20:04:15.540: Processing object type SCHEMA_EXPORT/SYSTEM_GRANT 18-JUN-26 20:04:15.598: Processing object type SCHEMA_EXPORT/ROLE_GRANT 18-JUN-26 20:04:15.663: Processing object type SCHEMA_EXPORT/DEFAULT_ROLE 18-JUN-26 20:04:15.789: Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA 18-JUN-26 20:04:16.099: Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA 18-JUN-26 20:04:17.080: Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE 18-JUN-26 20:04:37.596: Processing object type SCHEMA_EXPORT/TABLE/TABLE 18-JUN-26 20:04:53.194: Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT 18-JUN-26 20:04:53.508: Processing object type SCHEMA_EXPORT/TABLE/COMMENT 18-JUN-26 20:04:55.299: Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE 18-JUN-26 20:04:56.031: Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE 18-JUN-26 20:04:58.365: Processing object type SCHEMA_EXPORT/VIEW/VIEW 18-JUN-26 20:04:59.808: Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX 18-JUN-26 20:05:00.837: Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT 18-JUN-26 20:05:02.318: Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT 18-JUN-26 20:05:02.484: Processing object type SCHEMA_EXPORT/TABLE/TRIGGER 18-JUN-26 20:05:05.397: . . exported "HR"."PLAN_TABLE" 25.99 KB 8 rows 18-JUN-26 20:05:05.431: . . exported "HR"."EMP3" 17.08 KB 107 rows 18-JUN-26 20:05:05.467: . . exported "HR"."EMPLOYEES" 17.08 KB 107 rows 18-JUN-26 20:05:06.043: . . exported "HR"."EMP2" 16.57 KB 107 rows 18-JUN-26 20:05:06.120: . . exported "HR"."LOCATIONS" 8.437 KB 23 rows 18-JUN-26 20:05:06.156: . . exported "HR"."JOB_HISTORY" 7.195 KB 10 rows 18-JUN-26 20:05:06.194: . . exported "HR"."JOBS" 7.109 KB 19 rows 18-JUN-26 20:05:06.225: . . exported "HR"."DEPARTMENTS" 7.125 KB 27 rows 18-JUN-26 20:05:06.379: . . exported "HR"."COUNTRIES" 6.367 KB 25 rows 18-JUN-26 20:05:06.438: . . exported "HR"."REGIONS" 5.546 KB 4 rows 18-JUN-26 20:05:07.954: Master table "C##BACKUPUSER"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded 18-JUN-26 20:05:07.992: ********************************************************************** 18-JUN-26 20:05:07.993: Dump file set for C##BACKUPUSER.SYS_EXPORT_SCHEMA_01 is: 18-JUN-26 20:05:07.998: /home/oracle/hrpdb_hr_20260706.dmp 18-JUN-26 20:05:08.062: Job "C##BACKUPUSER"."SYS_EXPORT_SCHEMA_01" successfully completed at Mon Jul 06 20:05:08 2026 elapsed 0 00:01:04 [oracle@19cdb01 ~]$
方案schema级导出可以正常执行。
【小结】在 Oracle 19c 中sysbackup 是一个具有备份管理权限的数据库角色，我们可以使用该用户或具有该角色的用户进行rman的备份和恢复，如果使用该用户进行DataPump(expdp/impdp)时需要授予 DATAPUMP_EXP_FULL_DATABASE/DATAPUMP_IMP_FULL_DATABASE 角色。生产环境建议管理用户分离，不混用数据库用户，满足监管和审计要求。
笔者文章集合详见：
https://www.myhfxf.com
https://www.xiaofeihuangfu.com
CSDN
:
https://blog.csdn.net/xfhuangfu
ITPUB
:
https://blog.itpub.net/28373936/
微信公众号：xfhuangfu
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/28373936/viewspace-3179508/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
