oracle rman和dump共存雙機備份設(shè)置.doc

oracle rman備份設(shè)置(用于雙重備份rman備份到其他電腦，而dump備份到本機/u02/oradata/orarmanbak下)主要功能：使用rman來備份oracle數(shù)據(jù)庫，然后通過rsync復制到另外的機器上。# 在cron中運行（每天早上 1:02執(zhí)行）/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確認已經(jīng)啟用歸檔模式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.創(chuàng)建備份目錄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.創(chuàng)建備份腳本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內(nèi)容如下（請按實際情況修改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