VeritasNetBackupOracle的备份和恢复.pdfVIP

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;