[2025-06-19] datapump에서 data import시 nologging모드로 import 시키기 (Oracle 12cr1 new feature) (12cR2에서 테스트)
당연히 db가
force logging상태라면 무조건 redo log남게됨!
해당 테스트는 no force logging 상황에서만
유효함!
[실습
환경]
OS
: Oracle Linux Server 7.9 (Linux rdb01d 5.4.17-2102.201.3.el7uek.x86_64)
DB :
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit
Production
Host : tdb01p(192.168.0.31)
DB_NAME : PTDB
INSTANCE_NAME :
PTDB
DB_UNIQUE_NAME : PTDB
1. 대용량 테이블을 export
[PTDB:oracle@tdb01p][/home/oracle]$ alias
st
alias st='rlwrap sqlplus tuner/oracle'
[PTDB:oracle@tdb01p][/home/oracle]$ st
SQL*Plus: Release 12.2.0.1.0 Production on Thu Jun 19 18:52:35 2025
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Last Successful login time: Thu Jun 19 2025 18:22:22 +09:00
Connected
to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit
Production
[2025-06-19:18:52:35][tdb01p]<TUNER@PTDB> create directory datapump as '/home/oracle/datapump';
Directory created.
Elapsed:
00:00:00.01
[2025-06-19:18:52:35][tdb01p]<TUNER@PTDB> quit
Disconnected from Oracle Database 12c
Enterprise Edition Release 12.2.0.1.0 - 64bit
Production
[PTDB:oracle@tdb01p][/home/oracle]$ expdp tuner/oracle
tables=tuner.TB_ORD_DTL directory=datapump dumpfile=TB_ORD_DTL.dmp
logfile=TB_ORD_DTL.log
Export: Release 12.2.0.1.0 - Production on Thu Jun 19 18:53:40 2025
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
Connected
to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit
Production
Starting "TUNER"."SYS_EXPORT_TABLE_01": tuner/********
tables=tuner.TB_ORD_DTL directory=datapump dumpfile=TB_ORD_DTL.dmp
logfile=TB_ORD_DTL.log
Processing object type
TABLE_EXPORT/TABLE/TABLE_DATA
Processing object type
TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type
TABLE_EXPORT/TABLE/INDEX/STATISTICS/FUNCTIONAL_INDEX/INDEX_STATISTICS
Processing
object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object
type TABLE_EXPORT/TABLE/STATISTICS/MARKER
Processing object type
TABLE_EXPORT/TABLE/TABLE
Processing object type
TABLE_EXPORT/TABLE/COMMENT
Processing object type
TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type
TABLE_EXPORT/TABLE/INDEX/FUNCTIONAL_INDEX/INDEX
Processing object type
TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
. . exported
"TUNER"."TB_ORD_DTL":"P2020"."SYS_SUBP359" 0
KB 0 rows
. . exported
"TUNER"."TB_ORD_DTL":"P2020"."SYS_SUBP360" 0
KB 0 rows
. . exported
"TUNER"."TB_ORD_DTL":"P2020"."SYS_SUBP361" 0
KB 0 rows
. . exported
"TUNER"."TB_ORD_DTL":"P2020"."SYS_SUBP362" 0
KB 0 rows
. . exported
"TUNER"."TB_ORD_DTL":"P2020"."SYS_SUBP363" 0
KB 0 rows
. . exported
"TUNER"."TB_ORD_DTL":"P2020"."SYS_SUBP364" 0
KB 0 rows
. . exported
"TUNER"."TB_ORD_DTL":"P2020"."SYS_SUBP365" 0
KB 0 rows
. . exported
"TUNER"."TB_ORD_DTL":"P2020"."SYS_SUBP366" 0
KB 0 rows
. . exported
"TUNER"."TB_ORD_DTL":"P2021"."SYS_SUBP367" 52.15 MB 628835 rows
.
. exported "TUNER"."TB_ORD_DTL":"P2021"."SYS_SUBP368" 51.30 MB
618500 rows
. . exported "TUNER"."TB_ORD_DTL":"P2021"."SYS_SUBP369"
51.56 MB 621700 rows
. . exported
"TUNER"."TB_ORD_DTL":"P2021"."SYS_SUBP370" 52.35 MB 631200 rows
.
. exported "TUNER"."TB_ORD_DTL":"P2021"."SYS_SUBP371" 52.21 MB
629550 rows
. . exported "TUNER"."TB_ORD_DTL":"P2021"."SYS_SUBP372"
52.11 MB 628370 rows
. . exported
"TUNER"."TB_ORD_DTL":"P2021"."SYS_SUBP373" 51.92 MB 626100 rows
.
. exported "TUNER"."TB_ORD_DTL":"P2021"."SYS_SUBP374" 51.32 MB
618745 rows
. . exported "TUNER"."TB_ORD_DTL":"P2022"."SYS_SUBP375"
52.06 MB 627765 rows
. . exported
"TUNER"."TB_ORD_DTL":"P2022"."SYS_SUBP376" 52.17 MB 629100 rows
.
. exported "TUNER"."TB_ORD_DTL":"P2022"."SYS_SUBP377" 51.60 MB
622200 rows
. . exported "TUNER"."TB_ORD_DTL":"P2022"."SYS_SUBP378"
51.45 MB 620350 rows
. . exported
"TUNER"."TB_ORD_DTL":"P2022"."SYS_SUBP379" 52.32 MB 630915 rows
.
. exported "TUNER"."TB_ORD_DTL":"P2022"."SYS_SUBP380" 51.57 MB
621780 rows
. . exported "TUNER"."TB_ORD_DTL":"P2022"."SYS_SUBP381"
51.91 MB 625900 rows
. . exported
"TUNER"."TB_ORD_DTL":"P2022"."SYS_SUBP382" 52.16 MB 629005 rows
.
. exported "TUNER"."TB_ORD_DTL":"P2023"."SYS_SUBP383" 51.42 MB
620000 rows
. . exported "TUNER"."TB_ORD_DTL":"P2023"."SYS_SUBP384"
51.20 MB 617350 rows
. . exported
"TUNER"."TB_ORD_DTL":"P2023"."SYS_SUBP385" 51.85 MB 625200 rows
.
. exported "TUNER"."TB_ORD_DTL":"P2023"."SYS_SUBP386" 51.72 MB
623650 rows
. . exported "TUNER"."TB_ORD_DTL":"P2023"."SYS_SUBP387"
51.16 MB 616885 rows
. . exported
"TUNER"."TB_ORD_DTL":"P2023"."SYS_SUBP388" 51.16 MB 616820 rows
.
. exported "TUNER"."TB_ORD_DTL":"P2023"."SYS_SUBP389" 51.66 MB
622955 rows
. . exported "TUNER"."TB_ORD_DTL":"P2023"."SYS_SUBP390"
51.49 MB 620850 rows
. . exported
"TUNER"."TB_ORD_DTL":"P2024"."SYS_SUBP391" 51.93 MB 626100 rows
.
. exported "TUNER"."TB_ORD_DTL":"P2024"."SYS_SUBP392" 52.72 MB
635700 rows
. . exported "TUNER"."TB_ORD_DTL":"P2024"."SYS_SUBP393"
51.83 MB 625000 rows
. . exported
"TUNER"."TB_ORD_DTL":"P2024"."SYS_SUBP394" 51.72 MB 623650 rows
.
. exported "TUNER"."TB_ORD_DTL":"P2024"."SYS_SUBP395" 52.09 MB
628100 rows
. . exported "TUNER"."TB_ORD_DTL":"P2024"."SYS_SUBP396"
52.20 MB 629370 rows
. . exported
"TUNER"."TB_ORD_DTL":"P2024"."SYS_SUBP397" 52.67 MB 635095 rows
.
. exported "TUNER"."TB_ORD_DTL":"P2024"."SYS_SUBP398" 52.03 MB
627350 rows
. . exported "TUNER"."TB_ORD_DTL":"P2025"."SYS_SUBP399"
51.09 MB 615985 rows
. . exported
"TUNER"."TB_ORD_DTL":"P2025"."SYS_SUBP400" 52.29 MB 630500 rows
.
. exported "TUNER"."TB_ORD_DTL":"P2025"."SYS_SUBP401" 51.94 MB
626300 rows
. . exported "TUNER"."TB_ORD_DTL":"P2025"."SYS_SUBP402"
52.46 MB 632600 rows
. . exported
"TUNER"."TB_ORD_DTL":"P2025"."SYS_SUBP403" 51.62 MB 622450 rows
.
. exported "TUNER"."TB_ORD_DTL":"P2025"."SYS_SUBP404" 51.34 MB
619110 rows
. . exported "TUNER"."TB_ORD_DTL":"P2025"."SYS_SUBP405"
52.19 MB 629300 rows
. . exported
"TUNER"."TB_ORD_DTL":"P2025"."SYS_SUBP406" 52.64 MB 634750 rows
.
. exported "TUNER"."TB_ORD_DTL":"P2026"."SYS_SUBP407" 51.92 MB
626065 rows
. . exported "TUNER"."TB_ORD_DTL":"P2026"."SYS_SUBP408"
51.43 MB 620150 rows
. . exported
"TUNER"."TB_ORD_DTL":"P2026"."SYS_SUBP409" 51.85 MB 625280 rows
.
. exported "TUNER"."TB_ORD_DTL":"P2026"."SYS_SUBP410" 51.72 MB
623650 rows
. . exported "TUNER"."TB_ORD_DTL":"P2026"."SYS_SUBP411"
51.25 MB 617950 rows
. . exported
"TUNER"."TB_ORD_DTL":"P2026"."SYS_SUBP412" 51.67 MB 623050 rows
.
. exported "TUNER"."TB_ORD_DTL":"P2026"."SYS_SUBP413" 52.21 MB
629600 rows
. . exported "TUNER"."TB_ORD_DTL":"P2026"."SYS_SUBP414"
52.74 MB 635950 rows
. . exported
"TUNER"."TB_ORD_DTL":"P2027"."SYS_SUBP415" 51.49 MB 620850 rows
.
. exported "TUNER"."TB_ORD_DTL":"P2027"."SYS_SUBP416" 50.97 MB
614600 rows
. . exported "TUNER"."TB_ORD_DTL":"P2027"."SYS_SUBP417"
51.92 MB 626075 rows
. . exported
"TUNER"."TB_ORD_DTL":"P2027"."SYS_SUBP418" 51.75 MB 624000 rows
.
. exported "TUNER"."TB_ORD_DTL":"P2027"."SYS_SUBP419" 52.09 MB
628100 rows
. . exported "TUNER"."TB_ORD_DTL":"P2027"."SYS_SUBP420"
51.87 MB 625400 rows
. . exported
"TUNER"."TB_ORD_DTL":"P2027"."SYS_SUBP421" 51.62 MB 622450 rows
.
. exported "TUNER"."TB_ORD_DTL":"P2027"."SYS_SUBP422" 51.48 MB
620800 rows
. . exported "TUNER"."TB_ORD_DTL":"P2028"."SYS_SUBP423"
52.35 MB 631250 rows
. . exported
"TUNER"."TB_ORD_DTL":"P2028"."SYS_SUBP424" 52.94 MB 638450 rows
.
. exported "TUNER"."TB_ORD_DTL":"P2028"."SYS_SUBP425" 51.56 MB
621695 rows
. . exported "TUNER"."TB_ORD_DTL":"P2028"."SYS_SUBP426"
52.53 MB 633450 rows
. . exported
"TUNER"."TB_ORD_DTL":"P2028"."SYS_SUBP427" 52.71 MB 635700 rows
.
. exported "TUNER"."TB_ORD_DTL":"P2028"."SYS_SUBP428" 52.37 MB
631480 rows
. . exported "TUNER"."TB_ORD_DTL":"P2028"."SYS_SUBP429"
51.68 MB 623150 rows
. . exported
"TUNER"."TB_ORD_DTL":"P2028"."SYS_SUBP430" 52.32 MB 630950 rows
.
. exported "TUNER"."TB_ORD_DTL":"P2029"."SYS_SUBP431" 51.39 MB
619650 rows
. . exported "TUNER"."TB_ORD_DTL":"P2029"."SYS_SUBP432"
50.85 MB 613150 rows
. . exported
"TUNER"."TB_ORD_DTL":"P2029"."SYS_SUBP433" 51.96 MB 626550 rows
.
. exported "TUNER"."TB_ORD_DTL":"P2029"."SYS_SUBP434" 52.21 MB
629550 rows
. . exported "TUNER"."TB_ORD_DTL":"P2029"."SYS_SUBP435"
51.70 MB 623450 rows
. . exported
"TUNER"."TB_ORD_DTL":"P2029"."SYS_SUBP436" 50.58 MB 609840 rows
.
. exported "TUNER"."TB_ORD_DTL":"P2029"."SYS_SUBP437" 51.69 MB
623250 rows
. . exported "TUNER"."TB_ORD_DTL":"P2029"."SYS_SUBP438"
52.20 MB 629400 rows
. . exported
"TUNER"."TB_ORD_DTL":"P2030"."SYS_SUBP439" 51.40 MB 619800 rows
.
. exported "TUNER"."TB_ORD_DTL":"P2030"."SYS_SUBP440" 51.76 MB
624200 rows
. . exported "TUNER"."TB_ORD_DTL":"P2030"."SYS_SUBP441"
52.19 MB 629350 rows
. . exported
"TUNER"."TB_ORD_DTL":"P2030"."SYS_SUBP442" 51.04 MB 615500 rows
.
. exported "TUNER"."TB_ORD_DTL":"P2030"."SYS_SUBP443" 51.32 MB
618800 rows
. . exported "TUNER"."TB_ORD_DTL":"P2030"."SYS_SUBP444"
51.88 MB 625530 rows
. . exported
"TUNER"."TB_ORD_DTL":"P2030"."SYS_SUBP445" 52.10 MB 628200 rows
.
. exported "TUNER"."TB_ORD_DTL":"P2030"."SYS_SUBP446" 51.30 MB
618600 rows
. . exported
"TUNER"."TB_ORD_DTL":"P_AFT_2030"."SYS_SUBP447" 0
KB 0 rows
. . exported
"TUNER"."TB_ORD_DTL":"P_AFT_2030"."SYS_SUBP448" 0
KB 0 rows
. . exported
"TUNER"."TB_ORD_DTL":"P_AFT_2030"."SYS_SUBP449" 0
KB 0 rows
. . exported
"TUNER"."TB_ORD_DTL":"P_AFT_2030"."SYS_SUBP450" 0
KB 0 rows
. . exported
"TUNER"."TB_ORD_DTL":"P_AFT_2030"."SYS_SUBP451" 0
KB 0 rows
. . exported
"TUNER"."TB_ORD_DTL":"P_AFT_2030"."SYS_SUBP452" 0
KB 0 rows
. . exported
"TUNER"."TB_ORD_DTL":"P_AFT_2030"."SYS_SUBP453" 0
KB 0 rows
. . exported
"TUNER"."TB_ORD_DTL":"P_AFT_2030"."SYS_SUBP454" 0
KB 0 rows
. . exported
"TUNER"."TB_ORD_DTL":"P_BEF_2020"."SYS_SUBP351" 0
KB 0 rows
. . exported
"TUNER"."TB_ORD_DTL":"P_BEF_2020"."SYS_SUBP352" 0
KB 0 rows
. . exported
"TUNER"."TB_ORD_DTL":"P_BEF_2020"."SYS_SUBP353" 0
KB 0 rows
. . exported
"TUNER"."TB_ORD_DTL":"P_BEF_2020"."SYS_SUBP354" 0
KB 0 rows
. . exported
"TUNER"."TB_ORD_DTL":"P_BEF_2020"."SYS_SUBP355" 0
KB 0 rows
. . exported
"TUNER"."TB_ORD_DTL":"P_BEF_2020"."SYS_SUBP356" 0
KB 0 rows
. . exported
"TUNER"."TB_ORD_DTL":"P_BEF_2020"."SYS_SUBP357" 0
KB 0 rows
. . exported
"TUNER"."TB_ORD_DTL":"P_BEF_2020"."SYS_SUBP358" 0
KB 0 rows
Master table
"TUNER"."SYS_EXPORT_TABLE_01" successfully
loaded/unloaded
******************************************************************************
Dump
file set for TUNER.SYS_EXPORT_TABLE_01 is:
/home/oracle/datapump/TB_ORD_DTL.dmp
Job "TUNER"."SYS_EXPORT_TABLE_01"
successfully completed at Thu Jun 19 18:54:33 2025 elapsed 0
00:00:54
*/
[PTDB:oracle@tdb01p][/home/oracle/datapump]$ ls -lh
/home/oracle/datapump/
total 4.1G
-rw-r-----. 1 oracle
asmadmin 4.1G Jun 19 18:54 TB_ORD_DTL.dmp
-rw-r--r--. 1 oracle asmadmin 9.5K
Jun 19 18:54 TB_ORD_DTL.log
--> 해당 테이블의 용량이 총 4.1 기가인것을 알 수 있음
2. export한 대용량 테이블을 import 시킬 신규 유저 및 테이블스페이스를 생성
--> 원활한 테스트를 위해서 일부러 생성함
[PTDB:oracle@tdb01p][/home/oracle]$ alias
ss
alias ss='rlwrap sqlplus "/as sysdba"'
[PTDB:oracle@tdb01p][/home/oracle]$
ss
SQL*Plus: Release 12.2.0.1.0 Production on Thu Jun 19 18:59:26 2025
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release
12.2.0.1.0 - 64bit Production
[2025-06-19:20:55:57][tdb01p]<SYS@PTDB>
DROP USER
TUNER_DEV CASCADE;
CREATE USER TUNER_DEV IDENTIFIED BY "oracle";
GRANT
RESOURCE, DBA, CONNECT TO TUNER_DEV;
ALTER USER TUNER_DEV ACCOUNT
UNLOCK;
--DROP TABLESPACE TUNER_DEV_DATA1 INCLUDING CONTENTS AND DATAFILES;
CREATE TABLESPACE TUNER_DEV_DATA1
DATAFILE '+DATA1' SIZE
4G
AUTOEXTEND ON NEXT 512M MAXSIZE UNLIMITED
;
--DROP TABLESPACE TUNER_DEV_IDX1 INCLUDING CONTENTS AND DATAFILES;
CREATE TABLESPACE TUNER_DEV_IDX1
DATAFILE '+DATA1' SIZE
1G
AUTOEXTEND ON NEXT 512M MAXSIZE UNLIMITED
;
--DROP TABLESPACE TUNER_DEV_TEMP INCLUDING
CONTENTS AND DATAFILES;
CREATE TEMPORARY
TABLESPACE TUNER_DEV_TEMP
TEMPFILE '+DATA1' SIZE 1G
AUTOEXTEND ON NEXT
100M MAXSIZE UNLIMITED
;
ALTER USER
TUNER_DEV DEFAULT TABLESPACE TUNER_DEV_DATA1;
ALTER USER TUNER_DEV TEMPORARY
TABLESPACE TUNER_DEV_TEMP;
3. 현재의 redo size를 측정함
[2025-06-19:18:59:26][tdb01p]<SYS@PTDB> archive log list;
Database log
mode
Archive Mode
Automatic
archival
Enabled
Archive
destination
+FRA1
Oldest online log sequence 229
Next log
sequence to archive 231
Current log
sequence
231
--> 현재 아카이브 로그 시퀀스는 231번임
[2025-06-19:20:55:57][tdb01p]<SYS@PTDB>
col name
for a20
select name, value/1024/1024 mb from v$sysstat where name ='redo
size';
NAME
MB
-------------------- ----------
redo
size
5149.38637
1 row selected.
Elapsed: 00:00:00.01
--> 약 5기가 정도됨
4. 온라인 로그 생성 최소화 옵션 주고 import 시도
--TRANSFORM=DISABLE_ARCHIVE_LOGGING:Y 옵션을 줘서 import 시킴
[PTDB:oracle@tdb01p][/home/oracle/datapump]$ impdp tuner/oracle dumpfile=TB_ORD_DTL.dmp logfile=import_TB_ORD_DTL.log directory=datapump tables=TUNER.TB_ORD_DTL remap_schema=tuner:TUNER_DEV remap_table=TUNER.TB_ORD_DTL:TB_ORD_DTL_BAK TRANSFORM=DISABLE_ARCHIVE_LOGGING:Y
Import: Release 12.2.0.1.0 - Production on Thu Jun 19 21:00:16 2025
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
Connected
to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit
Production
Master table "TUNER"."SYS_IMPORT_TABLE_01" successfully
loaded/unloaded
Starting "TUNER"."SYS_IMPORT_TABLE_01": tuner/********
dumpfile=TB_ORD_DTL.dmp logfile=import_TB_ORD_DTL.log directory=datapump
tables=TUNER.TB_ORD_DTL remap_schema=tuner:TUNER_DEV
remap_table=TUNER.TB_ORD_DTL:TB_ORD_DTL_BAK
TRANSFORM=DISABLE_ARCHIVE_LOGGING:Y
Processing object type
TABLE_EXPORT/TABLE/TABLE
Processing object type
TABLE_EXPORT/TABLE/TABLE_DATA
. . imported
"TUNER_DEV"."TB_ORD_DTL_BAK":"P_BEF_2020"."SYS_SUBP351"
0 KB 0 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL_BAK":"P_BEF_2020"."SYS_SUBP352"
0 KB 0 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL_BAK":"P_BEF_2020"."SYS_SUBP353"
0 KB 0 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL_BAK":"P_BEF_2020"."SYS_SUBP354"
0 KB 0 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL_BAK":"P_BEF_2020"."SYS_SUBP355"
0 KB 0 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL_BAK":"P_BEF_2020"."SYS_SUBP356"
0 KB 0 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL_BAK":"P_BEF_2020"."SYS_SUBP357"
0 KB 0 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL_BAK":"P_BEF_2020"."SYS_SUBP358"
0 KB 0 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL_BAK":"P2020"."SYS_SUBP359"
0 KB 0 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL_BAK":"P2020"."SYS_SUBP360"
0 KB 0 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL_BAK":"P2020"."SYS_SUBP361"
0 KB 0 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL_BAK":"P2020"."SYS_SUBP362"
0 KB 0 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL_BAK":"P2020"."SYS_SUBP363"
0 KB 0 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL_BAK":"P2020"."SYS_SUBP364"
0 KB 0 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL_BAK":"P2020"."SYS_SUBP365"
0 KB 0 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL_BAK":"P2020"."SYS_SUBP366"
0 KB 0 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL_BAK":"P2021"."SYS_SUBP367" 52.15 MB 628835
rows
. . imported "TUNER_DEV"."TB_ORD_DTL_BAK":"P2021"."SYS_SUBP368"
51.30 MB 618500 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL_BAK":"P2021"."SYS_SUBP369" 51.56 MB 621700
rows
. . imported "TUNER_DEV"."TB_ORD_DTL_BAK":"P2021"."SYS_SUBP370"
52.35 MB 631200 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL_BAK":"P2021"."SYS_SUBP371" 52.21 MB 629550
rows
. . imported "TUNER_DEV"."TB_ORD_DTL_BAK":"P2021"."SYS_SUBP372"
52.11 MB 628370 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL_BAK":"P2021"."SYS_SUBP373" 51.92 MB 626100
rows
. . imported "TUNER_DEV"."TB_ORD_DTL_BAK":"P2021"."SYS_SUBP374"
51.32 MB 618745 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL_BAK":"P2022"."SYS_SUBP375" 52.06 MB 627765
rows
. . imported "TUNER_DEV"."TB_ORD_DTL_BAK":"P2022"."SYS_SUBP376"
52.17 MB 629100 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL_BAK":"P2022"."SYS_SUBP377" 51.60 MB 622200
rows
. . imported "TUNER_DEV"."TB_ORD_DTL_BAK":"P2022"."SYS_SUBP378"
51.45 MB 620350 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL_BAK":"P2022"."SYS_SUBP379" 52.32 MB 630915
rows
. . imported "TUNER_DEV"."TB_ORD_DTL_BAK":"P2022"."SYS_SUBP380"
51.57 MB 621780 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL_BAK":"P2022"."SYS_SUBP381" 51.91 MB 625900
rows
. . imported "TUNER_DEV"."TB_ORD_DTL_BAK":"P2022"."SYS_SUBP382"
52.16 MB 629005 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL_BAK":"P2023"."SYS_SUBP383" 51.42 MB 620000
rows
. . imported "TUNER_DEV"."TB_ORD_DTL_BAK":"P2023"."SYS_SUBP384"
51.20 MB 617350 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL_BAK":"P2023"."SYS_SUBP385" 51.85 MB 625200
rows
. . imported "TUNER_DEV"."TB_ORD_DTL_BAK":"P2023"."SYS_SUBP386"
51.72 MB 623650 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL_BAK":"P2023"."SYS_SUBP387" 51.16 MB 616885
rows
. . imported "TUNER_DEV"."TB_ORD_DTL_BAK":"P2023"."SYS_SUBP388"
51.16 MB 616820 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL_BAK":"P2023"."SYS_SUBP389" 51.66 MB 622955
rows
. . imported "TUNER_DEV"."TB_ORD_DTL_BAK":"P2023"."SYS_SUBP390"
51.49 MB 620850 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL_BAK":"P2024"."SYS_SUBP391" 51.93 MB 626100
rows
. . imported "TUNER_DEV"."TB_ORD_DTL_BAK":"P2024"."SYS_SUBP392"
52.72 MB 635700 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL_BAK":"P2024"."SYS_SUBP393" 51.83 MB 625000
rows
. . imported "TUNER_DEV"."TB_ORD_DTL_BAK":"P2024"."SYS_SUBP394"
51.72 MB 623650 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL_BAK":"P2024"."SYS_SUBP395" 52.09 MB 628100
rows
. . imported "TUNER_DEV"."TB_ORD_DTL_BAK":"P2024"."SYS_SUBP397"
52.67 MB 635095 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL_BAK":"P2029"."SYS_SUBP436" 50.58 MB 609840
rows
. . imported "TUNER_DEV"."TB_ORD_DTL_BAK":"P2029"."SYS_SUBP437"
51.69 MB 623250 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL_BAK":"P2029"."SYS_SUBP438" 52.20 MB 629400
rows
. . imported "TUNER_DEV"."TB_ORD_DTL_BAK":"P2030"."SYS_SUBP439"
51.40 MB 619800 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL_BAK":"P2030"."SYS_SUBP440" 51.76 MB 624200
rows
. . imported "TUNER_DEV"."TB_ORD_DTL_BAK":"P2030"."SYS_SUBP441"
52.19 MB 629350 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL_BAK":"P2030"."SYS_SUBP442" 51.04 MB 615500
rows
. . imported "TUNER_DEV"."TB_ORD_DTL_BAK":"P2030"."SYS_SUBP443"
51.32 MB 618800 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL_BAK":"P2030"."SYS_SUBP444" 51.88 MB 625530
rows
. . imported "TUNER_DEV"."TB_ORD_DTL_BAK":"P2030"."SYS_SUBP445"
52.10 MB 628200 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL_BAK":"P2030"."SYS_SUBP446" 51.30 MB 618600
rows
. . imported
"TUNER_DEV"."TB_ORD_DTL_BAK":"P_AFT_2030"."SYS_SUBP447"
0 KB 0 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL_BAK":"P_AFT_2030"."SYS_SUBP448"
0 KB 0 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL_BAK":"P_AFT_2030"."SYS_SUBP449"
0 KB 0 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL_BAK":"P_AFT_2030"."SYS_SUBP450"
0 KB 0 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL_BAK":"P_AFT_2030"."SYS_SUBP451"
0 KB 0 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL_BAK":"P_AFT_2030"."SYS_SUBP452"
0 KB 0 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL_BAK":"P_AFT_2030"."SYS_SUBP453"
0 KB 0 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL_BAK":"P_AFT_2030"."SYS_SUBP454"
0 KB 0 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL_BAK":"P2024"."SYS_SUBP398" 52.03 MB 627350
rows
. . imported "TUNER_DEV"."TB_ORD_DTL_BAK":"P2025"."SYS_SUBP399"
51.09 MB 615985 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL_BAK":"P2025"."SYS_SUBP400" 52.29 MB 630500
rows
. . imported "TUNER_DEV"."TB_ORD_DTL_BAK":"P2025"."SYS_SUBP401"
51.94 MB 626300 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL_BAK":"P2025"."SYS_SUBP402" 52.46 MB 632600
rows
. . imported "TUNER_DEV"."TB_ORD_DTL_BAK":"P2025"."SYS_SUBP403"
51.62 MB 622450 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL_BAK":"P2025"."SYS_SUBP404" 51.34 MB 619110
rows
. . imported "TUNER_DEV"."TB_ORD_DTL_BAK":"P2025"."SYS_SUBP405"
52.19 MB 629300 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL_BAK":"P2025"."SYS_SUBP406" 52.64 MB 634750
rows
. . imported "TUNER_DEV"."TB_ORD_DTL_BAK":"P2026"."SYS_SUBP407"
51.92 MB 626065 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL_BAK":"P2026"."SYS_SUBP408" 51.43 MB 620150
rows
. . imported "TUNER_DEV"."TB_ORD_DTL_BAK":"P2026"."SYS_SUBP409"
51.85 MB 625280 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL_BAK":"P2026"."SYS_SUBP410" 51.72 MB 623650
rows
. . imported "TUNER_DEV"."TB_ORD_DTL_BAK":"P2026"."SYS_SUBP411"
51.25 MB 617950 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL_BAK":"P2026"."SYS_SUBP412" 51.67 MB 623050
rows
. . imported "TUNER_DEV"."TB_ORD_DTL_BAK":"P2026"."SYS_SUBP413"
52.21 MB 629600 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL_BAK":"P2026"."SYS_SUBP414" 52.74 MB 635950
rows
. . imported "TUNER_DEV"."TB_ORD_DTL_BAK":"P2027"."SYS_SUBP416"
50.97 MB 614600 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL_BAK":"P2027"."SYS_SUBP417" 51.92 MB 626075
rows
. . imported "TUNER_DEV"."TB_ORD_DTL_BAK":"P2027"."SYS_SUBP418"
51.75 MB 624000 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL_BAK":"P2027"."SYS_SUBP419" 52.09 MB 628100
rows
. . imported "TUNER_DEV"."TB_ORD_DTL_BAK":"P2027"."SYS_SUBP420"
51.87 MB 625400 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL_BAK":"P2027"."SYS_SUBP421" 51.62 MB 622450
rows
. . imported "TUNER_DEV"."TB_ORD_DTL_BAK":"P2027"."SYS_SUBP422"
51.48 MB 620800 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL_BAK":"P2028"."SYS_SUBP423" 52.35 MB 631250
rows
. . imported "TUNER_DEV"."TB_ORD_DTL_BAK":"P2028"."SYS_SUBP424"
52.94 MB 638450 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL_BAK":"P2028"."SYS_SUBP425" 51.56 MB 621695
rows
. . imported "TUNER_DEV"."TB_ORD_DTL_BAK":"P2028"."SYS_SUBP426"
52.53 MB 633450 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL_BAK":"P2028"."SYS_SUBP427" 52.71 MB 635700
rows
. . imported "TUNER_DEV"."TB_ORD_DTL_BAK":"P2028"."SYS_SUBP428"
52.37 MB 631480 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL_BAK":"P2028"."SYS_SUBP429" 51.68 MB 623150
rows
. . imported "TUNER_DEV"."TB_ORD_DTL_BAK":"P2028"."SYS_SUBP430"
52.32 MB 630950 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL_BAK":"P2029"."SYS_SUBP431" 51.39 MB 619650
rows
. . imported "TUNER_DEV"."TB_ORD_DTL_BAK":"P2029"."SYS_SUBP432"
50.85 MB 613150 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL_BAK":"P2029"."SYS_SUBP433" 51.96 MB 626550
rows
. . imported "TUNER_DEV"."TB_ORD_DTL_BAK":"P2029"."SYS_SUBP435"
51.70 MB 623450 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL_BAK":"P2024"."SYS_SUBP396" 52.20 MB 629370
rows
. . imported "TUNER_DEV"."TB_ORD_DTL_BAK":"P2027"."SYS_SUBP415"
51.49 MB 620850 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL_BAK":"P2029"."SYS_SUBP434" 52.21 MB 629550
rows
ORA-39379: Logging for table "TUNER_DEV"."TB_ORD_DTL_BAK" may not be
restored.
Processing
object type TABLE_EXPORT/TABLE/COMMENT
Processing object type
TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type
TABLE_EXPORT/TABLE/INDEX/FUNCTIONAL_INDEX/INDEX
Processing object type
TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type
TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type
TABLE_EXPORT/TABLE/INDEX/STATISTICS/FUNCTIONAL_INDEX/INDEX_STATISTICS
Processing
object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object
type TABLE_EXPORT/TABLE/STATISTICS/MARKER
Job "TUNER"."SYS_IMPORT_TABLE_01"
completed with 1 error(s) at Thu Jun 19 21:08:06 2025 elapsed 0
00:07:50
[2025-06-19:20:55:57][tdb01p]<SYS@PTDB> archive log list;
Database log
mode
Archive Mode
Automatic
archival
Enabled
Archive
destination
+FRA1
Oldest online log sequence 277
Next log
sequence to archive 279
Current log
sequence
279
[2025-06-19:20:55:57][tdb01p]<SYS@PTDB> select name, value/1024/1024 mb from v$sysstat where name ='redo
size';
NAME
MB
-------------------- ----------
redo
size
14381.0862
1 row selected.
Elapsed:
00:00:00.04
-->
로그가 그대로 남았음 (5기가에서 14기가로 약
9기가 생성됨)
--> remap_table을 써서 redo log
발생이 최소화 되지
않았음---------------------------------------------------------------------------
TRANSFORM=DISABLE_ARCHIVE_LOGGING:Y
Data Pump Parameter Does Not Have Desired Effect with Remap_Table Parameter (Doc
ID 2729640.1)
DISABLE_ARCHIVE_LOGGING 옵션이 REMAP_TABLE과 함께 쓸 때, "기대했던 효과(즉, 아카이브
로그 최소화)가 안 나올 수 있다" 는 내용임.
원래 테이블 이름 그대로 import 할 땐 DISABLE_ARCHIVE_LOGGING이 정상적으로 동작해서
archive log가 줄어듦.
하지만,
REMAP_TABLE(테이블명을 바꿔서 import) 할 경우에는 archive log가 여전히 많이 생성될 수 있음. 즉, 옵션이 제대로
적용되지 않는다.
DISABLE_ARCHIVE_LOGGING=Y → Archive
log 발생 줄임
REMAP_TABLE → 테이블명 바꿔 import하는
것임
두 개를 같이 쓰면, redo
로그를 줄이는 옵션이 안 먹힌다는 것이 문서의 핵심 요지
-----------------------------------------------------------------------------------------------------------------------------------
--우선 테이블 제거
[PTDB:oracle@tdb01p][/home/oracle]$ sqlplus tuner_dev/oracle
SQL*Plus: Release 12.2.0.1.0 Production on Thu Jun 19 21:20:24 2025
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Last Successful login time: Thu Jun 19 2025 21:03:24 +09:00
Connected
to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit
Production
[2025-06-19:21:20:24][tdb01p]<TUNER_DEV@PTDB> DROP TABLE TUNER_DEV.TB_ORD_DTL_BAK;
Table dropped.
Elapsed: 00:00:00.55
5. remap_table옵션을 빼고 리두 로그가 최소화되도록 다시 import 시도
--sys로
접속
[2025-06-19:20:55:57][tdb01p]<SYS@PTDB> archive log list;
Database log
mode
Archive Mode
Automatic
archival
Enabled
Archive
destination
+FRA1
Oldest online log sequence 277
Next log
sequence to archive 279
Current log
sequence
279
--> 현재 아카이브 시퀀스는
279번임
[2025-06-19:20:55:57][tdb01p]<SYS@PTDB> select name, value/1024/1024 mb from v$sysstat where name ='redo
size';
NAME
MB
-------------------- ----------
redo
size
14384.4444
1 row selected.
Elapsed: 00:00:00.01
--> 현재 약 14기가
[PTDB:oracle@tdb01p][/home/oracle/datapump]$ impdp tuner/oracle dumpfile=TB_ORD_DTL.dmp logfile=import_TB_ORD_DTL.log directory=datapump tables=TUNER.TB_ORD_DTL remap_schema=tuner:TUNER_DEV TRANSFORM=DISABLE_ARCHIVE_LOGGING:Y
Import: Release 12.2.0.1.0 - Production on Thu Jun 19 21:21:06 2025
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
Connected
to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit
Production
Master table "TUNER"."SYS_IMPORT_TABLE_01" successfully
loaded/unloaded
Starting "TUNER"."SYS_IMPORT_TABLE_01": tuner/********
dumpfile=TB_ORD_DTL.dmp logfile=import_TB_ORD_DTL.log directory=datapump
tables=TUNER.TB_ORD_DTL remap_schema=tuner:TUNER_DEV
TRANSFORM=DISABLE_ARCHIVE_LOGGING:Y
Processing object type
TABLE_EXPORT/TABLE/TABLE
Processing object type
TABLE_EXPORT/TABLE/TABLE_DATA
. . imported
"TUNER_DEV"."TB_ORD_DTL":"P_BEF_2020"."SYS_SUBP351"
0 KB 0 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL":"P_BEF_2020"."SYS_SUBP352"
0 KB 0 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL":"P_BEF_2020"."SYS_SUBP353"
0 KB 0 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL":"P_BEF_2020"."SYS_SUBP354"
0 KB 0 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL":"P_BEF_2020"."SYS_SUBP355"
0 KB 0 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL":"P_BEF_2020"."SYS_SUBP356"
0 KB 0 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL":"P_BEF_2020"."SYS_SUBP357"
0 KB 0 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL":"P_BEF_2020"."SYS_SUBP358"
0 KB 0 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL":"P2020"."SYS_SUBP359" 0
KB 0 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL":"P2020"."SYS_SUBP360" 0
KB 0 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL":"P2020"."SYS_SUBP361" 0
KB 0 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL":"P2020"."SYS_SUBP362" 0
KB 0 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL":"P2020"."SYS_SUBP363" 0
KB 0 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL":"P2020"."SYS_SUBP364" 0
KB 0 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL":"P2020"."SYS_SUBP365" 0
KB 0 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL":"P2020"."SYS_SUBP366" 0
KB 0 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL":"P2021"."SYS_SUBP367" 52.15 MB 628835
rows
. . imported "TUNER_DEV"."TB_ORD_DTL":"P2021"."SYS_SUBP368" 51.30
MB 618500 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL":"P2021"."SYS_SUBP369" 51.56 MB 621700
rows
. . imported "TUNER_DEV"."TB_ORD_DTL":"P2021"."SYS_SUBP370" 52.35
MB 631200 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL":"P2021"."SYS_SUBP371" 52.21 MB 629550
rows
. . imported "TUNER_DEV"."TB_ORD_DTL":"P2021"."SYS_SUBP372" 52.11
MB 628370 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL":"P2021"."SYS_SUBP373" 51.92 MB 626100
rows
. . imported "TUNER_DEV"."TB_ORD_DTL":"P2021"."SYS_SUBP374" 51.32
MB 618745 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL":"P2022"."SYS_SUBP375" 52.06 MB 627765
rows
. . imported "TUNER_DEV"."TB_ORD_DTL":"P2022"."SYS_SUBP376" 52.17
MB 629100 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL":"P2022"."SYS_SUBP377" 51.60 MB 622200
rows
. . imported "TUNER_DEV"."TB_ORD_DTL":"P2022"."SYS_SUBP378" 51.45
MB 620350 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL":"P2022"."SYS_SUBP379" 52.32 MB 630915
rows
. . imported "TUNER_DEV"."TB_ORD_DTL":"P2022"."SYS_SUBP380" 51.57
MB 621780 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL":"P2022"."SYS_SUBP381" 51.91 MB 625900
rows
. . imported "TUNER_DEV"."TB_ORD_DTL":"P2022"."SYS_SUBP382" 52.16
MB 629005 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL":"P2023"."SYS_SUBP383" 51.42 MB 620000
rows
. . imported "TUNER_DEV"."TB_ORD_DTL":"P2023"."SYS_SUBP384" 51.20
MB 617350 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL":"P2023"."SYS_SUBP385" 51.85 MB 625200
rows
. . imported "TUNER_DEV"."TB_ORD_DTL":"P2023"."SYS_SUBP386" 51.72
MB 623650 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL":"P2023"."SYS_SUBP387" 51.16 MB 616885
rows
. . imported "TUNER_DEV"."TB_ORD_DTL":"P2023"."SYS_SUBP388" 51.16
MB 616820 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL":"P2023"."SYS_SUBP389" 51.66 MB 622955
rows
. . imported "TUNER_DEV"."TB_ORD_DTL":"P2023"."SYS_SUBP390" 51.49
MB 620850 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL":"P2024"."SYS_SUBP391" 51.93 MB 626100
rows
. . imported "TUNER_DEV"."TB_ORD_DTL":"P2024"."SYS_SUBP392" 52.72
MB 635700 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL":"P2024"."SYS_SUBP393" 51.83 MB 625000
rows
. . imported "TUNER_DEV"."TB_ORD_DTL":"P2024"."SYS_SUBP394" 51.72
MB 623650 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL":"P2024"."SYS_SUBP395" 52.09 MB 628100
rows
. . imported "TUNER_DEV"."TB_ORD_DTL":"P2024"."SYS_SUBP397" 52.67
MB 635095 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL":"P2029"."SYS_SUBP436" 50.58 MB 609840
rows
. . imported "TUNER_DEV"."TB_ORD_DTL":"P2029"."SYS_SUBP437" 51.69
MB 623250 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL":"P2029"."SYS_SUBP438" 52.20 MB 629400
rows
. . imported "TUNER_DEV"."TB_ORD_DTL":"P2030"."SYS_SUBP439" 51.40
MB 619800 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL":"P2030"."SYS_SUBP440" 51.76 MB 624200
rows
. . imported "TUNER_DEV"."TB_ORD_DTL":"P2030"."SYS_SUBP441" 52.19
MB 629350 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL":"P2030"."SYS_SUBP442" 51.04 MB 615500
rows
. . imported "TUNER_DEV"."TB_ORD_DTL":"P2030"."SYS_SUBP443" 51.32
MB 618800 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL":"P2030"."SYS_SUBP444" 51.88 MB 625530
rows
. . imported "TUNER_DEV"."TB_ORD_DTL":"P2030"."SYS_SUBP445" 52.10
MB 628200 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL":"P2030"."SYS_SUBP446" 51.30 MB 618600
rows
. . imported
"TUNER_DEV"."TB_ORD_DTL":"P_AFT_2030"."SYS_SUBP447"
0 KB 0 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL":"P_AFT_2030"."SYS_SUBP448"
0 KB 0 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL":"P_AFT_2030"."SYS_SUBP449"
0 KB 0 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL":"P_AFT_2030"."SYS_SUBP450"
0 KB 0 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL":"P_AFT_2030"."SYS_SUBP451"
0 KB 0 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL":"P_AFT_2030"."SYS_SUBP452"
0 KB 0 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL":"P_AFT_2030"."SYS_SUBP453"
0 KB 0 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL":"P_AFT_2030"."SYS_SUBP454"
0 KB 0 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL":"P2024"."SYS_SUBP398" 52.03 MB 627350
rows
. . imported "TUNER_DEV"."TB_ORD_DTL":"P2025"."SYS_SUBP399" 51.09
MB 615985 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL":"P2025"."SYS_SUBP400" 52.29 MB 630500
rows
. . imported "TUNER_DEV"."TB_ORD_DTL":"P2025"."SYS_SUBP401" 51.94
MB 626300 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL":"P2025"."SYS_SUBP402" 52.46 MB 632600
rows
. . imported "TUNER_DEV"."TB_ORD_DTL":"P2025"."SYS_SUBP403" 51.62
MB 622450 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL":"P2025"."SYS_SUBP404" 51.34 MB 619110
rows
. . imported "TUNER_DEV"."TB_ORD_DTL":"P2025"."SYS_SUBP405" 52.19
MB 629300 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL":"P2025"."SYS_SUBP406" 52.64 MB 634750
rows
. . imported "TUNER_DEV"."TB_ORD_DTL":"P2026"."SYS_SUBP407" 51.92
MB 626065 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL":"P2026"."SYS_SUBP408" 51.43 MB 620150
rows
. . imported "TUNER_DEV"."TB_ORD_DTL":"P2026"."SYS_SUBP409" 51.85
MB 625280 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL":"P2026"."SYS_SUBP410" 51.72 MB 623650
rows
. . imported "TUNER_DEV"."TB_ORD_DTL":"P2026"."SYS_SUBP411" 51.25
MB 617950 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL":"P2026"."SYS_SUBP412" 51.67 MB 623050
rows
. . imported "TUNER_DEV"."TB_ORD_DTL":"P2026"."SYS_SUBP413" 52.21
MB 629600 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL":"P2026"."SYS_SUBP414" 52.74 MB 635950
rows
. . imported "TUNER_DEV"."TB_ORD_DTL":"P2027"."SYS_SUBP416" 50.97
MB 614600 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL":"P2027"."SYS_SUBP417" 51.92 MB 626075
rows
. . imported "TUNER_DEV"."TB_ORD_DTL":"P2027"."SYS_SUBP418" 51.75
MB 624000 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL":"P2027"."SYS_SUBP419" 52.09 MB 628100
rows
. . imported "TUNER_DEV"."TB_ORD_DTL":"P2027"."SYS_SUBP420" 51.87
MB 625400 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL":"P2027"."SYS_SUBP421" 51.62 MB 622450
rows
. . imported "TUNER_DEV"."TB_ORD_DTL":"P2027"."SYS_SUBP422" 51.48
MB 620800 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL":"P2028"."SYS_SUBP423" 52.35 MB 631250
rows
. . imported "TUNER_DEV"."TB_ORD_DTL":"P2028"."SYS_SUBP424" 52.94
MB 638450 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL":"P2028"."SYS_SUBP425" 51.56 MB 621695
rows
. . imported "TUNER_DEV"."TB_ORD_DTL":"P2028"."SYS_SUBP426" 52.53
MB 633450 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL":"P2028"."SYS_SUBP427" 52.71 MB 635700
rows
. . imported "TUNER_DEV"."TB_ORD_DTL":"P2028"."SYS_SUBP428" 52.37
MB 631480 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL":"P2028"."SYS_SUBP429" 51.68 MB 623150
rows
. . imported "TUNER_DEV"."TB_ORD_DTL":"P2028"."SYS_SUBP430" 52.32
MB 630950 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL":"P2029"."SYS_SUBP431" 51.39 MB 619650
rows
. . imported "TUNER_DEV"."TB_ORD_DTL":"P2029"."SYS_SUBP432" 50.85
MB 613150 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL":"P2029"."SYS_SUBP433" 51.96 MB 626550
rows
. . imported "TUNER_DEV"."TB_ORD_DTL":"P2029"."SYS_SUBP435" 51.70
MB 623450 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL":"P2024"."SYS_SUBP396" 52.20 MB 629370
rows
. . imported "TUNER_DEV"."TB_ORD_DTL":"P2027"."SYS_SUBP415" 51.49
MB 620850 rows
. . imported
"TUNER_DEV"."TB_ORD_DTL":"P2029"."SYS_SUBP434" 52.21 MB 629550
rows
Processing object type TABLE_EXPORT/TABLE/COMMENT
Processing object
type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing
object type TABLE_EXPORT/TABLE/INDEX/FUNCTIONAL_INDEX/INDEX
Processing object
type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type
TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type
TABLE_EXPORT/TABLE/INDEX/STATISTICS/FUNCTIONAL_INDEX/INDEX_STATISTICS
Processing
object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object
type TABLE_EXPORT/TABLE/STATISTICS/MARKER
Job "TUNER"."SYS_IMPORT_TABLE_01"
successfully completed at Thu Jun 19 21:27:28 2025 elapsed 0
00:06:21
[2025-06-19:20:55:57][tdb01p]<SYS@PTDB> archive log list;
Database log
mode
Archive Mode
Automatic
archival
Enabled
Archive
destination
+FRA1
Oldest online log sequence 301
Next log
sequence to archive 303
Current log
sequence
303
[2025-06-19:20:55:57][tdb01p]<SYS@PTDB> select name, value/1024/1024 mb from v$sysstat where name ='redo
size';
NAME
MB
-------------------- ----------
redo
size
18791.7608
1 row selected.
Elapsed:
00:00:00.06
-->
remap_table을 빼니 redo log가 확연하게 줄었음(14기가에서 18기가로 4기가
추가됨)
6. remap_table 및 remap_schema 옵션을 빼고 리두 로그가 최소화되도록 다시 import 시도
[2025-06-19:20:55:57][tdb01p]<SYS@PTDB> archive log list;
Database log
mode
Archive Mode
Automatic
archival
Enabled
Archive
destination
+FRA1
Oldest online log sequence 301
Next log
sequence to archive 303
Current log
sequence
303
[2025-06-19:20:55:57][tdb01p]<SYS@PTDB> select name, value/1024/1024 mb from v$sysstat where name ='redo
size';
NAME
MB
-------------------- ----------
redo
size
18794.852
1 row selected.
Elapsed: 00:00:00.01
--> remap_schema,
remap_table 모두 제거 시
[PTDB:oracle@tdb01p][/home/oracle/datapump]$ impdp tuner/oracle
dumpfile=TB_ORD_DTL.dmp logfile=import_TB_ORD_DTL.log directory=datapump
tables=TUNER.TB_ORD_DTL TRANSFORM=DISABLE_ARCHIVE_LOGGING:Y
Import: Release 12.2.0.1.0 - Production
on Thu Jun 19 21:33:12 2025
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
Connected
to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit
Production
Master table "TUNER"."SYS_IMPORT_TABLE_01" successfully
loaded/unloaded
Starting "TUNER"."SYS_IMPORT_TABLE_01": tuner/********
dumpfile=TB_ORD_DTL.dmp logfile=import_TB_ORD_DTL.log directory=datapump
tables=TUNER.TB_ORD_DTL TRANSFORM=DISABLE_ARCHIVE_LOGGING:Y
Processing object
type TABLE_EXPORT/TABLE/TABLE
Processing object type
TABLE_EXPORT/TABLE/TABLE_DATA
. . imported
"TUNER"."TB_ORD_DTL":"P_BEF_2020"."SYS_SUBP351" 0
KB 0 rows
. . imported
"TUNER"."TB_ORD_DTL":"P_BEF_2020"."SYS_SUBP352" 0
KB 0 rows
. . imported
"TUNER"."TB_ORD_DTL":"P_BEF_2020"."SYS_SUBP353" 0
KB 0 rows
. . imported
"TUNER"."TB_ORD_DTL":"P_BEF_2020"."SYS_SUBP354" 0
KB 0 rows
. . imported
"TUNER"."TB_ORD_DTL":"P_BEF_2020"."SYS_SUBP355" 0
KB 0 rows
. . imported
"TUNER"."TB_ORD_DTL":"P_BEF_2020"."SYS_SUBP356" 0
KB 0 rows
. . imported
"TUNER"."TB_ORD_DTL":"P_BEF_2020"."SYS_SUBP357" 0
KB 0 rows
. . imported
"TUNER"."TB_ORD_DTL":"P_BEF_2020"."SYS_SUBP358" 0
KB 0 rows
. . imported
"TUNER"."TB_ORD_DTL":"P2020"."SYS_SUBP359" 0
KB 0 rows
. . imported
"TUNER"."TB_ORD_DTL":"P2020"."SYS_SUBP360" 0
KB 0 rows
. . imported
"TUNER"."TB_ORD_DTL":"P2020"."SYS_SUBP361" 0
KB 0 rows
. . imported
"TUNER"."TB_ORD_DTL":"P2020"."SYS_SUBP362" 0
KB 0 rows
. . imported
"TUNER"."TB_ORD_DTL":"P2020"."SYS_SUBP363" 0
KB 0 rows
. . imported
"TUNER"."TB_ORD_DTL":"P2020"."SYS_SUBP364" 0
KB 0 rows
. . imported
"TUNER"."TB_ORD_DTL":"P2020"."SYS_SUBP365" 0
KB 0 rows
. . imported
"TUNER"."TB_ORD_DTL":"P2020"."SYS_SUBP366" 0
KB 0 rows
. . imported
"TUNER"."TB_ORD_DTL":"P2021"."SYS_SUBP367" 52.15 MB 628835 rows
.
. imported "TUNER"."TB_ORD_DTL":"P2021"."SYS_SUBP368" 51.30 MB
618500 rows
. . imported "TUNER"."TB_ORD_DTL":"P2021"."SYS_SUBP369"
51.56 MB 621700 rows
. . imported
"TUNER"."TB_ORD_DTL":"P2021"."SYS_SUBP370" 52.35 MB 631200 rows
.
. imported "TUNER"."TB_ORD_DTL":"P2021"."SYS_SUBP371" 52.21 MB
629550 rows
. . imported "TUNER"."TB_ORD_DTL":"P2021"."SYS_SUBP372"
52.11 MB 628370 rows
. . imported
"TUNER"."TB_ORD_DTL":"P2021"."SYS_SUBP373" 51.92 MB 626100 rows
.
. imported "TUNER"."TB_ORD_DTL":"P2021"."SYS_SUBP374" 51.32 MB
618745 rows
. . imported "TUNER"."TB_ORD_DTL":"P2022"."SYS_SUBP375"
52.06 MB 627765 rows
. . imported
"TUNER"."TB_ORD_DTL":"P2022"."SYS_SUBP376" 52.17 MB 629100 rows
.
. imported "TUNER"."TB_ORD_DTL":"P2022"."SYS_SUBP377" 51.60 MB
622200 rows
. . imported "TUNER"."TB_ORD_DTL":"P2022"."SYS_SUBP378"
51.45 MB 620350 rows
. . imported
"TUNER"."TB_ORD_DTL":"P2022"."SYS_SUBP379" 52.32 MB 630915 rows
.
. imported "TUNER"."TB_ORD_DTL":"P2022"."SYS_SUBP380" 51.57 MB
621780 rows
. . imported "TUNER"."TB_ORD_DTL":"P2022"."SYS_SUBP381"
51.91 MB 625900 rows
. . imported
"TUNER"."TB_ORD_DTL":"P2022"."SYS_SUBP382" 52.16 MB 629005 rows
.
. imported "TUNER"."TB_ORD_DTL":"P2023"."SYS_SUBP383" 51.42 MB
620000 rows
. . imported "TUNER"."TB_ORD_DTL":"P2023"."SYS_SUBP384"
51.20 MB 617350 rows
. . imported
"TUNER"."TB_ORD_DTL":"P2023"."SYS_SUBP385" 51.85 MB 625200 rows
.
. imported "TUNER"."TB_ORD_DTL":"P2023"."SYS_SUBP386" 51.72 MB
623650 rows
. . imported "TUNER"."TB_ORD_DTL":"P2023"."SYS_SUBP387"
51.16 MB 616885 rows
. . imported
"TUNER"."TB_ORD_DTL":"P2023"."SYS_SUBP388" 51.16 MB 616820 rows
.
. imported "TUNER"."TB_ORD_DTL":"P2023"."SYS_SUBP389" 51.66 MB
622955 rows
. . imported "TUNER"."TB_ORD_DTL":"P2023"."SYS_SUBP390"
51.49 MB 620850 rows
. . imported
"TUNER"."TB_ORD_DTL":"P2024"."SYS_SUBP391" 51.93 MB 626100 rows
.
. imported "TUNER"."TB_ORD_DTL":"P2024"."SYS_SUBP392" 52.72 MB
635700 rows
. . imported "TUNER"."TB_ORD_DTL":"P2024"."SYS_SUBP393"
51.83 MB 625000 rows
. . imported
"TUNER"."TB_ORD_DTL":"P2024"."SYS_SUBP394" 51.72 MB 623650 rows
.
. imported "TUNER"."TB_ORD_DTL":"P2024"."SYS_SUBP395" 52.09 MB
628100 rows
. . imported "TUNER"."TB_ORD_DTL":"P2024"."SYS_SUBP397"
52.67 MB 635095 rows
. . imported
"TUNER"."TB_ORD_DTL":"P2029"."SYS_SUBP436" 50.58 MB 609840 rows
.
. imported "TUNER"."TB_ORD_DTL":"P2029"."SYS_SUBP437" 51.69 MB
623250 rows
. . imported "TUNER"."TB_ORD_DTL":"P2029"."SYS_SUBP438"
52.20 MB 629400 rows
. . imported
"TUNER"."TB_ORD_DTL":"P2030"."SYS_SUBP439" 51.40 MB 619800 rows
.
. imported "TUNER"."TB_ORD_DTL":"P2030"."SYS_SUBP440" 51.76 MB
624200 rows
. . imported "TUNER"."TB_ORD_DTL":"P2030"."SYS_SUBP441"
52.19 MB 629350 rows
. . imported
"TUNER"."TB_ORD_DTL":"P2030"."SYS_SUBP442" 51.04 MB 615500 rows
.
. imported "TUNER"."TB_ORD_DTL":"P2030"."SYS_SUBP443" 51.32 MB
618800 rows
. . imported "TUNER"."TB_ORD_DTL":"P2030"."SYS_SUBP444"
51.88 MB 625530 rows
. . imported
"TUNER"."TB_ORD_DTL":"P2030"."SYS_SUBP445" 52.10 MB 628200 rows
.
. imported "TUNER"."TB_ORD_DTL":"P2030"."SYS_SUBP446" 51.30 MB
618600 rows
. . imported
"TUNER"."TB_ORD_DTL":"P_AFT_2030"."SYS_SUBP447" 0
KB 0 rows
. . imported
"TUNER"."TB_ORD_DTL":"P_AFT_2030"."SYS_SUBP448" 0
KB 0 rows
. . imported
"TUNER"."TB_ORD_DTL":"P_AFT_2030"."SYS_SUBP449" 0
KB 0 rows
. . imported
"TUNER"."TB_ORD_DTL":"P_AFT_2030"."SYS_SUBP450" 0
KB 0 rows
. . imported
"TUNER"."TB_ORD_DTL":"P_AFT_2030"."SYS_SUBP451" 0
KB 0 rows
. . imported
"TUNER"."TB_ORD_DTL":"P_AFT_2030"."SYS_SUBP452" 0
KB 0 rows
. . imported
"TUNER"."TB_ORD_DTL":"P_AFT_2030"."SYS_SUBP453" 0
KB 0 rows
. . imported
"TUNER"."TB_ORD_DTL":"P_AFT_2030"."SYS_SUBP454" 0
KB 0 rows
. . imported
"TUNER"."TB_ORD_DTL":"P2024"."SYS_SUBP398" 52.03 MB 627350 rows
.
. imported "TUNER"."TB_ORD_DTL":"P2025"."SYS_SUBP399" 51.09 MB
615985 rows
. . imported "TUNER"."TB_ORD_DTL":"P2025"."SYS_SUBP400"
52.29 MB 630500 rows
. . imported
"TUNER"."TB_ORD_DTL":"P2025"."SYS_SUBP401" 51.94 MB 626300 rows
.
. imported "TUNER"."TB_ORD_DTL":"P2025"."SYS_SUBP402" 52.46 MB
632600 rows
. . imported "TUNER"."TB_ORD_DTL":"P2025"."SYS_SUBP403"
51.62 MB 622450 rows
. . imported
"TUNER"."TB_ORD_DTL":"P2025"."SYS_SUBP404" 51.34 MB 619110 rows
.
. imported "TUNER"."TB_ORD_DTL":"P2025"."SYS_SUBP405" 52.19 MB
629300 rows
. . imported "TUNER"."TB_ORD_DTL":"P2025"."SYS_SUBP406"
52.64 MB 634750 rows
. . imported
"TUNER"."TB_ORD_DTL":"P2026"."SYS_SUBP407" 51.92 MB 626065 rows
.
. imported "TUNER"."TB_ORD_DTL":"P2026"."SYS_SUBP408" 51.43 MB
620150 rows
. . imported "TUNER"."TB_ORD_DTL":"P2026"."SYS_SUBP409"
51.85 MB 625280 rows
. . imported
"TUNER"."TB_ORD_DTL":"P2026"."SYS_SUBP410" 51.72 MB 623650 rows
.
. imported "TUNER"."TB_ORD_DTL":"P2026"."SYS_SUBP411" 51.25 MB
617950 rows
. . imported "TUNER"."TB_ORD_DTL":"P2026"."SYS_SUBP412"
51.67 MB 623050 rows
. . imported
"TUNER"."TB_ORD_DTL":"P2026"."SYS_SUBP413" 52.21 MB 629600 rows
.
. imported "TUNER"."TB_ORD_DTL":"P2026"."SYS_SUBP414" 52.74 MB
635950 rows
. . imported "TUNER"."TB_ORD_DTL":"P2027"."SYS_SUBP416"
50.97 MB 614600 rows
. . imported
"TUNER"."TB_ORD_DTL":"P2027"."SYS_SUBP417" 51.92 MB 626075 rows
.
. imported "TUNER"."TB_ORD_DTL":"P2027"."SYS_SUBP418" 51.75 MB
624000 rows
. . imported "TUNER"."TB_ORD_DTL":"P2027"."SYS_SUBP419"
52.09 MB 628100 rows
. . imported
"TUNER"."TB_ORD_DTL":"P2027"."SYS_SUBP420" 51.87 MB 625400 rows
.
. imported "TUNER"."TB_ORD_DTL":"P2027"."SYS_SUBP421" 51.62 MB
622450 rows
. . imported "TUNER"."TB_ORD_DTL":"P2027"."SYS_SUBP422"
51.48 MB 620800 rows
. . imported
"TUNER"."TB_ORD_DTL":"P2028"."SYS_SUBP423" 52.35 MB 631250 rows
.
. imported "TUNER"."TB_ORD_DTL":"P2028"."SYS_SUBP424" 52.94 MB
638450 rows
. . imported "TUNER"."TB_ORD_DTL":"P2028"."SYS_SUBP425"
51.56 MB 621695 rows
. . imported
"TUNER"."TB_ORD_DTL":"P2028"."SYS_SUBP426" 52.53 MB 633450 rows
.
. imported "TUNER"."TB_ORD_DTL":"P2028"."SYS_SUBP427" 52.71 MB
635700 rows
. . imported "TUNER"."TB_ORD_DTL":"P2028"."SYS_SUBP428"
52.37 MB 631480 rows
. . imported
"TUNER"."TB_ORD_DTL":"P2028"."SYS_SUBP429" 51.68 MB 623150 rows
.
. imported "TUNER"."TB_ORD_DTL":"P2028"."SYS_SUBP430" 52.32 MB
630950 rows
. . imported "TUNER"."TB_ORD_DTL":"P2029"."SYS_SUBP431"
51.39 MB 619650 rows
. . imported
"TUNER"."TB_ORD_DTL":"P2029"."SYS_SUBP432" 50.85 MB 613150 rows
.
. imported "TUNER"."TB_ORD_DTL":"P2029"."SYS_SUBP433" 51.96 MB
626550 rows
. . imported "TUNER"."TB_ORD_DTL":"P2029"."SYS_SUBP435"
51.70 MB 623450 rows
. . imported
"TUNER"."TB_ORD_DTL":"P2024"."SYS_SUBP396" 52.20 MB 629370 rows
.
. imported "TUNER"."TB_ORD_DTL":"P2027"."SYS_SUBP415" 51.49 MB
620850 rows
. . imported "TUNER"."TB_ORD_DTL":"P2029"."SYS_SUBP434"
52.21 MB 629550 rows
Processing object type
TABLE_EXPORT/TABLE/COMMENT
Processing object type
TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type
TABLE_EXPORT/TABLE/INDEX/FUNCTIONAL_INDEX/INDEX
Processing object type
TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type
TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type
TABLE_EXPORT/TABLE/INDEX/STATISTICS/FUNCTIONAL_INDEX/INDEX_STATISTICS
Processing
object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object
type TABLE_EXPORT/TABLE/STATISTICS/MARKER
Job "TUNER"."SYS_IMPORT_TABLE_01"
successfully completed at Thu Jun 19 21:39:29 2025 elapsed 0
00:06:17
[2025-06-19:20:55:57][tdb01p]<SYS@PTDB> archive log list;
Database log
mode
Archive Mode
Automatic
archival
Enabled
Archive
destination
+FRA1
Oldest online log sequence 325
Next log
sequence to archive 327
Current log
sequence
327
[2025-06-19:20:55:57][tdb01p]<SYS@PTDB> select name, value/1024/1024 mb from v$sysstat where name ='redo
size';
NAME
MB
-------------------- ----------
redo
size
23200.9938
1 row selected.
Elapsed:
00:00:00.01
--> 마찬가지로
REDO LOG가 확연하게 줄었음 (결국 remap_table 옵션만 빼는게 효과가 있음을
확인!)
결론 : 해당 옵션을 쓰면 REDO LOG가 확연하게 줄어듦, 단,
REMAP_TABLE 옵션 사용 시 동작하지 않음 (버그임) 패치해야함
To fix the issue until an upgrade to 23.1 is possible,
apply Patch 29792959, if available for your version and
platform.
--추가적으로
알아두면 좋은 옵션
--테이블만 REDO LOG 생성 최소화
TRANSFORM=DISABLE_ARCHIVE_LOGGING:Y:TABLE
--인덱스만 REDO LOG 생성 최소화
TRANSFORM=DISABLE_ARCHIVE_LOGGING:Y:INDEX