1、查看控制文件
/usr/openv/netbackup/bin/bplist -C vdbcn2 -S veritas -t 4 -R / | more
2、启动数据库NOMOUNT
export ORACLE_HOME=/cn1/product
export ORACLE_SID=ora91
sqlplus "/ as sysdba"
startup nomount
3、恢复控制文件
rman target / nocatalog
run{
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
send 'NB_ORA_SERV=veritas,NB_ORA_CLIENT=vdbcn2';
restore controlfile from 'cntrl_6905_1_855662795';
RELEASE CHANNEL ch00;
}
4、启动数据库MOUNT
sqlplus "/ as sysdba"
alter database mount;
5、恢复数据库
rman target / nocatalog
RMAN> run{
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
send 'NB_ORA_SERV=veritas,NB_ORA_CLIENT=vdbcn2';
RESTORE DATABASE;
RELEASE CHANNEL ch00;
};
run{
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
send 'NB_ORA_SERV=veritas,NB_ORA_CLIENT=vdbcn2';
RECOVER DATABASE;
RELEASE CHANNEL ch00;
} ;
6、打开数据库
sqlplus "/ as sysdba"
recover database until cancel using backup controlfile;
alter database open resetlogs;