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

《oracle rman和dump共存双机备份设置》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、oraclerman备份设置(用于双重备份rman备份到其他电脑，而dump备份到本机/u02/oradata/orarmanbak下)主要功能：使用rman来备份oracle数据库，然后通过rsync复制到另外的机器上。##在cron中运行（每天早上1:02执行）/var/spool/cron/root#crontab-ecat>>/var/spool/cron/root<>/script/orarmanbak.log2>&112***/scrip

2、t/oradumpbak.sh>>/script/oradumpbak.log2>&1EOF全量备份：##0确认已经启用归档模式SQL>archiveloglist;Databaselogmode             ArchiveModeAutomaticarchival            EnabledArchivedestination           /u02/oradata/center/archiveSQL>selecttablespace_namefromdba_tablespaces

3、;//查看oracle所有表空间,以便于dump备份##1.创建备份目录mkdir/u02/oradata/orarmanbakchownoracle.oinstall/u02/oradata/orarmanbak#mkdir-p/u02/oradata/orarmanbak/dumpdir#chgrp-Roinstall/u02/oradata/orarmanbak/dumpdir#chown-Roracle/u02/oradata/orarmanbak/dumpdir##2.创建备份脚本mkdir/scri

4、pttouch/script/orarmanbak.shchmod777/script/orarmanbak.shtouch/script/dump.shchmod777/script/dump.shtouch/script/oradumpbak.shchmod777/script/oradumpbak.shvi/script/orarmanbak.sh内容如下（请按实际情况修改BACKDIR，RPORT,RHOST,RDID，其中后三项为存放备份文件的服务器）#!/bin/bash#function:back

5、uporaclescriptwithrman.#usage:crontabonlinux#exsample:21***/script/orabackup.sh>>/script/orabackup.log2>&1BACKDIR=/u02/oradata/orarmanbakRPORT=65422RHOST=192.168.60.11RDIR=/opt/oraclebak#rmanbackupif[!-d$BACKDIR];then   mkdir-p$BACKDIR   chownoracle.oinstall

6、$BACKDIRfi#su-oracle-c"rmantarget/cmdfile/scripts/rmancmd"su-oracle-c"rmantarget/ <

7、 configurecontrolfileautobackupformatfordevicetypediskto'$BACKDIR/%F';   allocatechannelc1typedisk;      backupdatabase       format'$BACKDIR/$Ddir/db_%d_%T_s%s_p%p.rmn'       plusarchivelog       format'$BACKDIR/$Ddir/arch_%d_%T_s%s_p%p.rmn'       deleteall

8、input;   releasechannelc1;}run{   allocatechannelc1typedisk;      crosscheckbackupset;      deletenopromptforceobsolete;   releasechannelc1;}exit;EOF"##rsynctoothermachine,ifnoneed,plscommentsu-