How to migrate oracle from physical server to virtual server (VM) using expdp/impdp

You can migrate from server to other server too using this tutorial. 

1. create TNS on the new server, locate in dir $ORACLE_HOME/network/admin 

2. open firewall host 

3. create DBCA, locate in dir $ORACLE_HOME/assistants/dbca/ with name dbcaICNPRODB.rsp. 

4. create tablespace

5. export database, make sure you have directories oracle for location export file

and then follow this command 

expdp username/password@your_database reuse_dumpfiles=y schemas=your_schema dumpfile=expdp_yourchema.dmp directory=EXPDP_BKP_ICNPRODB logfile=expdp_your_schema.log

you will see the export progress 

then transfer export file to destination server with this command

scp expdp_your_schema.dmp oracle@your_ip_destination:/home/oracle

6. import database *login into destination server

import database with this command 

impdp user/pass directory=DATA_PUMP_DIR dumpfile=expdp_your_schema.dmp logfile=expdp_log_5102019.log

the import progress is running, wait until success


Posting Komentar

Lebih baru Lebih lama