欢迎光临
我们一直在努力

ORACLE-RMAN:备份脚本(全库,增量)

1.全库备份:

# script:BackupFull.sh

# creater:yangyuefei

# date:2014/5/14

# desc:backup full database datafile in archive with rman

# connect database

export ORACLE_BASE=/u01/oracle

export ORACLE_HOME=$ORACLE_BASE/product/10.2.0

export ORACLE_SID=ora10g

export PATH=$ORACLE_HOME/bin:${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin

rman target/ << EOF_RMAN

run{

allocate channel c1 type disk;

backup incremental level 0 tag ‘db0’ format

‘/u01/oracle/RmanBackup/db0_%d_%T_%s’database include current

controlfile;

delete noprompt obsolete;

release channel c1;

}

# end

2.增量备份

# script:Incrl.sh

# creater:yangyuefei

# date:2014/5/14

# desc:backup full database datafile in archive with rman

# connect database

export ORACLE_BASE=/u01/oracle

export ORACLE_HOME=$ORACLE_BASE/product/10.2.0

export ORACLE_SID=ora10g

export PATH=$ORACLE_HOME/bin:${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin

rman target/ << EOF_RMAN

run{

allocate channel c1 type disk;

backup incremental level 1 tag ‘db1’ format

‘/u01/oracle/RmanBackup/db1_%d_%T_%s’database include current

controlfile;

delete noprompt obsolete;

release channel c1;

}

# end

赞(0)
【声明】:本博客不参与任何交易,也非中介,仅记录个人感兴趣的主机测评结果和优惠活动,内容均不作直接、间接、法定、约定的保证。访问本博客请务必遵守有关互联网的相关法律、规定与规则。一旦您访问本博客,即表示您已经知晓并接受了此声明通告。