您现在的位置是：主页 > news > 整形医院网站开发/网络营销好不好
整形医院网站开发/网络营销好不好
admin2025/5/10 15:51:12【news】
简介整形医院网站开发,网络营销好不好,网站开发 发送邮件功能,网站建设实习困难由于某些原因，impdp在导入时可能在某些对象上特别慢（比如view，alter procedure有dblink） 使用数据泵attach参数中的 STOP_JOBIMMEDIATE START_JOBSKIP_CURRENT 可以跳过当前对象 lzldb:/oracle>impdp \/ as sysdba\ attac…
由于某些原因，impdp在导入时可能在某些对象上特别慢（比如view，alter procedure有dblink）
使用数据泵attach参数中的
STOP_JOB=IMMEDIATE
START_JOB=SKIP_CURRENT
可以跳过当前对象
lzldb:/oracle>impdp \'/ as sysdba\' attach=SYS_IMPORT_FULL_01
Import: Release 11.2.0.4.0 - Production on Mon Oct 29 09:39:57 2018
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, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
Job: SYS_IMPORT_FULL_01
Owner: SYS
Operation: IMPORT
Creator Privs: TRUE
GUID: 791EE594D5900066E0530AAE1A0C03CA
Start Time: Friday, 26 October, 2018 16:56:37
Mode: FULL
Instance: partydb
Max Parallelism: 1
EXPORT Job Parameters:
CLIENT_COMMAND "/******** AS SYSDBA" DIRECTORY=AWR_EXTR DUMPFILE=lzldb.dmp logfile=lzldb.log FULL=y content=metadata_only
INCLUDE_METADATA 1
IMPORT Job Parameters:
Parameter Name Parameter Value:
CLIENT_COMMAND "/******** AS SYSDBA" DIRECTORY=AWR_EXTR DUMPFILE=lzldb.dmp logfile=lzldb.log FULL=y content=metadata_only TABLE_EXISTS_ACTION=SKIP exclude=stati
INCLUDE_METADATA 1
TABLE_EXISTS_ACTION SKIP
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 1
Job Error Count: 0
Dump File: /oracle/lzldb.dmp
Worker 1 Status:
Process Name: DW00
State: EXECUTING
Object Schema: UOP_CP
Object Name: P_EC_ACCT_001
Object Type: DATABASE_EXPORT/SCHEMA/PROCEDURE/ALTER_PROCEDURE
Completed Objects: 560
Worker Parallelism: 1
Import> help
------------------------------------------------------------------------------
The following commands are valid while in interactive mode.
Note: abbreviations are allowed.
CONTINUE_CLIENT
Return to logging mode. Job will be restarted if idle.
EXIT_CLIENT
Quit client session and leave job running.
HELP
Summarize interactive commands.
KILL_JOB
Detach and delete job.
PARALLEL
Change the number of active workers for current job.
START_JOB
Start or resume current job.
Valid keywords are: SKIP_CURRENT.
STATUS
Frequency (secs) job status is to be monitored where
the default [0] will show new status when available.
STOP_JOB
Orderly shutdown of job execution and exits the client.
Valid keywords are: IMMEDIATE.
Import> stop_job immediate
LRM-00108: invalid positional parameter value 'immediate'
Import> stop_job=immediate
Are you sure you wish to stop this job ([yes]/no): yes
UDI-00001: user requested cancel of current operation --这里hang住了，只有手动退出再attach进去
You have mail in /usr/spool/mail/oracle
--到数据库中查dp的job
SQL> select * from dba_datapump_jobs;
OWNER_NAME JOB_NAME OPERATION JOB_MODE
------------------------------ ------------------------------ ------------------------------------------------------------ ------------------------------------------------------
STATE DEGREE ATTACHED_SESSIONS DATAPUMP_SESSIONS
------------------------------ ---------- ----------------- -----------------
SYS SYS_IMPORT_FULL_01 IMPORT FULL
NOT RUNNING
（这里的任务状态可能处于STOPPING，需要等待几分钟转换到NOT RUNNIN的时候才可以attach）
lzldb:/oracle>impdp \'/ as sysdba\' attach=SYS_IMPORT_FULL_01
Import: Release 11.2.0.4.0 - Production on Mon Oct 29 09:43:00 2018
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, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
Job: SYS_IMPORT_FULL_01
Owner: SYS
Operation: IMPORT
Creator Privs: TRUE
GUID: 791EE594D5900066E0530AAE1A0C03CA
Start Time: Monday, 29 October, 2018 9:43:03
Mode: FULL
Instance: lzldb
Max Parallelism: 1
EXPORT Job Parameters:
CLIENT_COMMAND "/******** AS SYSDBA" DIRECTORY=AWR_EXTR DUMPFILE=lzldb.dmp logfile=lzldb.log FULL=y content=metadata_only
INCLUDE_METADATA 1
IMPORT Job Parameters:
Parameter Name Parameter Value:
CLIENT_COMMAND "/******** AS SYSDBA" DIRECTORY=AWR_EXTR DUMPFILE=lzldb.dmp logfile=lzldb.log FULL=y content=metadata_only TABLE_EXISTS_ACTION=SKIP exclude=stati
INCLUDE_METADATA 1
TABLE_EXISTS_ACTION SKIP
State: IDLING
Bytes Processed: 0
Current Parallelism: 1
Job Error Count: 0
Dump File: /oracle/lzldb.dmp
Worker 1 Status:
Process Name: DW00
State: UNDEFINED
Object Schema: UOP_CP
Object Name: P_EC_ACCT_001
Object Type: DATABASE_EXPORT/SCHEMA/PROCEDURE/ALTER_PROCEDURE
Completed Objects: 560
Total Objects: 560
Worker Parallelism: 1
Import> START_JOB=SKIP_CURRENT
Import> status
Job: SYS_IMPORT_FULL_01
Operation: IMPORT
Mode: FULL
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 1
Job Error Count: 0
Dump File: /oracle/lzldb.dmp
Worker 1 Status:
Process Name: DW01
State: EXECUTING
Object Schema: ORDDATA
Object Name: ORDDCM_CT_VM_MT_IDX
Object Type: DATABASE_EXPORT/SCHEMA/TABLE/INDEX/INDEX
Completed Objects: 150
Worker Parallelism: 1
Import> status --impdp没有hang住了
Job: SYS_IMPORT_FULL_01
Operation: IMPORT
Mode: FULL
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 1
Job Error Count: 0
Dump File: /oracle/lzldb.dmp
Worker 1 Status:
Process Name: DW01
State: EXECUTING
Object Schema: APEX_030200
Object Name: WWV_FLOW_SW_STMTS_IDX2
Object Type: DATABASE_EXPORT/SCHEMA/TABLE/INDEX/INDEX
Completed Objects: 1,333
Worker Parallelism: 1
Import>
SQL> select * from dba_datapump_jobs;
OWNER_NAME JOB_NAME OPERATION JOB_MODE
------------------------------ ------------------------------ ------------------------------------------------------------ ------------------------------------------------------
STATE DEGREE ATTACHED_SESSIONS DATAPUMP_SESSIONS
------------------------------ ---------- ----------------- -----------------
SYS SYS_IMPORT_FULL_01 IMPORT FULL
EXECUTING 1 1 3
注意：stop impdp时经常hang住，且一次只能跳一个对象，如果有大量对象都到不进去就很麻烦。
Import> CONTINUE_CLIENT
Job SYS_IMPORT_SCHEMA_01 has been reopened at Fri Nov 2 22:17:02 2018
Restarting "SYS"."SYS_IMPORT_SCHEMA_01": "/******** AS SYSDBA" parallel=10 cluster=N schemas=uop_param,ucr_param remap_schema=uop_param:uop_param_kr,ucr_param:ucr_param_kr NET ORA-39126: Worker unexpected fatal error in KUPW$WORKER.LOOK_FOR_OBJECT [OBJECT_GRANT:"UCR_PARAM_KR"]
SELECT process_order, duplicate, completion_time, in_progress FROM "SYS"."SYS_IMPORT_SCHEMA_01" WHERE partition_name IS NULL AND subpartition_name IS NULL AND object_type = :18
ORA-01422: exact fetch returns more than requested number of rowsORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.KUPW$WORKER", line 9721----- PL/SQL Call Stack -----object line objecthandle number name
70001077e85a020 21979 package body SYS.KUPW$WORKER
70001077e85a020 9742 package body SYS.KUPW$WORKER
70001077e85a020 15646 package body SYS.KUPW$WORKER
70001077e85a020 13424 package body SYS.KUPW$WORKER
70001077e85a020 8069 package body SYS.KUPW$WORKER
70001077e85a020 11712 package body SYS.KUPW$WORKER
70001077e85a020 2808 package body SYS.KUPW$WORKER
70001077e85a020 10422 package body SYS.KUPW$WORKER
70001077e85a020 1824 package body SYS.KUPW$WORKER
70001072a743868 2 anonymous blockORA-39126: Worker unexpected fatal error in KUPW$WORKER.LOOK_FOR_OBJECT [OBJECT_GRANT:"UCR_PARAM_KR"]
SELECT process_order, duplicate, completion_time, in_progress FROM "SYS"."SYS_IMPORT_SCHEMA_01" WHERE partition_name IS NULL AND subpartition_name IS NULL AND object_type = :18
ORA-01422: exact fetch returns more than requested number of rowsORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.KUPW$WORKER", line 9721----- PL/SQL Call Stack -----object line objecthandle number name
70001077e85a020 21979 package body SYS.KUPW$WORKER
70001077e85a020 9742 package body SYS.KUPW$WORKER
70001077e85a020 15646 package body SYS.KUPW$WORKER
70001077e85a020 13424 package body SYS.KUPW$WORKER
70001077e85a020 8069 package body SYS.KUPW$WORKER
70001077e85a020 11712 package body SYS.KUPW$WORKER
70001077e85a020 2808 package body SYS.KUPW$WORKER
70001077e85a020 10422 package body SYS.KUPW$WORKER
70001077e85a020 1824 package body SYS.KUPW$WORKER
70001072a743868 2 anonymous blockJob "SYS"."SYS_IMPORT_SCHEMA_01" stopped due to fatal error at Fri Nov 2 22:17:32 2018 elapsed 0 00:00:31上面就是一次我停了job，start或者continue都起不来job，所以最好不要随便用stop_job这个功能。
对于较大数据的导入最好在前期迁移时就准备好，把不必要的对象排除掉
