RAC rman备份脚本

----归档日志备份脚本

ORACLE_HOME=/oracle/app/product/10gr2
export ORACLE_HOME
ORACLE_BASE=/oracle
export ORACLE_BASE
ORACLE_SID=ossdb1
export ORACLE_SID
rman nocatalog target sys/xxxxx <<EOF
spool log to '/backup/back/fullbackup.log' append;
run{
ALLOCATE CHANNEL c1 DEVICE TYPE DISK CONNECT 'sys/xxx@ossdb1' format '/backup/back/ARC_rac1_%U';
ALLOCATE CHANNEL c2 DEVICE TYPE DISK CONNECT 'sys/xxx@ossdb2' format '/backup/back/ARC_rac2_%U';
sql 'alter system archive log current';
backup archivelog all;
}

---数据库备份脚本

ORACLE_HOME=/oracle/app/product/10gr2
export ORACLE_HOME
ORACLE_BASE=/oracle
export ORACLE_BASE
ORACLE_SID=ossdb1
export ORACLE_SID
rman nocatalog target sys/xxx<<EOF
spool log to '/backup/back/fullbackup.log' append;
run{
ALLOCATE CHANNEL c1 DEVICE TYPE DISK CONNECT 'sys/xxx@ossdb1' format '/backup/back/db_rac1_%U';
ALLOCATE CHANNEL c2 DEVICE TYPE DISK CONNECT 'sys/xxx@ossdb2' format '/backup/back/db_rac2_%U';
backup database;
}

使用磁带备份脚本

run{
allocate channel ch00 type 'SBT_TAPE' connect sys/syspasswd@node1
allocate channel ch01 type 'SBT_TAPE' connect sys/syspasswd@node2
sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';
backup archivelog all delete input;
release channel ch00;
release channel ch01;
}