How to Backup the Remote Database Using Data Pump

Oracle10g

Add the remote database entry inside the local tnsnames.ora

Check the Remote Database using  tnsping remote_orcl

Both the local and remote users require the EXP_FULL_DATABASE role granted to them

Create the Database Link inside the localuser
CREATE DATABASE LINK remote_orcl CONNECT TO scott IDENTIFIED BY tiger USING 'remote_orcl';

$ expdp userid=localuser/localuser@orcl tables=scott.EMP network_link=remote_orcl directory=DB_DUMP dumpfile=exp_emp_080512.dmp logfile=log_emp_080512.log

Export: Release 10.2.0.1.0 – Production on Tuesday, 08 May, 2012 18:40:44

Copyright (c) 2003, 2005, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 – Production
With the Partitioning, OLAP and Data Mining options
Starting “localuser”.”SYS_EXPORT_TABLE_01″: userid=aaastats/********@orcl tables=scott.emp network_link=remote_orcl directory=DB_DUMP dumpfile=exp_emp_080512.dmp logfile=log_emp_080512.log
Estimate in progress using BLOCKS method…
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 12.34 GB
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
. . exported “SCOTT”.”EMP” 6.671 GB 41239928 rows
Master table “localuser”.”SYS_EXPORT_TABLE_01″ successfully loaded/unloaded
******************************************************************************
Dump file set for localuser.SYS_EXPORT_TABLE_01 is:
/home/oracle/exp_emp_080512.dmp
Job “localuser”.”SYS_EXPORT_TABLE_01″ successfully completed at 18:50:46

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s