#!/bin/bash
#define variable
BASE_DIR=/home/user1/dbbak
CURRENT_DATE=`date +%Y%m%d`
DEST_DIR=dbbak-$CURRENT_DATE
FULL_DEST_DIR=$BASE_DIR/$DEST_DIR
ORACLE_BIN=/opt/oracle/product/10.2/db/bin
#set env variable
export NLS_LANG='SIMPLIFIED CHINESE_CHINA.AL32UTF8'
#create dir
cd $BASE_DIR
mkdir $DEST_DIR
#export data
cd $ORACLE_BIN
./exp ora1/ora1pwd@orcl file=$FULL_DEST_DIR/dbbak-$CURRENT_DATE.dmp
#compress
cd $BASE_DIR
zip -r $DEST_DIR.zip $DEST_DIR
Oracle备份脚本
最新推荐文章于 2024-02-06 14:21:59 发布