Shell脚本备份恢复Oracle数据库简单示例
Jun 07, 2016 pm 05:07 PMexp_p.sh #!/bin/sh #$1生成dmp文件保存路径 if [ -d $1 ]; then echo $1 exist #用户名/密码 生成文件名称根据当天
exp_p.sh
#!/bin/sh
#$1生成dmp文件保存路径
if [ -d "$1" ]; then
echo ""$1" exist "
#用户名/密码 生成文件名称根据当天日期自动生成,,例如20111128.dmp
exp test/test file="$1/`date + %Y%m%d`.dmp"
else
#如果制定的文件保存路径不存在则创建文件夹后在导出数据
mkdir -p "$1"
exp test/test file="$1/`date + %Y%m%d`.dmp"
fi
chmod +x exp_p.sh
./exp_p.sh /home/Oracle/bak
imp_p.sh
#!/bin/sh
#$1导入的dmp文件,例如/home/oracle/bak/20111128.dmp
if [ -f "$1" ]; then
echo ""$1" exist"
#导入目标数据库的用户名/密码, fromuser源数据库用户
imp test/test file="$1" fromuser=test1
else
echo "ERROR:"$1" does not exist"
fi

Hot Article

Hot tools Tags

Hot Article

Hot Article Tags

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

How to check which table space a table belongs to in Oracle

How to connect to Oracle database using PDO

How to retrieve only one piece of duplicate data in oracle

Implement data import into PHP and Oracle databases

How oracle determines whether a table exists in a stored procedure

How to use PHP and Oracle database connection pools efficiently

How to use php to extend PDO to connect to Oracle database
