Jump to content
Sign in to follow this  
Firestarter

Export Database Oracle

Recommended Posts

Salam..

Aku cuba pindahkan database dari VM ke fizikal server. So aku guna data pump. Dalam VM ni ade 3 database. Setiap db guna sid yang berbeza. Aku dah set sid sebelum aku buat export.

Bila nak export dia kuar error kat bawah:
[code][oracle@dboracle dump]$ expdp system/bpmksm2011@ems full=y directory=test_dir dumpfile=emsfull1.dmp logfile=emsfull1.log

Export: Release 10.2.0.4.0 - 64bit Production on Saturday, 27 November, 2010 11:47:35

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

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYSTEM"."SYS_EXPORT_FULL_10": system/********@ems full=y directory=test_dir dumpfile=emsfull1.dmp logfile=emsfull1.log
Estimate in progress using BLOCKS method...
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 0 KB
ORA-39125: Worker unexpected fatal error in KUPW$WORKER.UNLOAD_METADATA while calling DBMS_METADATA.FETCH_XML_CLOB [TABLE_DATA:"SYSMAN"."MGMT_DB_INIT_PARAMS_ECM"]
ORA-01187: cannot read from file 203 because it failed verification tests
ORA-01110: data file 203: '/u03/app/oracle/product/10.2.0/oradata/unidev/TISTEMP01.dbf'

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.KUPW$WORKER", line 6313

----- PL/SQL Call Stack -----
object line object
handle number name
0xde1de3c8 15032 package body SYS.KUPW$WORKER
0xde1de3c8 6372 package body SYS.KUPW$WORKER
0xde1de3c8 2396 package body SYS.KUPW$WORKER
0xde1de3c8 6944 package body SYS.KUPW$WORKER
0xde1de3c8 1314 package body SYS.KUPW$WORKER
0xd49af320 2 anonymous block

Job "SYSTEM"."SYS_EXPORT_FULL_10" stopped due to fatal error at 11:47:50

[/code]

Aku dah search google dan aku dah try semua solution yang dicadangkan. Hampir semua tak menjadi. Aku nak minta tolong sifu-sifu kat sana plak. Mana tau korang pernah alaminya.

Info:
OS: Red Hat ES 4.6 64bit
DB: Oracle 10.2.0.4 64bit

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...