Shell :EXPORTING DATA FROM REMOTE DATABASE USING NETWORK_LINK

SHELL : EXPORTING  DATA FROM REMOTE DATABASE USING NETWORK_LINK

In this article , we will  how to automate the script for  export data from remote database and import in source database.

Check below link for previous article on same topic.

HOW TO EXPORT DATA FROM REMOTE DATABASE USING DATAPUMP.

Source Database :

iP address : 192.168.0.51

Instance Name : primary

Remote Database : 

iP address : 192.168.0.61

Instance Name : orcl

Steps to implement :

1.Networking b/w hosts (Both Source and Remote servers should ping each other)

2.Create & start listener.ora  in Remote server.

3.create  tnsnames.ora in Source server .

4.In source database choose one user and create database link.

5.check database link by selecting data

6.In Source database create par files which performs export and import  and create script.

7.execute the script

Now implement above steps :

Step 1 :

Networking b/w hosts (Both Source and Remote servers should ping each other)

Remote Server :

Step 2 :

Create & start listener.ora  in Remote server.

Start listener

Source Server :

Step 3 :

create  tnsnames.ora in Source server .

Step 4 :

In source database choose one user and create database link.

Create database link

Step 5 :

Selecting  the data using database link

Yes , The data is selecting through dblink from remote database.

Step 6 :

Now perform export operation by creating PAR file.

Create PAR file

EXPORT : 

IMPORT :

Step 7 :

The below script will perform export from target and import to Source database .

OUTPUT :

Check the output of Log file .

Note :

If you configured mail services then same output will come through mail.

 

Note: Please test scripts in Non Prod before trying in Production.
1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...

Add Comment