恢复控制文件
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;
}