#检查当前目录
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 &
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)