oracle imp 00061,急 求教一个全库导入的操作？谢谢大家

本帖最后由 asdseer 于 2012-2-17 16:33 编辑

领导今天早上给了我一个10G大小的dmp包使用exp导出的全库数据。

让我还原生一个数据库。

没有导出日志，只知道大概有1000多个用户40个左右的数据文件30多个表空间......

只有这么一个包。也不知道从那偷来的数据。

请教 我该如何操作呀？

要做一个类似迁移的操作 但是表空间，用户，权限什么的都是未知的。

错误信息如下 有2000多个

IMP-00061: 警告: 对象类型 "SYSTEM"."REPCAT$_OBJECT_NULL_VECTOR" 已经以不同标识符存在

"CREATE TYPE "REPCAT$_OBJECT_NULL_VECTOR" TIMESTAMP '2010-06-17:14:56:35' OI"

"D '89353F37355040DCE0438493006640DC'          AS OBJECT"

"("

"  -- type owner, name, hashcode for the type represented by null_vector"

"  type_owner      VARCHAR2(30),"

"  type_name       VARCHAR2(30),"

"  type_hashcode   RAW(17),"

"  -- null_vector for a particular object instance"

"  -- ROBJ REVISIT: should only contain the null image, and not version#"

"  null_vector     RAW(2000)"

")"

. 正在将 OLAPSYS 的对象导入到 OLAPSYS

IMP-00061: 警告: 对象类型 "OLAPSYS"."O_MESG_ROW" 已经以不同标识符存在

"CREATE TYPE "O_MESG_ROW" TIMESTAMP '2010-06-17:15:18:49' OID '8935A1EBE3E64"

"0F6E0438493006640F6'   wrapped"

"a000000"

"1"

"abcd"

"abcd"

"abcd"

"abcd"

"abcd"

"abcd"

"abcd"

"abcd"

"abcd"

"abcd"

"abcd"

"abcd"

"abcd"

"abcd"

"abcd"

"d"

"e9 9a"

"jGop251qhDAc/IgAzph7eQonZd4wg5n0dLhchdD+LmLc0CiXluqldCulv5vAMsuz523+MrKf"

"0P6ZgTLAsgml0plSMr+yBgnKHH3dWbjSMlznx3TAM7h0ZSV831AUxsgvseMvRqhg6BpYUd7X"

"pqYlQ1b1"

IMP-00061: 警告: 对象类型 "OLAPSYS"."ALL_OLAP2_AW_METADATA_O" 已经以不同标识符存在

"CREATE TYPE "ALL_OLAP2_AW_METADATA_O" TIMESTAMP '2010-06-17:15:18:56' OID '"

"8935A1EBE3EC40F6E0438493006640F6'           AS OBJECT ("

" AWOWNER VARCHAR2(30),"

" AWNAME VARCHAR2(30),"

" AWOBJECT VARCHAR2(90),"

" COL1 VARCHAR2(4000),"

" COL2 VARCHAR2(4000),"

" COL3 VARCHAR2(4000),"

" COL4 VARCHAR2(4000),"

" COL5 number,"

" COL6 VARCHAR2(4000),"

" COL7 VARCHAR2(4000),"

" COL8 VARCHAR2(4000),"

" COL9 VARCHAR2(4000),"

" AWMDKEY NUMBER)"

IMP-00061: 警告: 对象类型 "OLAPSYS"."ALL_OLAP2_AW_METADATA_T" 已经以不同标识符存在

"CREATE TYPE "ALL_OLAP2_AW_METADATA_T" TIMESTAMP '2010-06-17:15:18:56' OID '"

"8935A1EBE3FC40F6E0438493006640F6'           AS TABLE OF ALL_OLAP2_AW_METADA"

"TA_O"

IMP-00061: 警告: 对象类型 "OLAPSYS"."OLAP_SYS_AW_ACCESS_OBJ" 已经以不同标识符存在

"CREATE TYPE "OLAP_SYS_AW_ACCESS_OBJ" TIMESTAMP '2010-06-17:15:19:08' OID '8"

"935A1EBE40040F6E0438493006640F6'   AS OBJECT ("

"  AW_DIM_ACCESS_INFO   VARCHAR2(4000),"

"  AW_CUBE_ACCESS_INFO  VARCHAR2(4000))"

IMP-00061: 警告: 对象类型 "OLAPSYS"."OLAP_SYS_AW_ACCESS_TBL" 已经以不同标识符存在

"CREATE TYPE "OLAP_SYS_AW_ACCESS_TBL" TIMESTAMP '2010-06-17:15:19:08' OID '8"

