oracle备份的服务器上,备份oracle并传输备份到windows服务器上

应客户的二逼需求，好好的ASM磁盘不放非要放到windows服务器的磁盘上，也是醉了。

首先需要在windows服务器上安装ftp server软件，我们这里用了FileZilla Server 。

配置好ftp服务器之后就开始写备份脚本吧

备份脚本如下：

#!/bin/sh

. /home/oracle/.bash_profile

bakdir=/home/oracle/bak/

Bak_Server_IP=192.168.56.2

ftpuname=oracle

ftppwd=oracle

remotedir=/

localdir=${bakdir}

rman target / >${bakdir}autorman.log<

configure channel device type disk rate 50m; #限速为多少根据具体情况决定

CONFIGURE RETENTION POLICY TO REDUNDANCY 1;

BACKUP AS COMPRESSED BACKUPSET DATABASE FORMAT '${bakdir}%d_%T_%U.bak';

delete obsolete;

YES

configure channel device type disk clear;

CONFIGURE RETENTION POLICY CLEAR;

EOF

starttime=`date +%y-%m-%d-%T`

echo "..................FTP Delete And Translate to $BAK_SERVER_IP...................." >${bakdir}autoftp.log

echo "..................start $starttime .............................................." >>${bakdir}autoftp.log

ftp -d -i -n >>${bakdir}autoftp.log 2>>${bakdir}autoftp.log <

open $Bak_Server_IP

user $ftpuname $ftppwd

bi

cd $remotedir

lcd $localdir

mput *.bak

bye

EOF

endtime=`date +%y-%m-%d-%T`

echo "..................end $endtime .............................................." >>${bakdir}autoftp.log

该脚本为压缩备份，冗余度为1，且自动删除过期备份