Oracle通过dblink数据泵异地备份

mahan

Part1环境
源库        目的库
服务器IP        192.168.25.211        192.168.25.201
服务器版本        CentOS 7.9        CentOS 7.9
数据库版本        Ora11G 单机        Ora11G 集群
备份路径        /u01/211_backup/        /u01/201_backup/
Part2操作
要求：在目的库操作，导出源库的数据库用户

目的库

su - oracle

cd $ORACLE_HOME

#添加源库的Tns信息
vim tnsnames.ora

YK_ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.25.211)(PORT = 1522))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

#保存退出
:wq

#尝试联通源库
tnsping YK_ORCL

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.25.211)(PORT = 1522)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))
OK (0 msec)
源库操作,模拟要被导出的用户

SQL> create user yk identified by yk_mm;
SQL> grant connect,resource to yk;
SQL> grant exp_full_database to yk;
创建源库要导出的两个表,源库没有这两个表

SQL> create table tt (id number,name varchar2(10));

SQL> create table hbb  (id number,name varchar2(10));
尝试在目的库远程登录源库

#具体信息的方式
sqlplus yk/yk_mm@192.168.25.211:1522/orcl

#tns登陆的方式
sqlplus yk/yk_mm@YK_ORCL

#查询源库的表
select TABLE_NAME from user_tables;

TABLE_NAME
------------------------------
TT
HBB
目的库操作创建dblink

##创建DBLINK的两种方式
SQL> create public database link mdk_link connect to yk  identified by yk_mm using 'YK_ORCL';

或者

SQL> create public database link mdk_link connect to yk  identified by yk_mm using '192.168.25.211:1522/orcl';
目的库创建用户和赋权

##创建在目的库操作的用户
SQL> create user mdk identified by mdk_mm;
SQL> grant connect,resource to mdk;
SQL> grant exp_full_database to mdk;
目的库操作创建逻辑路径

##注意创建的逻辑路径是在目的库必须存在的
SQL> create or replace directory expdp_dir as '/u01/201_backup/';

SQL> grant read,write on directory expdp_dir to mdk;

SQL> grant exp_full_database to mdk;
目的库操作导出

expdp mdk/mdk_mm directory=expdp_dir schemas=yk dumpfile=yk_20250822.dmp logfile=yk_20250822.log network_link='mdk_link' cluster=n;