Database Utilities (MOSC)

MOSC Banner

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center