Oracle恢复dmp文件报错问题,请大神帮忙看一下。

C:\Users\Administrator>imp system/snp201@P201_SN file=F:\p201\p201_2019_09_18_0_00.dmp log=F:\p201\logs.log full=y ignore=y

报错:

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Export file created by EXPORT:V10.02.01 via conventional path
import done in ZHS16GBK character set and AL16UTF16 NCHAR character set
export client uses WE8ISO8859P1 character set (possible charset conversion)
. importing SYSTEM's objects into SYSTEM
IMP-00017: following statement failed with ORACLE error 1119:
"CREATE UNDO TABLESPACE "RBSG_SPC" BLOCKSIZE 8192 DATAFILE '/oradata/P201/d"
"ata/undotbs01.dbf' SIZE 2048M EXTENT MANAGEMENT LOCAL "
IMP-00003: ORACLE error 1119 encountered
ORA-01119: error in creating database file '/oradata/P201/data/undotbs01.dbf'
ORA-27040: file create error, unable to create file
OSD-04002: 无法打开文件
O/S-Error: (OS 3) 系统找不到指定的路径。
IMP-00017: following statement failed with ORACLE error 1119:
"CREATE TEMPORARY TABLESPACE "TEMP_SPC" BLOCKSIZE 8192 TEMPFILE '/oradata/P"
"201/data/temp01.dbf' SIZE 1073741824 AUTOEXTEND ON NEXT 655360 MAXSI"
"ZE 32767M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1048576"
IMP-00003: ORACLE error 1119 encountered
ORA-01119: error in creating database file '/oradata/P201/data/temp01.dbf'
ORA-27040: file create error, unable to create file
OSD-04002: 无法打开文件
O/S-Error: (OS 3) 系统找不到指定的路径。
IMP-00017: following statement failed with ORACLE error 1119:
"CREATE TABLESPACE "DATA_SPC" BLOCKSIZE 8192 DATAFILE '/oradata/P201/data/u"
"sers01.dbf' SIZE 2048M , '/oradata/P201/data/users02.dbf' SIZE 2048M "
" , '/oradata/P201/data/users03.dbf' SIZE 2048M , '/oradata/P201/dat"
"a/users04.dbf' SIZE 2048M EXTENT MANAGEMENT LOCAL AUTOALLOCATE ONLI"
"NE PERMANENT SEGMENT SPACE MANAGEMENT AUTO"
IMP-00003: ORACLE error 1119 encountered
ORA-01119: error in creating database file '/oradata/P201/data/users01.dbf'
ORA-27040: file create error, unable to create file
OSD-04002: 无法打开文件
O/S-Error: (OS 3) 系统找不到指定的路径。
IMP-00017: following statement failed with ORACLE error 1119:
"CREATE TABLESPACE "INDX_SPC" BLOCKSIZE 8192 DATAFILE '/oradata/P201/data/i"
"ndex01.dbf' SIZE 2048M , '/oradata/P201/data/index02.dbf' SIZE 2048M "
" , '/oradata/P201/data/index03.dbf' SIZE 2048M EXTENT MANAGEMENT L"
"OCAL AUTOALLOCATE ONLINE PERMANENT SEGMENT SPACE MANAGEMENT AUTO"
IMP-00003: ORACLE error 1119 encountered
ORA-01119: error in creating database file '/oradata/P201/data/index01.dbf'
ORA-27040: file create error, unable to create file
OSD-04002: 无法打开文件
O/S-Error: (OS 3) 系统找不到指定的路径。
IMP-00017: following statement failed with ORACLE error 1119:
"CREATE TABLESPACE "TOOLS_SPC" BLOCKSIZE 8192 DATAFILE '/oradata/P201/data/"
"tools01.dbf' SIZE 104857600 EXTENT MANAGEMENT LOCAL AUTOALLOCATE ON"
"LINE PERMANENT SEGMENT SPACE MANAGEMENT AUTO"
IMP-00003: ORACLE error 1119 encountered
ORA-01119: error in creating database file '/oradata/P201/data/tools01.dbf'
ORA-27040: file create error, unable to create file
OSD-04002: 无法打开文件
O/S-Error: (OS 3) 系统找不到指定的路径。
IMP-00017: following statement failed with ORACLE error 959:
"ALTER USER "SYS" IDENTIFIED BY VALUES '34032A6EB9AF81F0' TEMPORARY TABLESPA"
"CE "TEMP_SPC""
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'TEMP_SPC' does not exist
IMP-00017: following statement failed with ORACLE error 959:
"ALTER USER "SYSTEM" IDENTIFIED BY VALUES '6EB432A935A0D818' TEMPORARY TABLE"
"SPACE "TEMP_SPC""
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'TEMP_SPC' does not exist
IMP-00017: following statement failed with ORACLE error 959:
"CREATE USER "TSMSYS" IDENTIFIED BY VALUES '3DF26A8B17D0F29F' TEMPORARY TABL"
"ESPACE "TEMP_SPC" PASSWORD EXPIRE ACCOUNT LOCK"
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'TEMP_SPC' does not exist
IMP-00017: following statement failed with ORACLE error 959:
"CREATE USER "DBUSRPOS" IDENTIFIED BY VALUES '3244CCDF3EC51372' DEFAULT TABL"
"ESPACE "DATA_SPC" TEMPORARY TABLESPACE "TEMP_SPC""
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'DATA_SPC' does not exist
IMP-00017: following statement failed with ORACLE error 959:
"CREATE USER "FTPOSERP" IDENTIFIED BY VALUES '19FBBB1DDD7819F1' DEFAULT TABL"
"ESPACE "DATA_SPC" TEMPORARY TABLESPACE "TEMP_SPC""
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'DATA_SPC' does not exist
IMP-00017: following statement failed with ORACLE error 959:
"CREATE USER "FTERPAPP" IDENTIFIED BY VALUES '36A05437E3347110' DEFAULT TABL"
"ESPACE "DATA_SPC" TEMPORARY TABLESPACE "TEMP_SPC""
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'DATA_SPC' does not exist
IMP-00017: following statement failed with ORACLE error 959:
"CREATE USER "DBLINKUSR" IDENTIFIED BY VALUES 'F7891792EC2D1261' DEFAULT TAB"
"LESPACE "DATA_SPC" TEMPORARY TABLESPACE "TEMP_SPC""
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'DATA_SPC' does not exist
IMP-00017: following statement failed with ORACLE error 959:
"CREATE USER "DBUSR" IDENTIFIED BY VALUES '684F707940FBD9C7' DEFAULT TABLESP"
"ACE "DATA_SPC" TEMPORARY TABLESPACE "TEMP_SPC""
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'DATA_SPC' does not exist
IMP-00017: following statement failed with ORACLE error 959:
"CREATE USER "DBUSRCARDNEW" IDENTIFIED BY VALUES 'CA675BF2681710F2' DEFAULT "
"TABLESPACE "DATA_SPC" TEMPORARY TABLESPACE "TEMP_SPC""
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'DATA_SPC' does not exist
IMP-00017: following statement failed with ORACLE error 959:
"CREATE USER "DBUSRSELECT" IDENTIFIED BY VALUES 'EB2868029BF741C0' DEFAULT T"
"ABLESPACE "DATA_SPC" TEMPORARY TABLESPACE "TEMP_SPC""
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'DATA_SPC' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT UNLIMITED TABLESPACE TO "TSMSYS""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'TSMSYS' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT UNLIMITED TABLESPACE TO "DBUSRPOS""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'DBUSRPOS' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT CREATE ANY INDEX TO "DBUSRPOS""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'DBUSRPOS' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT CREATE ANY SEQUENCE TO "DBUSRPOS""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'DBUSRPOS' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT CREATE ANY TABLE TO "DBUSRPOS""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'DBUSRPOS' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT CREATE USER TO "DBUSRPOS""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'DBUSRPOS' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT DELETE ANY TABLE TO "DBUSRPOS""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'DBUSRPOS' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT DROP ANY INDEX TO "DBUSRPOS""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'DBUSRPOS' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT DROP ANY SEQUENCE TO "DBUSRPOS""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'DBUSRPOS' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT DROP ANY TABLE TO "DBUSRPOS""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'DBUSRPOS' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT DROP USER TO "DBUSRPOS""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'DBUSRPOS' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT EXECUTE ANY PROCEDURE TO "DBUSRPOS""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'DBUSRPOS' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT GRANT ANY ROLE TO "DBUSRPOS""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'DBUSRPOS' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT INSERT ANY TABLE TO "DBUSRPOS""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'DBUSRPOS' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT SELECT ANY SEQUENCE TO "DBUSRPOS""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'DBUSRPOS' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT SELECT ANY TABLE TO "DBUSRPOS""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'DBUSRPOS' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT UPDATE ANY TABLE TO "DBUSRPOS""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'DBUSRPOS' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT UNLIMITED TABLESPACE TO "DBUSR""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'DBUSR' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT UNLIMITED TABLESPACE TO "DBUSRCARDNEW""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'DBUSRCARDNEW' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT CREATE SESSION TO "DBUSRSELECT""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'DBUSRSELECT' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT ALTER SESSION TO "DBUSRSELECT""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'DBUSRSELECT' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT SELECT ANY DICTIONARY TO "DBUSRSELECT""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'DBUSRSELECT' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "RESOURCE" TO "TSMSYS""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'TSMSYS' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "DBA" TO "DBUSRPOS""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'DBUSRPOS' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "ROLE_APPPOSERP" TO "FTPOSERP""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'FTPOSERP' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "CONNECT" TO "FTERPAPP""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'FTERPAPP' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "ROLE_APPPOSERP" TO "DBLINKUSR""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'DBLINKUSR' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "DBA" TO "DBUSR""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'DBUSR' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "DBA" TO "DBUSRCARDNEW""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'DBUSRCARDNEW' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "ROLE_DBPOSERP" TO "DBLINKUSR""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'DBLINKUSR' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "DBUSRSELECT" DEFAULT ROLE ALL"
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'DBUSRSELECT' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "DBUSRCARDNEW" DEFAULT ROLE ALL"
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'DBUSRCARDNEW' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "DBUSR" DEFAULT ROLE ALL"
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'DBUSR' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "DBLINKUSR" DEFAULT ROLE ALL"
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'DBLINKUSR' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "FTERPAPP" DEFAULT ROLE ALL"
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'FTERPAPP' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "FTPOSERP" DEFAULT ROLE ALL"
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'FTPOSERP' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "DBUSRPOS" DEFAULT ROLE ALL"
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'DBUSRPOS' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "TSMSYS" DEFAULT ROLE ALL"
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'TSMSYS' does not exist
. importing SYSMAN's objects into SYSMAN
. importing DBUSRPOS's objects into DBUSRPOS
"ALTER SESSION SET CURRENT_SCHEMA= "DBUSRPOS""
IMP-00003: ORACLE error 1435 encountered
ORA-01435: user does not exist
IMP-00000: Import terminated unsuccessfully

1个回答

import 的目标数据库无法建立相同的表空间,可能是数据文件路径不一致。 可以做一个link成为与源数据库相同的文件路径。 然后重新import即可

Csdn user default icon
上传中...
上传图片
插入图片
抄袭、复制答案,以达到刷声望分或其他目的的行为,在CSDN问答是严格禁止的,一经发现立刻封号。是时候展现真正的技术了!
立即提问
相关内容推荐