#!/bin/bash
source ~/.bash_profile
export ORACLE_BASE=/oracle/app
export ORACLE_HOME=/oracle/app/product/19C/db_home
export ORACLE_SID=orcl
export PATH=$ORACLE_HOME/bin:$PATH
days=$(date '+%Y%m%d')
#echo $days
expdp test/12345678 directory=dumpdir dumpfile=test_$days.dmp logfile=test_$days.log schemas=orcl compression=ALL
cd /usr/local/backup
tar -zcvf test_$days.tar.gz test_$days.dmp test_$days.log
Linux中Oracle数据库备份脚本
最新推荐文章于 2024-07-04 09:51:18 发布