通过DB LINK EXPDP

1、create directory

create directory backupdb as 'datadump';

select * from dba_directories;

OWNER      DIRECTORY_NAME    DIRECTORY_PATH

SYS        BACKUPDB          /datadump

2、CREATE DBLINKS

CREATE PUBLIC DATABASE LINK OGG_DP

CONNECT TO RQS

IDENTIFIED BY <PASSWORD>

USING '(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.1.1)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.1.2)(PORT = 1521))(LOAD_BALANCE = yes)(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = testdb)))';

3、edit parfile

cat 20191227.par

network_link=ogg_dp

directory=BACKUPDB

dumpfile=20191227_%U.dmp

logfile=20191227.log

parallel=2

COMPRESSION=all

CLUSTER=n

tables=(

AAAAA.BBBB:SYS_P111111,

AAAAA.BBBB:SYS_P222222,

AAAAA.BBBB:SYS_P333333)

4、expdp

expdp userid=\'sys/xxx as sysdba\' parfile=20191227.par

5、backup to tsm

dsmc backup /datadump/20191227.*

dsmc query backup "/datadump/20191227.*"

©著作权归作者所有,转载或内容合作请联系作者
平台声明：文章内容（如有图片或视频亦包括在内）由作者上传并发布，文章内容仅代表作者本人观点，简书系信息发布平台，仅提供信息存储服务。

推荐阅读更多精彩内容