Console Output
Started by timer
Building in workspace /home/oracle/.jenkins/workspace/wst_cnpc_crm
[wst_cnpc_crm] $ /bin/sh -xe /opt/tomcat-8.0.44/temp/hudson4726827063727761372.sh
+ /usr/bin/python /data/backup/dbBackup.py -u ********/********,********/********,********/******** -o wst_cnpc_crm
Export: Release 11.2.0.4.0 - Production on Wed May 28 22:01:45 2025
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "WST_CNPC_CRM_CONFIG"."SYS_EXPORT_SCHEMA_01": ********/********@orcl directory=dmp_wst_cnpc_crm schemas=******** parallel=3 dumpfile=********_2025-05-28_22_01_45_%U.dmp logfile=********_2025-05-28_22_01_45.log
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 4.187 MB
. . exported "WST_CNPC_CRM_CONFIG"."UICA" 442.5 KB 7106 rows
. . exported "WST_CNPC_CRM_CONFIG"."UIC" 268.5 KB 3226 rows
. . exported "WST_CNPC_CRM_CONFIG"."MUI" 76.42 KB 127 rows
. . exported "WST_CNPC_CRM_CONFIG"."UIA" 219.4 KB 3007 rows
Processing object type SCHEMA_EXPORT/USER
. . exported "WST_CNPC_CRM_CONFIG"."FLDDEF" 147.0 KB 2222 rows
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
. . exported "WST_CNPC_CRM_CONFIG"."SYSDEFS" 47.91 KB 9 rows
. . exported "WST_CNPC_CRM_CONFIG"."BUSHEET" 9.179 KB 1 rows
. . exported "WST_CNPC_CRM_CONFIG"."SYSDEFB" 17.34 KB 1 rows
. . exported "WST_CNPC_CRM_CONFIG"."TMPFILEDATA" 51.94 KB 11 rows
. . exported "WST_CNPC_CRM_CONFIG"."USERTBLINFO" 9.312 KB 1 rows
. . exported "WST_CNPC_CRM_CONFIG"."WORKFLOWM" 17.96 KB 21 rows
. . exported "WST_CNPC_CRM_CONFIG"."APPFUNC" 9.914 KB 1 rows
. . exported "WST_CNPC_CRM_CONFIG"."CODERULE" 7.046 KB 2 rows
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
. . exported "WST_CNPC_CRM_CONFIG"."CODETBL" 8.835 KB 4 rows
. . exported "WST_CNPC_CRM_CONFIG"."CODETBLA" 14.99 KB 172 rows
. . exported "WST_CNPC_CRM_CONFIG"."DATAEXPORTDEF" 10.5 KB 3 rows
. . exported "WST_CNPC_CRM_CONFIG"."DATAEXPORTTTBLDEF" 10.10 KB 9 rows
. . exported "WST_CNPC_CRM_CONFIG"."DATALIMFLDS" 13.22 KB 38 rows
. . exported "WST_CNPC_CRM_CONFIG"."DATALIMM" 9.765 KB 14 rows
. . exported "WST_CNPC_CRM_CONFIG"."DATALIMOP" 6.882 KB 28 rows
. . exported "WST_CNPC_CRM_CONFIG"."DATALIMS" 13.02 KB 48 rows
. . exported "WST_CNPC_CRM_CONFIG"."IDXDEF" 7.953 KB 9 rows
. . exported "WST_CNPC_CRM_CONFIG"."MENU" 41.56 KB 393 rows
. . exported "WST_CNPC_CRM_CONFIG"."MENULIMS" 6.531 KB 12 rows
. . exported "WST_CNPC_CRM_CONFIG"."MENUMODEL" 7.210 KB 4 rows
. . exported "WST_CNPC_CRM_CONFIG"."REFDEF" 10.32 KB 49 rows
. . exported "WST_CNPC_CRM_CONFIG"."SHEETCODERULE" 7.492 KB 18 rows
. . exported "WST_CNPC_CRM_CONFIG"."SYSOPTIONS" 7.976 KB 27 rows
. . exported "WST_CNPC_CRM_CONFIG"."TBLDEF" 27.27 KB 190 rows
. . exported "WST_CNPC_CRM_CONFIG"."UI" 34.52 KB 433 rows
. . exported "WST_CNPC_CRM_CONFIG"."UICCTRLVAL" 18.83 KB 60 rows
. . exported "WST_CNPC_CRM_CONFIG"."UICTRLCOL" 10.50 KB 30 rows
. . exported "WST_CNPC_CRM_CONFIG"."WFSHEET" 8.765 KB 21 rows
. . exported "WST_CNPC_CRM_CONFIG"."WORKFLOWA" 14.13 KB 33 rows
. . exported "WST_CNPC_CRM_CONFIG"."WORKFLOWU" 15.62 KB 54 rows
. . exported "WST_CNPC_CRM_CONFIG"."AIDEXPLD" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."AIDEXPLM" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."APPFUNCIMP" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."APPFUNCUSER" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."APPMODULE" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."ATTACHTYPE" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."ATTACHTYPEG" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."BUSHEETLIM" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."CHECKDETAILS" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."CHECKMAIN" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."DATAMATCHER" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."DATAOPTS" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."DATASETDEFCOLS" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."DATASETDEFDATA" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."DATASETDEFM" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."DATAVALID" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."DBLOGS" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."DFTVAL" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."DFTVALDB" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."DFTVALUI" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."DICTDEF" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."DICTINFO" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."FDATAIMPORTDEF" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."FDATAIMPORTDEFD" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."FDATAIMPORTDEFP" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."FDATAIMPORTDEFS" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."FLDEXT" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."FLDEXTUI" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."FLDEXTUIC" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."FLDEXTUICOPT" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."FLDEXTUICVAL" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."FLDEXTUIOPT" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."FLDEXTUIVAL" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."FLDUITYPE" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."FLDUITYPEM" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."GRVYSCRIPT" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."GWCODE" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."ICONRESDEF" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."LOGSDATA" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."MSGQUEUE" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."MSGQUEUEA" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."N7_DZB" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."PRINTSAVE" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."QRYSERVICE" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."QRYTOOL" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."QRYTOOLSUB" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."QRYTOOLSUBAGG" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."SAVSERVICE" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."SERVICEREG" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."SHEETSTATUS" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."SHEETXLSSAVE" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."STRRES" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."SYSRES" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."SYSRESB" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."TASKAUTH" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."TBLBTNINFO" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."TBLPRTFMTDEF" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."TBLPRTFMTDEFC" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."TIMETASKDEF" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."TMPVALUE" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."UGWCODE" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."UICSSDEF" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."UIF" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."UIFA" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."UIFTLDEF" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."UITHEMEDEF" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."UIWIDGETDEF" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."UPDATASOURCE" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."UPMAIN" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."UPMAING" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."UPRELA" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."UPRELAG" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."USERINFO" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."USERINFO2" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."USERS" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."USERTBLINFO2" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."UWORKFLOW" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."VIEWDETAIL" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."WFLINKER" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."WFLOW" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."WFNODE" 0 KB 0 rows
. . exported "WST_CNPC_CRM_CONFIG"."WORKFLOWW" 0 KB 0 rows
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/FUNCTION/FUNCTION
Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Master table "WST_CNPC_CRM_CONFIG"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for WST_CNPC_CRM_CONFIG.SYS_EXPORT_SCHEMA_01 is:
/data/backup/wst_cnpc_crm/********_2025-05-28_22_01_45_01.dmp
/data/backup/wst_cnpc_crm/********_2025-05-28_22_01_45_02.dmp
/data/backup/wst_cnpc_crm/********_2025-05-28_22_01_45_03.dmp
Job "WST_CNPC_CRM_CONFIG"."SYS_EXPORT_SCHEMA_01" successfully completed at Wed May 28 22:01:51 2025 elapsed 0 00:00:06
Export: Release 11.2.0.4.0 - Production on Wed May 28 22:01:52 2025
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "WST_CNPC_CRM_UCODECFG"."SYS_EXPORT_SCHEMA_01": ********/********@orcl directory=dmp_wst_cnpc_crm schemas=******** parallel=3 dumpfile=********_2025-05-28_22_01_45_%U.dmp logfile=********_2025-05-28_22_01_45.log
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 576 KB
. . exported "WST_CNPC_CRM_UCODECFG"."MBCODE" 54.74 KB 258 rows
. . exported "WST_CNPC_CRM_UCODECFG"."GWCODE" 7.710 KB 7 rows
. . exported "WST_CNPC_CRM_UCODECFG"."SHEETLIMS" 5.492 KB 2 rows
. . exported "WST_CNPC_CRM_UCODECFG"."TBLDEF" 26.06 KB 192 rows
. . exported "WST_CNPC_CRM_UCODECFG"."UGWCODE" 5.976 KB 5 rows
. . exported "WST_CNPC_CRM_UCODECFG"."USERS" 15.39 KB 9 rows
. . exported "WST_CNPC_CRM_UCODECFG"."WBCODE" 8.203 KB 6 rows
. . exported "WST_CNPC_CRM_UCODECFG"."WCODE" 7.429 KB 9 rows
. . exported "WST_CNPC_CRM_UCODECFG"."BCODE" 0 KB 0 rows
. . exported "WST_CNPC_CRM_UCODECFG"."GWCODELIMS" 0 KB 0 rows
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/FUNCTION/FUNCTION
Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Master table "WST_CNPC_CRM_UCODECFG"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for WST_CNPC_CRM_UCODECFG.SYS_EXPORT_SCHEMA_01 is:
/data/backup/wst_cnpc_crm/********_2025-05-28_22_01_45_01.dmp
/data/backup/wst_cnpc_crm/********_2025-05-28_22_01_45_02.dmp
/data/backup/wst_cnpc_crm/********_2025-05-28_22_01_45_03.dmp
Job "WST_CNPC_CRM_UCODECFG"."SYS_EXPORT_SCHEMA_01" successfully completed at Wed May 28 22:01:57 2025 elapsed 0 00:00:04
Export: Release 11.2.0.4.0 - Production on Wed May 28 22:01:58 2025
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "WST_CNPC_CRM_BUSI"."SYS_EXPORT_SCHEMA_01": ********/********@orcl directory=dmp_wst_cnpc_crm schemas=******** parallel=3 dumpfile=********_2025-05-28_22_01_45_%U.dmp logfile=********_2025-05-28_22_01_45.log
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 62.43 MB
. . exported "WST_CNPC_CRM_BUSI"."CCODE" 9.750 MB 13730 rows
Processing object type SCHEMA_EXPORT/USER
. . exported "WST_CNPC_CRM_BUSI"."PRINTSAVE" 2.166 MB 20922 rows
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
. . exported "WST_CNPC_CRM_BUSI"."USER_CCODEFJ" 1.685 MB 11275 rows
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
. . exported "WST_CNPC_CRM_BUSI"."LINKMAN" 1.865 MB 13816 rows
. . exported "WST_CNPC_CRM_BUSI"."TMPFILEDATA" 24.15 KB 2 rows
. . exported "WST_CNPC_CRM_BUSI"."USER_CCODEAFFIX" 411.4 KB 9631 rows
. . exported "WST_CNPC_CRM_BUSI"."TESTVIEW" 21.00 MB 212739 rows
. . exported "WST_CNPC_CRM_BUSI"."CCODEBANKACCNO" 434.1 KB 4523 rows
. . exported "WST_CNPC_CRM_BUSI"."NEWSESSIONS" 7.148 KB 1 rows
. . exported "WST_CNPC_CRM_BUSI"."OPPONENT" 17.19 KB 21 rows
. . exported "WST_CNPC_CRM_BUSI"."OPPORTUNITY" 17.78 KB 28 rows
. . exported "WST_CNPC_CRM_BUSI"."CCODESHARE" 434.4 KB 9816 rows
. . exported "WST_CNPC_CRM_BUSI"."OPPORTUNITY01" 8.554 KB 17 rows
. . exported "WST_CNPC_CRM_BUSI"."OPPORTUNITY02" 14.78 KB 60 rows
. . exported "WST_CNPC_CRM_BUSI"."OPPORTUNITY03" 9.890 KB 18 rows
. . exported "WST_CNPC_CRM_BUSI"."OPPOSTATUS" 6.023 KB 8 rows
. . exported "WST_CNPC_CRM_BUSI"."SESSIONTYPES" 7.492 KB 1 rows
. . exported "WST_CNPC_CRM_BUSI"."CCODECNPC05" 381.2 KB 4369 rows
. . exported "WST_CNPC_CRM_BUSI"."TBLDEF" 26.03 KB 192 rows
. . exported "WST_CNPC_CRM_BUSI"."LINKMANMAIL" 324.8 KB 4800 rows
. . exported "WST_CNPC_CRM_BUSI"."WDXGOODS" 6.281 KB 1 rows
. . exported "WST_CNPC_CRM_BUSI"."WDXSALORDER" 10.96 KB 2 rows
. . exported "WST_CNPC_CRM_BUSI"."USER_GCODES" 333.6 KB 3032 rows
. . exported "WST_CNPC_CRM_BUSI"."WDXSALORDERG" 7.632 KB 1 rows
. . exported "WST_CNPC_CRM_BUSI"."ATTACHTYPE" 0 KB 0 rows
. . exported "WST_CNPC_CRM_BUSI"."ATTACHTYPEG" 0 KB 0 rows
. . exported "WST_CNPC_CRM_BUSI"."CCODECREDITG" 0 KB 0 rows
. . exported "WST_CNPC_CRM_BUSI"."CCODEDEGREEEND" 0 KB 0 rows
. . exported "WST_CNPC_CRM_BUSI"."CCODEGRADEG" 0 KB 0 rows
. . exported "WST_CNPC_CRM_BUSI"."CCODE_PRICE" 0 KB 0 rows
. . exported "WST_CNPC_CRM_BUSI"."DBLOGS" 0 KB 0 rows
. . exported "WST_CNPC_CRM_BUSI"."LINKMANSHARE" 0 KB 0 rows
. . exported "WST_CNPC_CRM_BUSI"."LOGSDATA" 0 KB 0 rows
. . exported "WST_CNPC_CRM_BUSI"."MSGQUEUE" 0 KB 0 rows
. . exported "WST_CNPC_CRM_BUSI"."MSGQUEUEA" 0 KB 0 rows
. . exported "WST_CNPC_CRM_BUSI"."PKTEST" 0 KB 0 rows
. . exported "WST_CNPC_CRM_BUSI"."PRINTSAVECHANGE" 0 KB 0 rows
. . exported "WST_CNPC_CRM_BUSI"."QUALITY_IN" 0 KB 0 rows
. . exported "WST_CNPC_CRM_BUSI"."QUALITY_OUT" 0 KB 0 rows
. . exported "WST_CNPC_CRM_BUSI"."SHEETXLSSAVE" 0 KB 0 rows
. . exported "WST_CNPC_CRM_BUSI"."TASKAUTH" 0 KB 0 rows
. . exported "WST_CNPC_CRM_BUSI"."TBLBTNINFO" 0 KB 0 rows
. . exported "WST_CNPC_CRM_BUSI"."CCODECNPC02" 268.5 KB 5458 rows
. . exported "WST_CNPC_CRM_BUSI"."TBLPRTFMTDEF" 0 KB 0 rows
. . exported "WST_CNPC_CRM_BUSI"."TBLPRTFMTDEFC" 0 KB 0 rows
. . exported "WST_CNPC_CRM_BUSI"."TMPVALUE" 0 KB 0 rows
. . exported "WST_CNPC_CRM_BUSI"."UIFUNC" 0 KB 0 rows
. . exported "WST_CNPC_CRM_BUSI"."UIFUNCG" 0 KB 0 rows
. . exported "WST_CNPC_CRM_BUSI"."USERINFO" 0 KB 0 rows
. . exported "WST_CNPC_CRM_BUSI"."USERINFO2" 0 KB 0 rows
. . exported "WST_CNPC_CRM_BUSI"."USERS_DETAIL" 0 KB 0 rows
. . exported "WST_CNPC_CRM_BUSI"."USERTBLINFO2" 0 KB 0 rows
. . exported "WST_CNPC_CRM_BUSI"."USER_CNPCYS" 0 KB 0 rows
. . exported "WST_CNPC_CRM_BUSI"."UWORKFLOW" 0 KB 0 rows
. . exported "WST_CNPC_CRM_BUSI"."CCODECNPC03" 270.2 KB 5623 rows
. . exported "WST_CNPC_CRM_BUSI"."COMPANYADDRESS" 245.3 KB 1983 rows
. . exported "WST_CNPC_CRM_BUSI"."TASKLIST" 63.89 KB 177 rows
. . exported "WST_CNPC_CRM_BUSI"."BRANCHORGADDRESS" 91.21 KB 551 rows
. . exported "WST_CNPC_CRM_BUSI"."CCODECNPC01" 78.57 KB 638 rows
. . exported "WST_CNPC_CRM_BUSI"."CCODECNPC04" 93.41 KB 1078 rows
. . exported "WST_CNPC_CRM_BUSI"."CCODDR" 12.23 KB 61 rows
. . exported "WST_CNPC_CRM_BUSI"."CCODECONTROL" 16.73 KB 30 rows
. . exported "WST_CNPC_CRM_BUSI"."CCODECONTROLG" 9.148 KB 6 rows
. . exported "WST_CNPC_CRM_BUSI"."CCODECREDIT" 9.945 KB 1 rows
. . exported "WST_CNPC_CRM_BUSI"."CCODEDEBOOKG" 6.945 KB 8 rows
Processing object type SCHEMA_EXPORT/TABLE/TABLE
. . exported "WST_CNPC_CRM_BUSI"."CCODEDEBOOKSG" 24.07 KB 1 rows
. . exported "WST_CNPC_CRM_BUSI"."CCODEDEGREEBOOK" 18.29 KB 1 rows
. . exported "WST_CNPC_CRM_BUSI"."CCODEDEGREESEARCH" 10.92 KB 2 rows
. . exported "WST_CNPC_CRM_BUSI"."CCODEFBREPLY" 15.52 KB 3 rows
. . exported "WST_CNPC_CRM_BUSI"."CCODEFBREPLYG" 9.085 KB 5 rows
. . exported "WST_CNPC_CRM_BUSI"."CCODEFBREPORT" 21.55 KB 3 rows
. . exported "WST_CNPC_CRM_BUSI"."CCODEFBREPORTG" 12.88 KB 5 rows
. . exported "WST_CNPC_CRM_BUSI"."CCODEFBWORK" 17.70 KB 3 rows
. . exported "WST_CNPC_CRM_BUSI"."CCODEFBWORKG" 10.50 KB 5 rows
. . exported "WST_CNPC_CRM_BUSI"."CCODEGRADE" 10.10 KB 3 rows
. . exported "WST_CNPC_CRM_BUSI"."CCODEINPLAN" 15.55 KB 3 rows
. . exported "WST_CNPC_CRM_BUSI"."CCODEINPLANG" 8.218 KB 6 rows
. . exported "WST_CNPC_CRM_BUSI"."CCODEINREPORT" 18.60 KB 3 rows
. . exported "WST_CNPC_CRM_BUSI"."CCODEINREPORTG" 11.58 KB 6 rows
. . exported "WST_CNPC_CRM_BUSI"."CCODEINWORK" 16.88 KB 3 rows
. . exported "WST_CNPC_CRM_BUSI"."CCODEINWORKG" 9.679 KB 6 rows
. . exported "WST_CNPC_CRM_BUSI"."CCODEOLDNAME" 7.578 KB 8 rows
. . exported "WST_CNPC_CRM_BUSI"."CCODEREVIEW" 6.273 KB 1 rows
. . exported "WST_CNPC_CRM_BUSI"."CCODEREVIEWG" 9.312 KB 3 rows
. . exported "WST_CNPC_CRM_BUSI"."CCODETYPE" 6.234 KB 15 rows
. . exported "WST_CNPC_CRM_BUSI"."CCODEVISIT" 12.78 KB 16 rows
. . exported "WST_CNPC_CRM_BUSI"."CCODEVISITED" 22.08 KB 34 rows
. . exported "WST_CNPC_CRM_BUSI"."CCODEVISITG" 17.13 KB 26 rows
. . exported "WST_CNPC_CRM_BUSI"."CCODFBVISIT" 11.39 KB 3 rows
. . exported "WST_CNPC_CRM_BUSI"."CCODFBVISITG" 14.90 KB 2 rows
. . exported "WST_CNPC_CRM_BUSI"."COMCLASS" 10.92 KB 86 rows
. . exported "WST_CNPC_CRM_BUSI"."CPNCCLASS" 12.96 KB 182 rows
. . exported "WST_CNPC_CRM_BUSI"."LINKMANRELA" 24.53 KB 135 rows
. . exported "WST_CNPC_CRM_BUSI"."N7_DZB" 23.09 KB 258 rows
. . exported "WST_CNPC_CRM_BUSI"."NCODE_N7" 18.36 KB 503 rows
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/FUNCTION/FUNCTION
Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Master table "WST_CNPC_CRM_BUSI"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for WST_CNPC_CRM_BUSI.SYS_EXPORT_SCHEMA_01 is:
/data/backup/wst_cnpc_crm/********_2025-05-28_22_01_45_01.dmp
/data/backup/wst_cnpc_crm/********_2025-05-28_22_01_45_02.dmp
/data/backup/wst_cnpc_crm/********_2025-05-28_22_01_45_03.dmp
Job "WST_CNPC_CRM_BUSI"."SYS_EXPORT_SCHEMA_01" successfully completed at Wed May 28 22:02:05 2025 elapsed 0 00:00:06
tar: Removing leading `/' from member names
/data/backup/wst_cnpc_crm/********_2025-05-28_22_01_45_01.dmp
/data/backup/wst_cnpc_crm/********_2025-05-28_22_01_45_02.dmp
/data/backup/wst_cnpc_crm/********_2025-05-28_22_01_45_03.dmp
/data/backup/wst_cnpc_crm/********_2025-05-28_22_01_45.log
/data/backup/wst_cnpc_crm/********_2025-05-28_22_01_45_01.dmp
/data/backup/wst_cnpc_crm/********_2025-05-28_22_01_45_02.dmp
/data/backup/wst_cnpc_crm/********_2025-05-28_22_01_45_03.dmp
/data/backup/wst_cnpc_crm/********_2025-05-28_22_01_45.log
/data/backup/wst_cnpc_crm/********_2025-05-28_22_01_45_01.dmp
/data/backup/wst_cnpc_crm/********_2025-05-28_22_01_45_02.dmp
/data/backup/wst_cnpc_crm/********_2025-05-28_22_01_45_03.dmp
/data/backup/wst_cnpc_crm/********_2025-05-28_22_01_45.log
total 271656
-rw-r--r--. 1 oracle oinstall 14640040 May 8 22:03 wst_cnpc_crm_2025-05-08_22_03_09.tar.gz
-rw-r--r--. 1 oracle oinstall 14638656 May 9 22:02 wst_cnpc_crm_2025-05-09_22_01_59.tar.gz
-rw-r--r--. 1 oracle oinstall 14638367 May 10 22:02 wst_cnpc_crm_2025-05-10_22_01_11.tar.gz
-rw-r--r--. 1 oracle oinstall 14638724 May 11 22:03 wst_cnpc_crm_2025-05-11_22_03_35.tar.gz
-rw-r--r--. 1 oracle oinstall 14639413 May 12 22:02 wst_cnpc_crm_2025-05-12_22_01_27.tar.gz
-rw-r--r--. 1 oracle oinstall 14640742 May 13 22:02 wst_cnpc_crm_2025-05-13_22_01_44.tar.gz
-rw-r--r--. 1 oracle oinstall 14639770 May 16 22:02 wst_cnpc_crm_2025-05-16_22_02_10.tar.gz
-rw-r--r--. 1 oracle oinstall 14638867 May 17 22:01 wst_cnpc_crm_2025-05-17_22_01_16.tar.gz
-rw-r--r--. 1 oracle oinstall 14641323 May 18 22:01 wst_cnpc_crm_2025-05-18_22_01_32.tar.gz
-rw-r--r--. 1 oracle oinstall 14637944 May 19 22:01 wst_cnpc_crm_2025-05-19_22_01_12.tar.gz
-rw-r--r--. 1 oracle oinstall 14639632 May 20 22:01 wst_cnpc_crm_2025-05-20_22_01_32.tar.gz
-rw-r--r--. 1 oracle oinstall 14636303 May 21 22:02 wst_cnpc_crm_2025-05-21_22_01_41.tar.gz
-rw-r--r--. 1 oracle oinstall 14636972 May 22 22:02 wst_cnpc_crm_2025-05-22_22_01_43.tar.gz
-rw-r--r--. 1 oracle oinstall 14637539 May 23 22:01 wst_cnpc_crm_2025-05-23_22_01_33.tar.gz
-rw-r--r--. 1 oracle oinstall 14638642 May 24 22:01 wst_cnpc_crm_2025-05-24_22_01_34.tar.gz
-rw-r--r--. 1 oracle oinstall 14638075 May 25 22:01 wst_cnpc_crm_2025-05-25_22_01_11.tar.gz
-rw-r--r--. 1 oracle oinstall 14636419 May 26 22:01 wst_cnpc_crm_2025-05-26_22_01_26.tar.gz
-rw-r--r--. 1 oracle oinstall 14640103 May 27 22:06 wst_cnpc_crm_2025-05-27_22_05_18.tar.gz
-rw-r--r--. 1 oracle oinstall 14640893 May 28 22:02 wst_cnpc_crm_2025-05-28_22_01_45.tar.gz
bak_dir=/data/backup/wst_cnpc_crm
expdp ********/"********"@orcl directory=dmp_wst_cnpc_crm schemas=******** parallel=3 dumpfile=********_2025-05-28_22_01_45_%U.dmp logfile=********_2025-05-28_22_01_45.log
expdp ********/"********"@orcl directory=dmp_wst_cnpc_crm schemas=******** parallel=3 dumpfile=********_2025-05-28_22_01_45_%U.dmp logfile=********_2025-05-28_22_01_45.log
expdp ********/"********"@orcl directory=dmp_wst_cnpc_crm schemas=******** parallel=3 dumpfile=********_2025-05-28_22_01_45_%U.dmp logfile=********_2025-05-28_22_01_45.log
tar -zcvf /data/backup/wst_cnpc_crm/wst_cnpc_crm_2025-05-28_22_01_45.tar.gz /data/backup/wst_cnpc_crm/********_2025-05-28_22_01_45*.* /data/backup/wst_cnpc_crm/********_2025-05-28_22_01_45*.* /data/backup/wst_cnpc_crm/********_2025-05-28_22_01_45*.* --remove-files
将删除20天前的文件!
Finished: SUCCESS
