PDB导出导入

#检查当前目录
set linesize 100;
col DIRECTORY_NAME for a20;
col OWNER for a10;
col DIRECTORY_PATH for a50;
select * from dba_directories where DIRECTORY_NAME='DIR_DUMP';

#pdb导出

alter session set container=SINGLE04;
create or replace directory dir_dump as '/backup/expdp0902/single04';

expdp  system@single04  directory=dir_dump dumpfile=u_ecmpbase_202209_%U.dump parallel=4 logfile=u_ecmpbase_202209.log full=y

vi ecmpbase_expdp.sh
#!/bin/bash
export ORACLE_BASE=/u01/app/oracle/
export ORACLE_HOME=/u01/app/oracle/product/19.0.0.0/db_1
export PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_PDB_SID=
expdp  \"/ as sysdba\"  directory=dir_dump dumpfile=u_ecmpbase_202209_%U.dump parallel=4 logfile=u_ecmpbase_202209.log full=y  CLUSTER=n

chmod +x ecmpbase_expdp.sh
nohup sh ecmpbase_expdp.sh &

#pdb导入

vi pdb_impdp.sh
#!/bin/bash
export ORACLE_BASE=/u01/app/oracle/
export ORACLE_HOME=/u01/app/oracle/product/19c/db_1
export PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_PDB_SID=PDB1
expdp  \"/ as sysdba\"  directory=dir_dump dumpfile=u_PDB1_202209_%U.dump parallel=4 logfile=u_impdp_PDB1_202209.log remap_schema=test1:test2  

chmod +x pdb_impdp.sh
nohup sh pdb_impdp.sh &