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

缺乏、安全感 2023-01-18 06:55 240阅读 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数据库备份恢复失败：备份策略问题

相关 Oracle数据库备份策略不当：问题及优化建议

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

相关 Oracle备份及备份策略