OS 환경 : Oracle Linux 8.7 (64bit)
DB 환경 : Oracle Database 19.27.0.0
방법 : 오라클 19c expdp impdp 상태 n초마다 자동 확인
오라클에서 datapump 사용시 status 명령으로 현재 상태를 확인 할 수 있는데
continue_client 를 같이 사용하여 특정초마다 status를 반복해서 볼수 있음
본문에서는 해당 방법을 설명함
또는 아래 링크처럼 쿼리로 확인도 가능함
참고 : 데이터 펌프 작업 모니터링 쿼리 ( https://positivemh.tistory.com/440 )
디렉토리 생성
|
1
2
3
|
SQL> create directory dptest as '/oraimsi/datapump';
Directory created.
|
expdp 수행
|
1
2
3
4
5
6
7
8
9
10
11
12
13
|
$ expdp system/oracle directory=dptest full=y dumpfile=full.dmp logfile=full.log
Export: Release 19.0.0.0.0 - Production on Fri Nov 14 19:25:55 2025
Version 19.27.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Starting "SYSTEM"."SYS_EXPORT_FULL_01": system/******** directory=dptest full=y dumpfile=full.dmp logfile=full.log
Processing object type DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/TABLE_DATA
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA
^C
|
Ctrl+c로 나가기
status 시 상태 확인가능
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
|
Export> status
Job: SYS_EXPORT_FULL_01
Operation: EXPORT
Mode: FULL
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 1
Job Error Count: 0
Job heartbeat: 6
Dump File: /oraimsi/datapump/full.dmp
bytes written: 106,496
Worker 1 Status:
Instance ID: 1
Instance name: ORA19DBFS
Host name: ora19fs
Object start time: Friday, 14 November, 2025 19:26:29
Object status at: Friday, 14 November, 2025 19:26:29
Process Name: DW00
State: EXECUTING
|
상태 자동으로 5초마다 확인
|
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
|
Export> status=5
Export> continue_client
Job: SYS_EXPORT_FULL_01
Operation: EXPORT
Mode: FULL
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 1
Job Error Count: 0
Job heartbeat: 5
Dump File: /oraimsi/datapump/full.dmp
bytes written: 180,224
Worker 1 Status:
Instance ID: 1
Instance name: ORA19DBFS
Host name: ora19fs
Object start time: Friday, 14 November, 2025 19:26:45
Object status at: Friday, 14 November, 2025 19:26:50
Process Name: DW00
State: EXECUTING
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
(5초 대기후 status 표시됨)
Job: SYS_EXPORT_FULL_01
Operation: EXPORT
Mode: FULL
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 1
Job Error Count: 0
Job heartbeat: 5
Dump File: /oraimsi/datapump/full.dmp
bytes written: 180,224
Worker 1 Status:
Instance ID: 1
Instance name: ORA19DBFS
Host name: ora19fs
Object start time: Friday, 14 November, 2025 19:26:45
Object status at: Friday, 14 November, 2025 19:26:50
Process Name: DW00
State: EXECUTING
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
|
5초마다 status가 표시됨
결론 : expdp나 impdp시 status 명령과 continue_client 명령을 사용해 상태를 편하게 원하는 초마다 확인 가능함
참조 :
'ORACLE > Admin' 카테고리의 다른 글
| 오라클 19c ssl(tls)을 이용한 tns(tcps) 연결 설정 (0) | 2025.12.02 |
|---|---|
| 오라클 19c varchar2 최대 길이 32767로 변경 (1) | 2025.12.01 |
| 오라클 19c 정적 리스너 이용하여 원격지 db에 접속 및 재시작 (0) | 2025.11.22 |
| 오라클 19c opatch debug 방법 (0) | 2025.11.19 |
| 오라클 19c 특정 테이블, 인덱스 용량 증가 추이 확인 (0) | 2025.11.17 |