NBU恢复脚本案例

恢复控制文件

RUN {

ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE'

parms="ENV=(NB_ORA_SERV=KGNBU01,NB_ORA_CLIENT=t4)";

SEND 'NB_ORA_SERV=K,NB_ORA_CLIENT=t4';

RESTORE controlfile from '&BACKUPSETNAME_CONTROLFILEBAKPP';

RELEASE CHANNEL ch00;

}

恢复数据库

RUN {

ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';

ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE';

SEND 'NB_ORA_SERV=K,NB_ORA_CLIENT=t4';

RESTORE database ;

RELEASE CHANNEL ch00;

RELEASE CHANNEL ch01;

}

基于RPO恢复数据库

RUN {

ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';

ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE';

SEND 'NB_ORA_SERV=K,NB_ORA_CLIENT=t4';

RECOVER database UNTIL TIME  TO_DATE(&TIMESTAMP,’YYYY-MM-DD HH24:MI:SS’);

RELEASE CHANNEL ch00;

RELEASE CHANNEL ch01;

}