"935A1EBE40540F6E0438493006640F6'   AS TABLE OF OLAP_SYS_AW_ACCESS_OBJ"

IMP-00061: 警告: 对象类型 "OLAPSYS"."OLAP_SYS_AW_ENABLE_ACCESS_OBJ" 已经以不同标识符存在

"CREATE TYPE "OLAP_SYS_AW_ENABLE_ACCESS_OBJ" TIMESTAMP '2010-06-17:15:19:08'"

" OID '8935A1EBE40940F6E0438493006640F6'   AS OBJECT ("

"  AW_ACCESS_INFO VARCHAR2(4000))"

IMP-00061: 警告: 对象类型 "OLAPSYS"."OLAP_SYS_AW_ENABLE_ACCESS_TBL" 已经以不同标识符存在

"CREATE TYPE "OLAP_SYS_AW_ENABLE_ACCESS_TBL" TIMESTAMP '2010-06-17:15:19:08'"

" OID '8935A1EBE40D40F6E0438493006640F6'   AS TABLE OF OLAP_SYS_AW_ENABLE_AC"

"CESS_OBJ"

. 正在将 SYSMAN 的对象导入到 SYSMAN

IMP-00061: 警告: 对象类型 "SYSMAN"."EM_SDK_COMP" 已经以不同标识符存在

"CREATE TYPE "EM_SDK_COMP" TIMESTAMP '2010-06-17:15:23:17' OID '8935B6550741"

"40FEE0438493006640FE'   AS OBJECT"

"("

"  NAME        VARCHAR2(64),"

"  TYPE        VARCHAR2(64),"

"  GRANT_TYPE  VARCHAR2(64)"

");"

IMP-00061: 警告: 对象类型 "SYSMAN"."EM_SDK_COMPS" 已经以不同标识符存在

"CREATE TYPE "EM_SDK_COMPS" TIMESTAMP '2010-06-17:15:23:17' OID '8935B655074"

"740FEE0438493006640FE'   AS"

"    TABLE OF EM_SDK_COMP;"

IMP-00061: 警告: 对象类型 "SYSMAN"."EMDSYSTEM_ARGS" 已经以不同标识符存在

"CREATE TYPE "EMDSYSTEM_ARGS" TIMESTAMP '2010-06-17:15:23:17' OID '8935B6550"

"74B40FEE0438493006640FE'   IS TABLE OF VARCHAR2(1024);"

IMP-00061: 警告: 对象类型 "SYSMAN"."SMP_EMD_AVAIL_OBJ" 已经以不同标识符存在

"CREATE TYPE "SMP_EMD_AVAIL_OBJ" TIMESTAMP '2010-06-17:15:23:17' OID '8935B6"

"55074F40FEE0438493006640FE'   as OBJECT ("

"    nodeStatus VARCHAR2(128),"

"    imageName  VARCHAR2(128),"

"    availInfo VARCHAR2(128),"

"    severityCode INTEGER,"

"    numAlerts INTEGER"

");"

IMP-00061: 警告: 对象类型 "SYSMAN"."SMP_EMD_TARGET_OBJ" 已经以不同标识符存在

"CREATE TYPE "SMP_EMD_TARGET_OBJ" TIMESTAMP '2010-06-17:15:23:17' OID '8935B"

"655075740FEE0438493006640FE'   as OBJECT ("

"    targetName VARCHAR2(256),"

"    targetType VARCHAR2(128),"

"    displayName VARCHAR2(128),"

"    typeDisplayName VARCHAR2(128),"

"    targetSev INTEGER,"

"    targetAvail NUMBER(15,2),"

"    targetStatus INTEGER,"

"    warningAlert INTEGER,"

"    criticalAlert INTEGER,"

"    association VARCHAR2(128)"

");"

IMP-00061: 警告: 对象类型 "SYSMAN"."SMP_EMD_TARGET_OBJ_ARRAY" 已经以不同标识符存在

"CREATE TYPE "SMP_EMD_TARGET_OBJ_ARRAY" TIMESTAMP '2010-06-17:15:23:17' OID "

"'8935B655076440FEE0438493006640FE'   as TABLE of SMP_EMD_TARGET_OBJ;"

IMP-00061: 警告: 对象类型 "SYSMAN"."SMP_EMD_LOAD_OBJ" 已经以不同标识符存在

"CREATE TYPE "SMP_EMD_LOAD_OBJ" TIMESTAMP '2010-06-17:15:23:17' OID '8935B65"

"5076840FEE0438493006640FE'   as OBJECT ("

"    numProcesses INTEGER,"

