在创建streams时遇到如下错误。
old 4: SOURCE_DATABASE => '&source_db_name..&db_domain',
new 4: SOURCE_DATABASE => 'MCSPSR.central',
old 6: DESTINATION_DATABASE => '&target_db_name..&db_domain',
new 6: DESTINATION_DATABASE => 'RPTPSR.central',
old 10: APPLY_NAME => 'APPLY$_&source_db_name._ADC',
new 10: APPLY_NAME => 'APPLY$_MCSPSR_ADC',
old 11: APPLY_QUEUE_NAME => 'APPLY$_&source_db_name._ADCQ',
new 11: APPLY_QUEUE_NAME => 'APPLY$_MCSPSR_ADCQ',
old 12: PROPAGATION_NAME => 'PROP$_&source_db_name._ADC',
new 12: PROPAGATION_NAME => 'PROP$_MCSPSR_ADC',
BEGIN
*
ERROR at line 1:
ORA-23616: Failure in executing block 12 for script
AD9B04ECD1BC448CE04400212826A59C with
ORA-39002: invalid operation
ORA-06512: at "SYS.DBMS_RECO_SCRIPT_INVOK", line 139
ORA-06512: at "SYS.DBMS_STREAMS_RPC", line 485
ORA-06512: at "SYS.DBMS_RECOVERABLE_SCRIPT", line 659
ORA-06512: at "SYS.DBMS_RECOVERABLE_SCRIPT", line 682
ORA-06512: at "SYS.DBMS_STREAMS_MT", line 7983
ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 2703
ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 2764
ORA-06512: at line 2
使用下面语句查看具体错误原因：
SQL> select forward_block,forward_block_dblink,status
from dba_recoverable_script_blocks
where script_id='AD9B04ECD1BC448CE04400212826A59C' and block_num=12 2 3
4
SQL>
SQL> /
FORWARD_BLOCK FORWARD_BLOCK_DBLINK STATUS
--------------------------------------------------------------------- ------------------------------------------- -----------------------
-- RPTPSR.CENTRAL PURGED
-- Datapump SCHEMA MODE IMPORT
--
DECLARE
h1 NUMBER := NUL
查看与data pump相关的日志。
$ more fullexpMCSPSR_110925.log
;;;
Export: Release 11.2.0.2.0 - Production on Sun Sep 25 18:00:02 2011
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
;;;
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
FLASHBACK automatically enabled to preserve database integrity.
Starting "ORACLE"."SYS_EXPORT_FULL_07": /******** full=Y directory=EXPDIR compression=ALL dumpfile=fullexpMCSPSR_110925.dmp logfile=fullexpMCSPSR_110925.log
Estimate in progress using BLOCKS method...
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 7.894 GB
Processing object type DATABASE_EXPORT/TABLESPACE
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.COMPLETE_EXP_OBJECT [TABLESPACE]
ORA-31616: unable to write to dump file "/orahome/oracle/acfsdata/mcs_share/dpdumps/MCSPSR/fullexpMCSPSR_110925.dmp"
ORA-19502: write error on file "/orahome/oracle/acfsdata/mcs_share/dpdumps/MCSPSR/fullexpMCSPSR_110925.dmp", block number 3 (block size=4096)
ORA-27063: number of bytes read/written is incorrect
SVR4 Error: 28: No space left on deviceAdditional information: -1
Additional information: 4096
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 8358
----- PL/SQL Call Stack -----
object line object
handle number name
48f951290 19208 package body SYS.KUPW$WORKER
48f951290 8385 package body SYS.KUPW$WORKER
48f951290 6086 package body SYS.KUPW$WORKER
48f951290 2702 package body SYS.KUPW$WORKER
48f951290 9054 package body SYS.KUPW$WORKER
48f951290 1688 package body SYS.KUPW$WORKER
58e61d4e0 2 anonymous block
Job "ORACLE"."SYS_EXPORT_FULL_07" stopped due to fatal error at 18:02:44
$ df -h
Filesystem size used avail capacity Mounted on
/dev/md/dsk/d10 25G 14G 10G 58% /
/devices 0K 0K 0K 0% /devices
ctfs 0K 0K 0K 0% /system/contract
proc 0K 0K 0K 0% /proc
mnttab 0K 0K 0K 0% /etc/mnttab
swap 46G 1.2M 46G 1% /etc/svc/volatile
objfs 0K 0K 0K 0% /system/object
sharefs 0K 0K 0K 0% /etc/dfs/sharetab
/platform/SUNW,T5240/lib/libc_psr/libc_psr_hwcap2.so.1
25G 14G 10G 58% /platform/sun4v/lib/libc_psr.so.1
/platform/SUNW,T5240/lib/sparcv9/libc_psr/libc_psr_hwcap2.so.1
25G 14G 10G 58% /platform/sun4v/lib/sparcv9/libc_psr.so.1
fd 0K 0K 0K 0% /dev/fd
swap 46G 43M 46G 1% /tmp
swap 46G 48K 46G 1% /var/run
/dev/md/dsk/d30 80G 11G 68G 14% /export
/dev/md/dsk/d50 89G 25G 63G 29% /orahome
/dev/asm/mcs_share-182
20G 20G 0K 100% /orahome/oracle/acfsdata/mcs_share
果然空间不足导致出错，移动一些文件释放空间后再执行建立streams语句！
