服务器建站,上海中小企业服务中心,企业内部管理信息系统,网站建设企业站有哪些要求在XTTS迁移测试阶段#xff0c;遇到执行几个expdp的导出任务#xff0c;迟迟没有返回任何信息#xff0c;对应日志无任何输出。环境#xff1a;AIX 6.1 Oracle 10.2.0.4现象#xff1a;在XTTS迁移测试阶段#xff0c;遇到执行几个expdp的导出任务#xff0c;迟迟没有返…在XTTS迁移测试阶段遇到执行几个expdp的导出任务迟迟没有返回任何信息对应日志无任何输出。环境AIX 6.1 Oracle 10.2.0.4现象在XTTS迁移测试阶段遇到执行几个expdp的导出任务迟迟没有返回任何信息对应日志无任何输出查看任务状态SQL set lines 300col OWNER_NAME for a10col OPERATION for a15col JOB_MODE for a20col STATE for a15select * from dba_datapump_jobs; OWNER_NAME JOB_NAME OPERATION JOB_MODE STATE DEGREE ATTACHED_SESSIONS DATAPUMP_SESSIONS---------- ------------------------------ --------------- -------------------- --------------- ---------- ----------------- -----------------SYS SYS_EXPORT_TRANSPORTABLE_01 EXPORT TRANSPORTABLE DEFINING 1 0 1SYS SYS_EXPORT_TRANSPORTABLE_02 EXPORT TRANSPORTABLE DEFINING 1 1 2SYS SYS_EXPORT_TRANSPORTABLE_03 EXPORT TRANSPORTABLE DEFINING 1 1 2SYS SYS_EXPORT_SCHEMA_01 EXPORT SCHEMA DEFINING 1 1 2SYS SYS_EXPORT_TRANSPORTABLE_04 EXPORT TRANSPORTABLE DEFINING 1 1 2SYS SYS_EXPORT_SCHEMA_02 EXPORT SCHEMA DEFINING 1 1 26 rows selected.可以看到所有的expdp导出任务的STATE都停留在DEFINING状态。1.牛刀小试清异常2.追本溯源查MOS1.牛刀小试清异常先强制杀掉后台执行的所有expdp任务ps -ef|grep expdp|grep -v grep|awk {print $2}|xargs kill -9然后尝试删除这些表(其实应该在not running状态下删除)select drop table ||OWNER_NAME||.||JOB_NAME|| purge; from dba_datapump_jobs where STATENOT RUNNING;drop table sys.SYS_EXPORT_TRANSPORTABLE_01 purge;..可这样是没有作用的查询结果不变。甚至尝试正常shutdown immediate停止数据库也无法成功告警日志看到有活动调用Thu Nov 1 15:14:24 2018Active call for process 4522064 user oracle program oraclelocalhost (DM00)Active call for process 4456536 user oracle program oraclelocalhost (DM01)Active call for process 10027180 user oracle program oraclelocalhost (DM02)Active call for process 7340140 user oracle program oraclelocalhost (DM03)Active call for process 6291888 user oracle program oraclelocalhost (DM04)Active call for process 8126596 user oracle program oraclelocalhost (DM05)SHUTDOWN: waiting for active calls to complete.发现这些进程的id都对应了ora_dm的进程$ ps -ef|grep ora_dm oracle 4456536 1 0 17:00:09 - 0:00 ora_dm01_xxxxdb oracle 4522064 1 0 16:50:57 - 0:00 ora_dm00_xxxxdb oracle 7340140 1 0 14:06:07 - 0:00 ora_dm03_xxxxdb oracle 8126596 1 0 14:35:03 - 0:00 ora_dm05_xxxxdb oracle 10027180 1 0 13:55:08 - 0:00 ora_dm02_xxxxdb oracle 6291888 1 0 14:31:17 - 0:00 ora_dm04_xxxxdb oracle 7340432 8388786 0 15:22:59 pts/4 0:00 grep ora_dm实际上这就是expdp任务的相关进程强制杀掉这些进程ps -ef|grep ora_dm|grep -v grep|awk {print $2}|xargs kill -9之后数据库关闭成功Thu Nov 1 15:24:37 2018All dispatchers and shared servers shutdownThu Nov 1 15:24:37 2018ALTER DATABASE CLOSE NORMAL启动数据库后再次查询发现已经成功清理SQL set lines 300col OWNER_NAME for a10col OPERATION for a15col JOB_MODE for a20col STATE for a15select * from dba_datapump_jobs; no rows selected小结数据泵任务与ora_dm进程相关如果数据泵任务发生异常但任务并没有退出的情况需要同时杀掉这类进程(杀掉后状态就会变为NOT RUNNING)。关库不是必须的只是演示此时正常关闭被阻塞的场景。这也能说明为什么要保证在NOT RUNNING状态下才可以清理。2.追本溯源查MOS...✨ 接下来内容请访问原文(https://www.modb.pro/db/27204?YYF)进行查看~更多数据库相关内容可访问墨天轮(https://www.modb.pro/?YYF)进行浏览。
