oracle rac rman脚本,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 <

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<

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;

}