RMAN 非归档模式 备份shell脚本

来源:互联网 发布:淘宝卖家微信号运营 编辑:程序博客网 时间:2024/05/19 12:17

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

 

 

 

原创粉丝点击