【EXPDP】在使用EXPDP完成逻辑备份时alert中正常的kupprdp提示信息

2020-01-19 15:16:07

如果备份策略使用的是EXPDP工具来完成逻辑备份。那么，在数据库日常检查中，会在alert日志文件中找到逻辑备份的痕迹。
简单演示一下，供参考。

1.使用EXPDP工具完成对用户SEC的备份
ora10g@secDB /db_backup/dpump_dir$ expdp sec/sec directory=dpump_dir dumpfile=sec.dmp

Export: Release 10.2.0.3.0 - 64bit Production on Thursday, 16 June, 2010 0:32:56

Copyright (c) 2003, 2005, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engine options
Starting "SEC"."SYS_EXPORT_SCHEMA_01": sec/******** directory=dpump_dir dumpfile=sec.dmp
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 64 KB
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/TABLESPACE_QUOTA
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
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/COMMENT
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
. . exported "SEC"."T"                                   4.914 KB       3 rows
. . exported "SEC"."T_CHILD"                                 0 KB       0 rows
. . exported "SEC"."T_PARENT"                                0 KB       0 rows
Master table "SEC"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SEC.SYS_EXPORT_SCHEMA_01 is:
/db_backup/dpump_dir/sec.dmp
Job "SEC"."SYS_EXPORT_SCHEMA_01" successfully completed at 00:33:15

2.在备份的过程中可以在alert文件中找到逻辑备份的具体信息
Thu Jun 16 00:32:56 2010
The value (30) of MAXTRANS parameter ignored.
kupprdp: master process DM00 started with pid=18, OS id=14731
         to execute - SYS.KUPM$MCP.MAIN('SYS_EXPORT_SCHEMA_01', 'SEC', 'KUPC$C_1_20100617003256', 'KUPC$S_1_20100617003256', 0);
kupprdp: worker process DW01 started with worker id=1, pid=19, OS id=14755
         to execute - SYS.KUPW$WORKER.MAIN('SYS_EXPORT_SCHEMA_01', 'SEC');

3.不放过蛛丝马迹
关于“The value (30) of MAXTRANS parameter ignored.”报错，原因在MOS的“DataPump Export/Import Generate Messages "The Value (30) Of Maxtrans Parameter Ignored" in Alert Log [ID 455021.1]”文章中有叙述，这个错误可以忽略，在Oracle 11.2版本中不再出现这个信息提示。

4.小结
数据库日常巡检时alert中记录的任何信息都是不容错过的。
虽然在使用EXPDP工具备份数据的过程中会产生很多类似文中描述的提示信息，本着宁多勿少的原则，它们给予我们的不仅仅是“干扰”。

Good luck.

secooler
10.06.16

-- The End --

分享好友

分享这个小栈给你的朋友们，一起进步吧。