oracle12c 导出

导出命令：
expdp "/as sysdba" schemas=ST_SYC directory=dump_dir dumpfile=carddb_ST_SYC_2023-1-30.dmp logfile=carddb_ST_SYC_2023-1-30.log

sqlplus / as sysdba

Create user backup01 identified by 123456;
Grant create session to backup01;
Grant dba to backup01;

create directory dpdata1 as ‘/home/oracle/oradb’;
conn sys/sys as sysdba
grant read,write on directory dpdata1 to backup01;
quit

测试
expdp backup01/123456@orcl dumpfile=223.dmp logfile=carddb.log directory=dpdata1 full=y

脚本
#!/bin/bash
dat=date +%Y-%m-%d
bak_dir="/u01/app/oracle/oradata/dumpfile"
expdp "/as sysdba" directory=dump_dir dumpfile=carddb_{dat}.log full=y
cd {dat}.tar.gz carddb_{dat}.log
rm -rf carddb_{dat}.log
scp -i /home/oracle/.ssh/id_rsa carddb_dbbackup_{dat}.tar.gz