梦想有多远

最近在做RAC系统的备份,自己的SHELL的不是太好.东拼西凑了个
#!/bin/bash
export ORACLE_BASE=
export ORACLE_HOME=
export ORACLE_SID=
export DATE=`date +”%Y%m%d”`
#level 0 backup script
rman target sys/oracle log=’/data/hsipccweb_db_backup/log/backup_level0_`date +”%Y%m%d”`.log’ < run {
allocate channel c1 device type disk format ‘/data/hsipccweb_db_backup/level0_%U’ connect sys/oracle@service_name1;
allocate channel c2 device type disk format ‘/data/hsipccweb_db_backup/level0_%U’ connect sys/oracle@service_name2;
backup incremental level 0 database tag=’level_disk 0′ plus archivelog format ‘/data/hsipccweb_db_backup/log_%U’ delete all input;
release channel c2;
release channel c1;

allocate channel for maintenance device type disk format ‘/data/hsipccweb_db_backup/level0_%U’ connect sys/oracle@service_name1;
crosscheck backupset device type disk;
allocate channel c1 device type sbt connect sys/oracle@service_name1;
backup backupset all delete all input tag =’level_tape 0′;
allocate channel for maintenance device type disk format ‘/data/hsipccweb_db_backup/level0_%U’ connect sys/oracle@service_name2;
crosscheck backupset device type disk;
allocate channel c2 device type sbt connect sys/oracle@service_name2;
backup backupset all delete all input tag =’level_tape 0′;
release channel c2;
release channel c1;
}
crosscheck backup;
delete noprompt expired backup;
delete noprompt obsolete;
EOF

其中plus archivelog 涉及以下操作:
PLUS ARCHIVELOG:

1. Archive log current
2. Backup archived logs
3. Backup database level 0
4. Archive log current
5. Backup any remaining archived log created during backup
RAC备份要注意的就是:在一个实例备份另一个实例归档时,必须确保能连到其他节点,否则备份会失败
还有累积和差异增量备份,差异增量备份快,恢复慢,累积增量备份慢,恢复快,可以根据自己的实际情况选择,还有才用增量备份打开block trace性能好点

This entry was posted on 星期一, 九月 1st, 2008 at 9:56 and is filed under oracle. You can follow any responses to this entry through the RSS 2.0 feed. You can skip to the end and leave a response. Pinging is currently not allowed.