求nbu 备份 oracle rac database 的脚本(cold 和hot )

johnson2002

回复 10# 无牙


    NBU7.0 nbu for oracle 的best practise里面讲到 virtual vip,你知道这个是啥不? 俺问了好多人都没法理解.....
    rac里的vip很好理解,一个node一个vip, virtual vip真不知道是什么.

hhy1363

第一个脚本将 $NB_ORA_CLIENT和 $NB_ORA_SERV改为真实的主机名，再试试

第二个脚本：数据文件不需要RAC的两个节点都备份，如果归档日志是分别放在两个节点上则脚本类似如下：
RUN {
ALLOCATE CHANNEL ch00 type 'sbt_type';
ALLOCATE CHANNEL ch01 type 'sbt_type';
BACKUP
   TAG hot_backup
   FORMAT 'rac_backup_%d_%s_%p_%t'
   DATABASE;
   sql 'alter system archive log current';
RELEASE CHANNEL ch00;
RELEASE CHANNEL ch01;

ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE' connect 'sys/oracle@racg1' send 'NB_ORA_CLIENT=ibm550-1,NB_ORA_POLICY=racg1_arch,NB_ORA_SCHED=Default-Application-Backup';
ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE' connect 'sys/oracle@racg2' send 'NB_ORA_CLIENT=ibm550-2,NB_ORA_POLICY=racg2_arch,NB_ORA_SCHED=Default-Application-Backup';
BACKUP
   filesperset 20
   FORMAT 'al_%s_%p_%t'
   ARCHIVELOG ALL DELETE INPUT;
RELEASE CHANNEL ch00;
RELEASE CHANNEL ch01;
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
#SEND 'NB_ORA_CLIENT=ibm550-1,NB_ORA_SERV=nbusvr';
BACKUP
    # recommended format
    FORMAT 'cntrl_%s_%p_%t'
    CURRENT CONTROLFILE;
RELEASE CHANNEL ch00;
}


如果归档日志存放路径两个节点都能共享，则和单机的脚本一样即可