내맘대로긍정이 알려주는
Oracle 23ai 신기능
무료 세미나 발표자료
다운로드
trending_flat
OS환경 : Oracle Linux 6.8 (64bit)
DB 환경 : Oracle Database 11.2.0.4
에러 : ORA-39095: Dump file space has been exhausted: Unable to allocate 8192 bytes
expdp 시 발생하는 에러 메세지
|
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
33
34
35
36
37
38
39
40
41
42
43
44
45
46
|
$ expdp system/oracle job_name=expdp_20230606_IMSIBTL directory=EXPDP_20230606_1 logfile=expdp_20230606_IMSIBTL.log parallel=4
tables=IMSI.IMSITBL dumpfile=expdp_20230606_IMSIBTL.dmp compression=all cluster=N status=60
Export: Release 11.2.0.4.0 - Production on Tue Jun 6 21:15:20 2023
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, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
Job: expdp_expdp_20230606_IMSIBTL
Operation: EXPORT
Mode: TABLE
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 8
Job Error Count: 0
Dump File: /backup/EXPDP/expdp_IMSITBL.dmp
bytes written: 4,096
Worker 1 Status:
State: UNDEFINED
Starting "SYSTEM"."expdp_20230606_IMSIBTL": system/********/ job_name=expdp_20230606_IMSIBTL directory=EXPDP_20230606_1 logfile=expdp_20230606_IMSIBTL.log parallel=4 tables=IMSI.expdp_20230606_IMSIBTL dumpfile=expdp_20230606_IMSIBTL.dmp compression=all cluster=N status=60
Job: expdp_20230606_IMSIBTL
Operation: EXPORT
Mode: TABLE
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 8
Job Error Count: 0
Dump File: /backup/EXPDP/expdp_IMSITBL.dmp
bytes written: 4,096
.
.
Worker 2 Status:
Process Name: DW00
State: EXECUTING
Object Schema: IMSI
Object Name: IMSITBL
Object Type: TABLE_EXPORT/TABLE/TABLE_DATA
Completed Objects: 1
Total Objects: 1
Worker Parallelism: 7
ORA-39095: Dump file space has been exhausted: Unable to allocate 8192 bytes
|
해결 방법 : expdp 명령 덤프 파일 이름에 %U 옵션 사용
expdp에 parallel 옵션을 사용한 경우 덤프 파일 이름에 %U옵션을 사용해서 파일이 병렬로 생성되게 하면됨
|
1
2
3
|
$ expdp system/oracle job_name=expdp_20230606_IMSIBTL directory=EXPDP_20230606_1 logfile=expdp_20230606_IMSIBTL.log parallel=4
tables=IMSI.IMSITBL dumpfile=expdp_20230606_IMSIBTL%U.dmp compression=all cluster=N status=60
(정상)
|
정상적으로 동작함
원인 : parallel 옵션을 사용하고, 덤프파일이름에 %U 옵션을 안붙여서 발생한 문제
parallel 옵션을 사용하고, 덤프파일이름에 %U 옵션을 안붙여서 발생한 문제
파일이 병렬로 생성되려면 %U 옵션을 붙여줘야함
참조 : 559692.1
'ORACLE > Trouble Shooting' 카테고리의 다른 글
| ORA-19809: limit exceeded for recovery files (0) | 2023.07.06 |
|---|---|
| ORA-00955: name is already used by an existing object (0) | 2023.06.07 |
| WARNING: too many parse errors (2) | 2023.04.30 |
| RMAN-08137: warning: archived log not deleted, needed for standby or upstream capture process (0) | 2023.03.02 |
| ORA-62156: MEMOPTIMIZE FOR READ feature not allowed on segment with deferred storage (0) | 2023.02.17 |