"    numUsers INTEGER,"

"    avgLoad NUMBER,"

"    cpuUtil INTEGER,"

"    cpuKernel INTEGER,"

"    cpuUser INTEGER,"

"    cpuIOWait INTEGER,"

"    numProcessesSev INTEGER,"

"    numUsersSev INTEGER,"

"    avgLoadSev INTEGER,"

"    cpuUtilSev INTEGER,"

"    cpuKernelSev INTEGER,"

"    cpuUserSev INTEGER,"

"    cpuIOWaitSev INTEGER,"

"    memScanRate INTEGER"

");"

IMP-00061: 警告: 对象类型 "SYSMAN"."SMP_EMD_HOST_CONFIG_OBJ" 已经以不同标识符存在

"CREATE TYPE "SMP_EMD_HOST_CONFIG_OBJ" TIMESTAMP '2010-06-17:15:23:17' OID '"

"8935B655077A40FEE0438493006640FE'   as OBJECT ("

"    os VARCHAR2(128),"

"    osVersion VARCHAR2(128),"

"    upsince VARCHAR2(128),"

"    platform VARCHAR2(128),"

"    patchLevel VARCHAR2(128),"

"    ipAddress VARCHAR2(128)"

");"

IMP-00061: 警告: 对象类型 "SYSMAN"."SMP_EMD_MEMORY_OBJ" 已经以不同标识符存在

"CREATE TYPE "SMP_EMD_MEMORY_OBJ" TIMESTAMP '2010-06-17:15:23:17' OID '8935B"

"655078340FEE0438493006640FE'   as OBJECT ("

"    totalMem INTEGER,"

"    freeMem INTEGER,"

"    freeMemSev INTEGER,"

"    swapUtil INTEGER,"

"    totalSwap INTEGER,"

"    freeSwap INTEGER,"

"    swapUtilSev INTEGER"

");"

IMP-00061: 警告: 对象类型 "SYSMAN"."SMP_EMD_DISK_OBJ" 已经以不同标识符存在

"CREATE TYPE "SMP_EMD_DISK_OBJ" TIMESTAMP '2010-06-17:15:23:17' OID '8935B65"

"5078D40FEE0438493006640FE'   as OBJECT ("

"    diskTotalSize INTEGER,"

"    diskAvailSize INTEGER,"

"    diskTotalSizeKeyVal VARCHAR2(128),"

"    diskTotalSizeSev INTEGER,"

"    diskTotalSizeStatusFound INTEGER,"

"    diskAvailSizeKeyVal VARCHAR2(128),"

"    diskAvailSizeSev INTEGER,"

"    diskAvailSizeStatusFound INTEGER,"

"    ioActivity NUMBER,"

"    longestServ NUMBER"

IMP-00017: 由于 ORACLE 错误 2264, 以下语句失败:

"ALTER TABLE "REPCAT$_SITES_NEW" ADD CONSTRAINT "REPCAT$_SITES_NEW_FULL_INST"

"" CHECK (full_instantiation IN ('Y', 'N')) ENABLE NOVALIDATE"

IMP-00003: 遇到 ORACLE 错误 2264

ORA-02264: 名称已被一现有约束条件占用

. . 正在导入表          "REPCAT$_SITE_OBJECTS"导入了           0 行

. . 正在导入表             "REPCAT$_SNAPGROUP"导入了           0 行

. . 正在导入表      "REPCAT$_TEMPLATE_OBJECTS"导入了           0 行

IMP-00003: 遇到 ORACLE 错误 2264

ORA-02264: 名称已被一现有约束条件占用

. . 正在导入表    "REPCAT$_TEMPLATE_REFGROUPS"导入了           0 行

. . 正在导入表        "REPCAT$_TEMPLATE_SITES"导入了           0 行

");"

IMP-00019: 由于 ORACLE 错误 1 而拒绝行

IMP-00003: 遇到 ORACLE 错误 1

ORA-00001: 违反唯一约束条件 (OLAPSYS.CWM$CLASSIFICATION_PK)

列 1 32

列 2 Level

列 3

列 4

列 5

列 6

列 7

列 8

列 9 3

列 10

列 11

列 12 29

列 13

列 14

列 15

列 16

列 17

列 18

列 19

IMP-00019: 由于 ORACLE 错误 1 而拒绝行

IMP-00003: 遇到 ORACLE 错误 1

ORA-00001: 违反唯一约束条件 (SYSMAN.MGMT_ARU_FAM_PRD_PK)

IMP-00028: 上一个表的部分导入已回退: 回退 584511 行

成功终止导入, 但出现警告。