恢复--系统配置表的shell

文章由LinuxBoy分享于2019-03-24 07:03:19热评（386）

恢复--系统配置表的shell

配置用户名密码文件report.ini

user1/pswd1@dbname1

user2/pswd2@dbname2

配置系统表文件configtable.ini

user1.table1

user2.table2

user3.table3

脚本backup.sh

一次读取配置文件，并做验证，如果密码错误则进行修改，将每个用户的配置表进行导入

备份文件包的名称由用户输入

#!/usr/bin/ksh

dmpfilepath='./'

connfile=report.ini

configtable=configtable.ini

DT=$1

while [ ! -r ${dmpfilepath}${DT}.*.dmp ]

if [ -n "$DT" ]

then

ll -rt ${dmpfilepath}*.dmp | tail -20

echo "Please input dmp's basename:\c"

read DT

done

#检查连接串正确性

checkconn()

{

if [ "$#" -ne 1 ]

then

echo "-1"

exit

VALUE=`sqlplus -s /nolog <<EOF

set head off

conn $dbconn

select 1 from dual;

exit

EOF`

echo $VALUE

}

#将密码写入配置文件

modipswd()

{

if [ "$#" -ne 2 ]

then

echo "-1"

exit

user=`echo $1 | cut -d/ -f1`

dbnm=`echo $1 | cut -d@ -f2`

newconn=`echo $dbconn | sed 's/\//\\\\\//g`

cat $2 | sed "/^$user\/.*@$dbnm/s/^.*$/$newconn/g" >temp$$

mv temp$$ $connfile

}

#读取配置文件

for dbuser in `cat $configtable | sed -e "s/^ *//g" -e "s/\..*//g" | sort | uniq `

v_time=0

dbconn=`cat $connfile | grep "^ *$dbuser/"`

checkconn_flg=$(checkconn $dbconn)

while [ "$checkconn_flg" != "1" -a $v_time -lt 3 ]

v_time=`expr $v_time + 1`

stty -echo

echo $dbuser'@'`echo $dbconn | cut -d@ -f2` password is error," please input new password:\c"

read newpswd

echo ''

dbconn=$dbuser'/'$newpswd'@'`echo $dbconn | cut -d@ -f2`

stty echo

checkconn_flg=$(checkconn $dbconn)

if [ "$checkconn_flg" = "1" ]

then

modipswd $dbconn $connfile

break

done

alltab=''

#读取配置表

cat $configtable | grep "^ *$dbuser." |

while read dbtab

alltab=$alltab,`echo $dbtab | cut -d. -f2`

VALUE=`sqlplus -s /nolog <<EOF

set head off

conn $dbconn

truncate table $dbtab;

exit

EOF`

done

alltab=`echo $alltab | cut -c2-`

if [ -n "$alltab" ]

then

echo :$alltab:

imp $dbconn file=${dmpfilepath}${DT}.$dbuser.dmp ignore=y

done

推荐文章：

恢复--系统配置表的shell