oracle0级备份和全备份实录_oracle 备份

$ vi lev0_bak.sh

#!/usr/bin/bash

export ORACLE_BASE=/u01/app/oracle/

export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db-1

export ORACLE_SID=product

export PATH=$ORACLE_HOME/bin:$PATH

rman target / <

run {

allocate channel c1 type disk

format '/backup/product_bk/rman_0_%s_%p.bk';

backup incremental level=0

(database);

}

run {

allocate channel d1 type disk

format '/backup/product_bk/arch_%s_%p.bk';

backup archivelog all delete input;

}

exit

EOF

增量备份(一级备份)

#!/usr/bin/bash

export ORACLE_BASE=/u01/app/oracle/

export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db-1

export ORACLE_SID=product

export PATH=$ORACLE_HOME/bin:$PATH

rman target / <

run {

allocate channel c1 type disk

format '/backup/product_bk/rman_1_%s_%p.bk';

backup incremental level=1

(database);

}

run {

allocate channel d1 type disk

format '/backup/product_bk/arch_%s_%p.bk';

backup archivelog all delete input;

}

exit

EOF

删除备份

#!/usr/bin/bash

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db-1

export ORACLE_SID=product

export PATH=$ORACLE_HOME/bin:$PATH

rman target / <

crosscheck backup of database;

crosscheck backup of archivelog all;

delete noprompt expired backup of database;

delete noprompt expired backup of archivelog all;

delete noprompt obsolete;

exit

EOF

分享到：

2013-11-05 14:59

浏览 667

分类:数据库

评论