本帖最后由 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 行
成功终止导入, 但出现警告。