oracle rman和dump共存双机备份设置.doc

oracle rman备份设置(用于双重备份rman备份到其他电脑，而dump备份到本机/u02/oradata/orarmanbak下)主要功能：使用rman来备份oracle数据库，然后通过rsync复制到另外的机器上。# 在cron中运行（每天早上 1:02执行）/var/spool/cron/root#crontab -ecat/var/spool/cron/root/script/orarmanbak.log 2&11 2 * * * /script/oradumpbak.sh /script/oradumpbak.log 2&1EOF全量备份：#0确认已经启用归档模式SQL archive log list;Database log mode Archive ModeAutomatic archival EnabledArchive destination /u02/oradata/center/archiveSQL select tablespace_name from dba_tablespaces ; /查看oracle所有表空间,以便于dump备份#1.创建备份目录mkdir /u02/oradata/orarmanbakchown oracle.oinstall /u02/oradata/orarmanbak#mkdir -p /u02/oradata/orarmanbak/dumpdir#chgrp -R oinstall /u02/oradata/orarmanbak/dumpdir#chown -R oracle /u02/oradata/orarmanbak/dumpdir#2.创建备份脚本mkdir /scripttouch /script/orarmanbak.shchmod 777 /script/orarmanbak.shtouch /script/dump.shchmod 777 /script/dump.shtouch /script/oradumpbak.shchmod 777 /script/oradumpbak.shvi /script/orarmanbak.sh内容如下（请按实际情况修改BACKDIR，RPORT,RHOST,RDID，其中后三项为存放备份文件的服务器）#!/bin/bash#function: backup oracle script with rman.#usage: crontab on linux #exsample: 2 1 * * * /script/orabackup.sh /script/orabackup.log 2&1BACKDIR=/u02/oradata/orarmanbakRPORT=65422RHOST=192.168.60.11RDIR=/opt/oraclebak#rman backupif ! -d $BACKDIR ; then mkdir -p $BACKDIR chown oracle.oinstall $BACKDIRfi#su - oracle -c rman target / cmdfile /scripts/rmancmdsu - oracle -c rman target / /script/orabackup.log 2&1#Author: zhuct 2009.4.29 v2#export ORACLE_SID=center#export ORACLE_HOME=/u01/app/oracle/product/10.2.0BACKDIR=/u02/oradata/orabackupRPORT=65422RHOST=192.168.60.11RDIR=/data/orabackupDAYOFWEEK=date +%u LEVEL=0case $DAYOFWEEK in 1|2|4|5) LEVEL=2 ; 3|6) LEVEL=1 ; *) LEVEL=0 ;esac if ! -d $BACKDIR ; then mkdir -p $BACKDIR chown oracle.oinstall $BACKDIRfi#su - oracle -c r