rman多进程并发备份一个数据表空间脚本

最新推荐文章于 2021-04-15 06:20:39 发布

原创

最新推荐文章于 2021-04-15 06:20:39 发布 · 1.6k 阅读

0 ·

CC 4.0 BY-SA版权

#!/bin/bash
export LANG=en_US
export ORACLE_HOME=/u01/app/product/10.2.0/db_1
export RMAN=$ORACLE_HOME/bin/rman
export ORACLE_SID=dbs1
export ORACLE_USER=oracle
export DAY=`date +%Y%m%d`  
export WEEKS=`date +%U`
export BACKUP_DIR=/u01/rman


export RMAN_LOG_FILE=$BACKUP_DIR/rman_"$ORACLE_SID"_$DAY.log

TODAY=`date`
USER=`id|cut -d "(" -f2|cut -d ")" -f1`
echo "=================$TODAY===================">$RMAN_LOG_FILE

echo "ORACLE_SID:  $ORACLE_SID">>$RMAN_LOG_FILE
echo "ORACLE_HOME: $ORACLE_HOME">>$RMAN_LOG_FILE
echo "ORACLE_USER: $ORACLE_USER">>$RMAN_LOG_FILE
echo "================================================================">>$RMAN_LOG_FILE
echo "                   ">>$RMAN_LOG_FILE
echo "BACKUP DATABASE BEGIN......">>$RMAN_LOG_FILE
echo "                   ">>$RMAN_LOG_FILE

chmod 666 $RMAN_LOG_FILE

BAK_LEVEL=0													       
#export BAK_LEVEL=$BAK_LEVEL
echo "Today is : `date +%A` incremental