oracle 备份 博客分类： oracle

全备份（0级备份）

$ 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 / <<EOF
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 / <<EOF
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 / <<EOF
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