Scenario:
Suppose we want to restore backup into destination database server (192.168.10.6) and backup resides in source database server (192.168.10.32)
Solution:
Step1: We need to keep the backup dump file into source database server (192.168.10.32)
Step2: We need to create a database link into source database server (192.168.10.32)
CREATE PUBLIC DATABASE LINK DPUMP
CONNECT TO SYSTEM
IDENTIFIED BY
USING '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.6)(PORT=1521))(CONNECT_DATA=(SID=orcl)))';
Step3: Now we need to create a directory where database backup will reside
DROP DIRECTORY data_dump;
CREATE OR REPLACE DIRECTORY data_dump AS '/back/exp/';
GRANT EXECUTE, READ, WRITE ON DIRECTORY SYS.data_dump TO SYSTEM WITH GRANT OPTION;
Step4: Now we need to execute import (impdp) command from source database server (192.168.10.32) to restore
backup into destination database server (192.168.10.6)
Step5: Put the schemas value which schema you want to import
impdp system/sys123 schemas=scott,hr,test network_link=DPUMP directory=data_dump dumpfile=orcl_full.dmp logfile=orcl_full.log
Step6: Now the data values that you want to import..
Cheers.....
