当前位置：首页>技术交流>Veritas NetBackup Oracle备份和恢复

Veritas NetBackup Oracle的备份和恢复

参考前面章节，配置需要备份的脚步，Netbackup 会通过设定的策略调用脚本，对oracle 数据库进行备份

Oracle的恢复

恢复控制文件

RUN{

SET CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'SBT_TAPE'

TO '%F';

ALLOCATE CHANNEL CH00 DEVICE TYPE 'SBT_TAPE'; SEND 'NB_ORA_CLIENT=ha-oracle2';

RESTORE CONTROLFILE FROM AUTOBACKUP MAXDAYS 2;

RELEASE CHANNEL CH00;

}

将数据库改变到MOUNT状态

alter database mount

恢复数据文件

RUN{

ALLOCATE CHANNEL CH00 DEVICE TYPE 'SBT_TAPE';

SEND 'NB_ORA_CLIENT=ha-oracle2';

RESTORE DATABASE;

RELEASE CHANNEL CH00;

}

恢复归档日志

RUN{

ALLOCATE CHANNEL CH00 DEVICE TYPE 'SBT_TAPE';

SEND 'NB_ORA_CLIENT=ha-oracle2';

RESTORE ARCHIVELOG ALL;

RELEASE CHANNEL CH00;

}

进行recover

RUN{

ALLOCATE CHANNEL CH00 DEVICE TYPE 'SBT_TAPE';

SEND 'NB_ORA_CLIENT=ha-oracle2';

RECOVER DATABASE;

RELEASE CHANNEL CH00;

}

以resetlog打开数据库

alter database open resetlogs;

检查数据库内容

SELECT NAME,STATUS FROM V$DATAFILE;