OS환경 : Oracle Linux 6.8 (64bit)
DB 환경 : Oracle Database 11.2.0.4
에러 : impdp시 발생한 ORA-39070: Unable to open the log file
impdp 시 발생하는 에러
1 2 3 4 5 6 7 8 9 10 11 12 13 | $ impdp system/oracle directory=testdata schemas=test dumpfile=testts.dmp logfile=test.log remap_schema=test:test2 Import: Release 11.2.0.4.0 - Production on Wed Feb 28 11:29:13 2018 copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning option ORA-39002: invalid operation ORA-39070: Unable to open the log file. ORA-29283: invalid file operation ORA-06512: at "SYS.UTL_FILE", line 536 ORA-29283: invalid file operation |
해결 방법 : 디렉토리에 dmp 파일 넣어주기
해당 directory에 dmp 파일이 존재하지 않는다면 넣어주기
1 2 3 | $ scp testts.dmp 10.10.10.30:/home/oracle/test oracle@10.10.10.30's password: testts.dmp 100% 4924KB 4.8MB/s 00:00 . |
impdp 재실행
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 | $ impdp system/oracle directory=testdata schemas=test dumpfile=testts.dmp logfile=test.log remap_schema=test:test2 Import: Release 11.2.0.4.0 - Production on Wed Feb 28 11:30:52 2018 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning option Master table "SYSTEM"."SYS_IMPORT_SCHEMA_01" successfully loaded/unloaded Starting "SYSTEM"."SYS_IMPORT_SCHEMA_01": system/******** directory=testdata schemas=test dumpfile=testts.dmp logfile=test.log remap_schema=test:test2 Processing object type SCHEMA_EXPORT/USER Processing object type SCHEMA_EXPORT/SYSTEM_GRANT Processing object type SCHEMA_EXPORT/ROLE_GRANT ORA-39083: Object type ROLE_GRANT failed to create with error: ORA-01919: role 'PLUSTRACE' does not exist Failing sql is: GRANT "PLUSTRACE" TO "test2" Processing object type SCHEMA_EXPORT/DEFAULT_ROLE Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA Processing object type SCHEMA_EXPORT/TABLE/TABLE Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA . . imported "test2"."EMP3" 4.546 MB 114689 rows . . imported "test2"."DEPT" 5.656 KB 4 rows . . imported "test2"."DUMMY" 4.914 KB 1 rows . . imported "test2"."EMP" 7.820 KB 14 rows . . imported "test2"."SALGRADE" 5.585 KB 5 rows . . imported "test2"."BONUS" 0 KB 0 rows . . imported "test2"."PLAN_TABLE" 0 KB 0 rows Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS Job "SYSTEM"."SYS_IMPORT_SCHEMA_01" completed with 1 error(s) at Wed Feb 28 11:31:00 2018 elapsed 0 00:00:08 |
정상적으로 완료됨
원인 : 해당 디렉토리에 dmp 파일이 없어서 발생하는 오류
참조 :
'ORACLE > Trouble Shooting' 카테고리의 다른 글
| ORA-12919: Can not drop the default permanent tablespace 해결 방법 (0) | 2018.03.07 |
|---|---|
| 오라클 11g R2 설치 시 INVALID BLOCK TYPE 에러 (0) | 2018.02.28 |
| expdp시 발생한 ORA-39006: internal error ,ORA-39213: Metadata processing is not available 해결 (0) | 2018.02.28 |
| /cvuqdisk-1.0.9-1.rpm 에러 처리 방법 (0) | 2018.02.26 |
| ORA-00904 invalid identifier (0) | 2018.02.20 |