CentOS
昨天弄oracle的备份，脚本中用到了scp，需要把服务器的数据cp到备份服务器上，需要配置oracle数据库服务器可以通过db_backup用户无密码登陆到备份服务器上，随便把ssh无密码登陆的配置步骤记下来了，下面是具体工程：
环境：
oracle数据库服务器：10.20.220.247
备份服务器：10.20.220.25
备份用户：db_backup
步骤：
1.在10.20.220.25上新建db_backup用户，指定家目录为/data/backup并设置密码
[root@localhost ~]# useradd db_backup -d /data/backup
[root@localhost ~]# passwd db_backup
Changing password for user db_backup.
New UNIX password:
Retype new UNIX password:
passwd: all authentication tokens updated successfully.
2.确认sshd的配置文件的认证模块已打开
vi /etc/ssh/sshd_config
#RSAAuthentication yes
#PubkeyAuthentication yes
#AuthorizedKeysFile .ssh/authorized_keys
把上面三行的注释去掉
重启ssh服务
3.在10.20.220.247上
A.#ssh-keygen -t dsa -P '' -f ~/.ssh/id_dsa
Generating public/private dsa key pair.
Your identification has been saved in /root/.ssh/id_dsa.
Your public key has been saved in /root/.ssh/id_dsa.pub.
The key fingerprint is:
a4:a2:8e:58:e5:d3:38:92:00:c4:bf:a5:f9:67:af:ed root@localhost.localdomain
B.#cd .ssh/
#mv id_dsa.pub authorized_keys
#chmod 600 authorized_keys
4.在10.20.220.25上以db_backup登陆执行ssh-keygen -t dsa -P '' -f ~/.ssh/id_dsa
[db_backup@localhost ~]$ ssh-keygen -t dsa -P '' -f ~/.ssh/id_dsa
Generating public/private dsa key pair.
Created directory '/data/backup/.ssh'.
Your identification has been saved in /data/backup/.ssh/id_dsa.
Your public key has been saved in /data/backup/.ssh/id_dsa.pub.
The key fingerprint is:
13:03:fd:46:2a:70:1d:a8:01:33:7b:c6:00:59:d2:a9 db_backup@localhost
5.在10.20.220.247上执行
scp -p authorized_keys db_backup@10.20.220.25:~/.ssh/authorized_keys
把db_backup的公钥拷贝到备份服务器上
6.测试
[root@localhost ~]# ssh db_backup@10.20.220.25
Last login: Mon Apr 2 03:14:34 2012 from 10.20.220.247
[db_backup@localhost ~]$ pwd
/data/backup
ok，成功了，
现在把的备份oracle脚本和备份文件的脚本加到crontab，每天晚1点二十上执行备份
[root@localhost ~]# crontab -e
20 1 * * * /data/SoftMgr_backup/db_bak.sh >/dev/null
20 1 * * * /data/SoftMgr_backup/file_bak.sh >/dev/null
oracle备份脚本内容：
[root@localhost SoftMgr_backup]# cat db_bak.sh
a=`date "+%Y_%m%d_%H%M"`
echo 'begin wcm database backup'
dmp_file=/data/SoftMgr_backup/db_back/$a.dmp
log_file=/data/SoftMgr_backup/db_back/$a.log
echo $dmp_file
echo $log_file
su - oracle -c "exp smdatadba/wpswps@smdata owner=smdatadba file=$dmp_file log=$log_file"
echo 'databse backup success,begin tar file'
cd /data/SoftMgr_backup/db_back
tar zcfP $a.dmp.tar.gz $a.dmp
tar zcfP $a.log.tar.gz $a.log
echo 'begin databse backup success,begin upload file to 10.20.220.25 /data/backup'
scp $a.dmp.tar.gz db_backup@10.20.220.25:~
scp $a.log.tar.gz db_backup@10.20.220.25:~
echo 'scp file end'
echo 'begin delete local file'
cd /data/SoftMgr_backup/db_back
pwd
rm -rf $a.dmp
rm -rf $a.log
rm -rf $a.dmp.tar.gz
rm -rf $a.log.tar.gz
echo 'operate end.'
#END
转载于:
CentOS
昨天弄oracle的备份，脚本中用到了scp，需要把服务器的数据cp到备份服务器上，需要配置oracle数据库服务器可以通过db_backup用户无密码登陆到备份服务器上，随便把ssh无密码登陆的配置步骤记下来了，下面是具体工程：
环境：
oracle数据库服务器：10.20.220.247
备份服务器：10.20.220.25
备份用户：db_backup
步骤：
1.在10.20.220.25上新建db_backup用户，指定家目录为/data/backup并设置密码
[root@localhost ~]# useradd db_backup -d /data/backup
[root@localhost ~]# passwd db_backup
Changing password for user db_backup.
New UNIX password:
Retype new UNIX password:
passwd: all authentication tokens updated successfully.
2.确认sshd的配置文件的认证模块已打开
vi /etc/ssh/sshd_config
#RSAAuthentication yes
#PubkeyAuthentication yes
#AuthorizedKeysFile .ssh/authorized_keys
把上面三行的注释去掉
重启ssh服务
3.在10.20.220.247上
A.#ssh-keygen -t dsa -P '' -f ~/.ssh/id_dsa
Generating public/private dsa key pair.
Your identification has been saved in /root/.ssh/id_dsa.
Your public key has been saved in /root/.ssh/id_dsa.pub.
The key fingerprint is:
a4:a2:8e:58:e5:d3:38:92:00:c4:bf:a5:f9:67:af:ed root@localhost.localdomain
B.#cd .ssh/
#mv id_dsa.pub authorized_keys
#chmod 600 authorized_keys
4.在10.20.220.25上以db_backup登陆执行ssh-keygen -t dsa -P '' -f ~/.ssh/id_dsa
[db_backup@localhost ~]$ ssh-keygen -t dsa -P '' -f ~/.ssh/id_dsa
Generating public/private dsa key pair.
Created directory '/data/backup/.ssh'.
Your identification has been saved in /data/backup/.ssh/id_dsa.
Your public key has been saved in /data/backup/.ssh/id_dsa.pub.
The key fingerprint is:
13:03:fd:46:2a:70:1d:a8:01:33:7b:c6:00:59:d2:a9 db_backup@localhost
5.在10.20.220.247上执行
scp -p authorized_keys db_backup@10.20.220.25:~/.ssh/authorized_keys
把db_backup的公钥拷贝到备份服务器上
6.测试
[root@localhost ~]# ssh db_backup@10.20.220.25
Last login: Mon Apr 2 03:14:34 2012 from 10.20.220.247
[db_backup@localhost ~]$ pwd
/data/backup
ok，成功了，
现在把的备份oracle脚本和备份文件的脚本加到crontab，每天晚1点二十上执行备份
[root@localhost ~]# crontab -e
20 1 * * * /data/SoftMgr_backup/db_bak.sh >/dev/null
20 1 * * * /data/SoftMgr_backup/file_bak.sh >/dev/null
oracle备份脚本内容：
[root@localhost SoftMgr_backup]# cat db_bak.sh
a=`date "+%Y_%m%d_%H%M"`
echo 'begin wcm database backup'
dmp_file=/data/SoftMgr_backup/db_back/$a.dmp
log_file=/data/SoftMgr_backup/db_back/$a.log
echo $dmp_file
echo $log_file
su - oracle -c "exp smdatadba/wpswps@smdata owner=smdatadba file=$dmp_file log=$log_file"
echo 'databse backup success,begin tar file'
cd /data/SoftMgr_backup/db_back
tar zcfP $a.dmp.tar.gz $a.dmp
tar zcfP $a.log.tar.gz $a.log
echo 'begin databse backup success,begin upload file to 10.20.220.25 /data/backup'
scp $a.dmp.tar.gz db_backup@10.20.220.25:~
scp $a.log.tar.gz db_backup@10.20.220.25:~
echo 'scp file end'
echo 'begin delete local file'
cd /data/SoftMgr_backup/db_back
pwd
rm -rf $a.dmp
rm -rf $a.log
rm -rf $a.dmp.tar.gz
rm -rf $a.log.tar.gz
echo 'operate end.'
#END
转载于:
发布评论