- 5
- 0
- 约 12页
- 2016-10-05 发布于贵州
- 举报
BrtoolsRman 恢复操作手册new
Brtools +Rman 恢复操作手册
恢复场景
备份过程
(1)2008-8-26日对ECC GVSHE502 数据库做了一次全备份,之后采用备份archive
(2)2008-8-27日对ECC GVSHE502 数据库新增若干表空间。
(3)2008-8-27~28日对ECC GVSHE502 数据库做reorg动作(mv table and rebuild index)
(4)2008-8-28日下午,对ECC GVSHE502 数据库做增量备份
恢复要求
(1)从备份磁带库中恢复
(2) 恢复到ECC GVSHE502 数据库到2008-8-28 9:00:00
恢复过程
关闭GVSHE503数据库linstner和intance
GVSHE503:orahe5lsnrctl stop
GVSHE503:orahe5sqlplus ‘/as sysdba’
sqlshutdown immediate;
恢复备份日志
GVSHE503:orahe5brrestore -d util_file -b2 #NULL -m /oracle/HE5/sapbackup/backHE5.log
寻找日志文件记录的需要的.fnr文件,并恢复此文件
GVSHE503:orahe5 2 tail -f /oracle/HE5/sapbackup/backHE5.log
bdyrcqqq rmp 2008-08-26 09.49.04 2008-08-26 09.49.05 3 ... 0 0 0 0 0 0 0 ....... ...... ......... ... 7.00 (28) bdyrcqwf dbv 2008-08-26 09.51.29 2008-08-26 09.51.30 3 ... 0 0 0 0 0 0 0 ....... ...... ......... ... 7.00 (28) bdyrcqwy dbv 2008-08-26 09.51.48 2008-08-26 09.51.49 3 ... 0 0 0 0 0 0 0 ....... ...... ......... ... 7.00 (28) bdyrcrem dbv 2008-08-26 09.55.04 2008-08-26 12.53.27 5 ... 256 253 0 126012 4793762120 0 0 ALL online null -dc 7.00 (28) bdyrdjgu fnr 2008-08-26 13.18.52 2008-08-26 14.19.07 4 ... 256 44 0 126012 4793762120 0 0 FULL online rman_util -7 (28) bdyrdoqy pnr 2008-08-26 14.19.36 2008-08-26 14.19.55 4 ... 256 1 0 126012 4793762120 0 0 PARTIAL online rman_util -7 (28) bdyrdovw fnr 2008-08-26 14.21.44 2008-08-26 20.05.31 0 ... 256 253 0 126012 4793762120 126013 4794016302 FULL online rman_util -7 (28) bdyrhzhr pnr 2008-08-27 11.51.15 2008-08-27 12.05.03 0 ... 256 1 0 126013 4794016302 126014 4794061942 PARTIAL online rman_util -7 (28) bdyrmkfo inr 2008-08-28 09.26.00 2008-08-28 14.23.29 9 ... 316 58 0 126022 4794453327 126023 4794500683 INCR online rman_util -7 (28) bdyseivu fnf 2008-09-01 01.03.18 2008-09-01 01.03.19 3 ... 0 0 0 0 0 0 0 ....... ...... ......... ... 7.00 (28) 从backHE5.log里可以可以看出离2008-8-28日最近的全备份是2008-8-26 14:21:44做的备份,恢复当时的备份信息文件bdyrdovw.fnr
GVSHE503:orahe5brrestore -d util_file -b2 #NULL -m /oracle/HE5/sapbackup/bdyrdov
原创力文档

文档评论(0)