How to minimize performance issues and downtime migrating 8TB data from 10.2.0.4 using expdp
(Primary 10.2.0.4):Dell PowerEdge R720 (Physical)
(Standby 10.2.0.4):Dell PowerEdge R720 (Physical)
Replication using DBVisit
RAM: 32GB
CPU: 2 Quad Cores (8 CPUs)
Storage: 10TB
RAID-10
O/S RH Linux 6.3 (Santiago)
Standalone installation with Non-ASM
===================================================
Tablespace Size (MB) Free (MB) % Free % Used
------------------------------ ---------- ---------- ---------- ----------
USERS 680 9.38 1 99
AWUNADM 7853468.73 3115.06 0 100
AWADM 76484.05 2.88 0 100
SYSAUX 630 30.75 5 95
SYSTEM 610 4.38 1 99
UNDOTBS1 32765 32670.75 100 0
TEMP 1024 0 200 300
=============================================== ======================
expdp datapumpuser/pw DIRECTORY=Oracle_DP_DIR LOGFILE=expdp_asyw_10g.log PARALLEL=2 DUMPFILE=dp10g%U.dy FILESIZE=32G SCHEMAS=awunadmtrain,awadmtrain
=====================================================================
Hello Oracle Gurus:
I am asking for your help and advice with the following data migration problem.
I am providing technical support for the Government of Belize - Customs Dept with the upgrade and migration of ASYCUDA World application and data from 10.2.0.4 to 12.2.0.1 on RH Linux 64-Bit platform.