oracle备份策略建议,oracle备份策略

缺乏、安全感 2023-01-18 06:55 188阅读 0赞

RMAN>  CONFIGURE RETENTION POLICY TO REDUNDANCY 2;

RMAN>  CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 14 DAYS;

启用控制文件自动备份及备份存放位置配置

RMAN> configure controlfile autobackup on;

查看配置信息

RMAN> show all;

\-------------------------------------------------

\--创建文件夹

$mkdir /home/oracle/backup

mkdir /home/oracle/backup/script

mkdir /home/oracle/backup/log

mkdir /home/oracle/backup/export

\--备份目的地

mkdir /home/oracle/rman\_backup

创建备份表空间

create tablespace rman\_tbs datafile ‘/u01/app/oracle/oradata/orcl11g/rman\_tbs01.dbf‘

size 1024M autoextend on next 50M maxsize 10240M

extent management local segment space management auto;

创建备份用户

create user rman identified by rman default tablespace rman\_tbs temporary tablespace temp;

grant connect,resource ,recovery\_catalog\_owner to rman;

SQL> grant unlimited tablespace to rman;

SQL> grant sysdba to rman;

rman catalog rman/rman

create catalog tablespace rman\_tbs;

connect target sys/Oracle123@orcl11g

report schema;

\-------------------------------------------------------

\--倒出RMAN用户数据脚本exp\_rman.par (即备份catalog库)

userid=rman/rman

file=/home/oracle/backup/export/rman.dmp

log=/home/oracle/backup/log/rman.log

\-- 倒出RMAN数据SHELL脚本exp\_rman.sh

\#!/bin/bash

cd $HOME

. .bash\_profile

cd $HOME/backup/script

exp parfile=exp\_rman.par

\--------------

\---零级备份RMAN脚本level0\_backup.rcv

connect catalog rman/rman

connect target sys/Oracle123@orcl11g

run \{

allocate channel d1 type disk;

allocate channel d2 type disk;

backup incremental level 0 database format ‘/home/oracle/rman\_backup/level0\_%d\_%s\_%p\_%u.bak‘

tag=‘level 0‘ include current controlfile;

sql ‘alter system archive log current‘;

backup archivelog all format ‘/home/oracle/rman\_backup/arc\_%d\_%s\_%p\_%u.bak‘ ;

release channel d2;

release channel d1;

crosscheck backup;

delete noprompt expired backup;

delete noprompt obsolete;

crosscheck archivelog all;

delete noprompt archivelog all completed before ‘sysdate-15‘;

resync catalog;

\--零级备份SHELL脚本的level0\_backup.sh

\#!/bin/bash

backtime=\`date +"%y%m%d%H"\`

\#cd $HOME

. /home/oracle/.bash\_profile

cd $HOME/backup/script

rman cmdfile=level0\_backup.rcv msglog=$HOME/backup/log/level0\_$\{backtime\}.log

. /home/oracle/backup/script/exp\_rman.sh

一级差异增量备份RMAN脚本 level1\_backup.rcv

connect catalog rman/rman

connect target sys/Oracle123@orcl11g

run \{

allocate channel d1 type disk;

backup incremental level 1 format ‘/home/oracle/rman\_backup/level1\_%d\_%s\_%p\_%u.bak‘ tag = ‘level 1‘cumulative database;

sql ‘alter system archive log current‘;

backup archivelog all format ‘/home/oracle/rman\_backup/log\_%d\_%s\_%p\_%u.bak‘ ;

release channel d1;

crosscheck backup;

delete noprompt expired backup;

delete noprompt obsolete;

crosscheck archivelog all;

delete noprompt archivelog all completed before ‘sysdate-15‘;

resync catalog;

\--一级差异增量备份SHELL脚本level1\_backup.sh

\#!/bin/bash

backtime=\`date +"%y%m%d%H"\`

\#cd $HOME

. /home/oracle/.bash\_profile

cd /home/oracle/backup/script

rman cmdfile=level1\_backup.rcv msglog=$HOME/backup/log/level1\_$\{backtime\}.log

. /home/oracle/backup/script/exp\_rman.sh

linux下定时执行备份脚本

crontab -e -u oracle

SHELL=/bin/bash --以下脚本在bash下执行

MAILTO=oracle --执行日志以邮件形式邮给oracle用户，可以/var/spool/mail/oracle下查收

5 12 \* \* 1 nohup /home/oracle/backup/script/level0\_backup.sh >/home/oracle/backup/cron.log 2>&1 &

5 12 \* \* 3 /home/oracle/backup/script/level1\_backup.sh

5 12 \* \* 5 /home/oracle/backup/script/level1\_backup.sh

一周差异备份策略：

备份目标库和catalog库

周一0级全备，周三周五为1级。

每天12点5分开始备份

oracle备份策略

标签：备份策略

本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉 本文系统来源：http://askjoey.blog.51cto.com/7594056/1679274

oracle备份策略建议,oracle备份策略

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 oracle数据库备份

相关 oracle查询备份路径,Oracle备份与恢复案例

相关 oracle备份策略建议,oracle备份策略

相关代码查看oracle备份策略,Oracle增量备份和快速备份（块改变跟踪Block Change Tracking）...

相关 Oracle EM 备份

相关 hbase数据备份策略

相关 Oracle备份及备份策略

相关基于Linux下 Oracle 备份策略(RMAN)

相关基于Linux下 Oracle 备份策略 RMAN

相关 Oracle RMAN 备份（五）--增量备份