RMAN 非归档模式 备份shell脚本

本文详细介绍了使用RMAN进行非归档模式下的0级和1级累积备份的Shell脚本实现,包括配置参数、备份流程及关键步骤解析。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

RMAN 非归档模式  备份shell脚本:

0级备份

#!/bin/sh

export PATH

export TMP=/tmp

export TMPDIR=/tmp

export ORACLE_BASE=/opt/oracle

exportORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1

export ORACLE_SID=orclbj

export PATH=$PATH:$ORACLE_HOME/bin:

exportLD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib

 

rman target / nocatalog msglog=bak0.log<< EOF

 

run{

CONFIGURE CONTROLFILE AUTOBACKUP ON;

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FORDEVICE TYPE DISK TO '/opt/bak/con_%F_%T.tar.bz2';

CONFIGURE RETENTION POLICY TO REDUNDANCY 2;

configure device type disk parallelism 1backup type to compressed backupset;

report obsolete;

delete noprompt obsolete;

crosscheck backup;

delete noprompt expired backup;

shutdown immediate;

startup mount;

backup incremental level=0 database format'/opt/bak/bak_%T_%t_%d.tar.bz2';

shutdown immediate;

startup;

}

EOF

 

1级累积备份:

#!/bin/sh

#### 2011.6.27 ####

#level=1#

 

export PATH

export TMP=/tmp

export TMPDIR=/tmp

export ORACLE_BASE=/opt/oracle

exportORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1

export ORACLE_SID=orclbj

export PATH=$PATH:$ORACLE_HOME/bin:

exportLD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib

export BAKFILE=/opt/bak/bak1.log

rman nocatalog target / msglog $BAKFILE<< EOF

run{

CONFIGURE CONTROLFILE AUTOBACKUP ON;

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FORDEVICE TYPE DISK TO '/opt/bak/con1_%F_%T.tar.bz2';

CONFIGURE RETENTION POLICY TO REDUNDANCY 2;

configure device type disk parallelism 1backup type to compressed backupset;

report obsolete;

delete noprompt obsolete;

crosscheck backup;

delete noprompt expired backup;

shutdown immediate;

startup mount;

backup incremental level=1 cumulativedatabase format '/opt/bak/bak1_%T_%t_%d.tar.bz2';

shutdown immediate;

startup;

}

EOF

 

 

 

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值