二、 开始恢复：恢复控制文件
1.恢复控制文件
(1).恢复备份日志信息
test:oracle> brrestore -d util_file -b2 "#NULL" -m /oracle/SID/sapbackup/backSID.log
BR0401I BRRESTORE 7.00 (28)
BR0405I Start of file restore: rdysreel.rsf 2008-09-03 15.38.51
BR0484I BRRESTORE log file: /oracle/SID/sapbackup/rdysreel.rsf
BKI0023I: Time: 09/03/08 15:39:42 Done: 92.931 KB (100.0 %) of 92.931 KB. Estimated end time: 09/03/08 15:39:42.
BKI0054I: Time: 09/03/08 15:39:42 Object: 1 of 1 done: /oracle/SID/sapbackup/backSID.log with: 92.931 KB restored with description HE2___A0FKMG7QD5 .
BR0280I BRRESTORE time stamp: 2008-09-03 15.39.42
#FILE..... /oracle/SID/sapbackup/backSID.log
#RESTORED. HE2___A0FKMG7QD5
BKI1215I: Average transmission rate was 0.006 GB/h (0.001 MB/sec).
BKI0020I: End of program at: Wed Sep 3 15:39:43 BEIST 2008 .
BKI0021I: Elapsed time: 50 sec .
BKI0024I: Return code is: 0.
BR0280I BRRESTORE time stamp: 2008-09-03 15.39.43
BR0374I 1 of 1 file restored by backup utility
BR0230I Backup utility called successfully
BR0406I End of file restore: rdysreel.rsf 2008-09-03 15.39.43
BR0280I BRRESTORE time stamp: 2008-09-03 15.39.43
BR0402I BRRESTORE completed successfully
(2).检查备份日志时间点，并寻找其对应备份信息文件，如要恢复 2008-09-02 09.05.31 数据，则对应备份信息文件为：bdyskxlr
GVSHE503:orahe5 290> tail -f /oracle/SID/sapbackup/backSID.log
bdyrrsgq fnf 2008-08-29 11.21.16 2008-08-29 12.40.03 0 ............... 75 73 0 40 1921562076 41 1921576134 FULL online util_file ------ 7.00 (28)
bdysgqoe pnr 2008-09-01 12.16.00 2008-09-01 12.16.23 5 ............... 76 0 0 46 1921961576 0 0 PARTIAL online rman_util ------ 7.00 (28)
bdysgqsa fnr 2008-09-01 12.17.40 2008-09-01 12.17.51 5 ............... 76 0 0 46 1921961576 0 0 FULL online rman_util ------ 7.00 (28)
bdysgrbf pnr 2008-09-01 12.21.39 2008-09-01 12.24.12 5 ............... 76 0 0 46 1921961576 0 0 PARTIAL online rman_util ------ 7.00 (28)
bdysgtpl pnr 2008-09-01 12.50.21 2008-09-01 12.51.44 0 ............... 76 1 0 46 1921961576 47 1921995257 PARTIAL online rman_util ------ 7.00 (28)
bdysgwhl fnr 2008-09-01 13.20.41 2008-09-01 14.11.07 0 ............... 76 73 0 47 1921995257 48 1921997589 FULL online rman_util ------ 7.00 (28)
bdyskxjz inr 2008-09-02 09.04.47 2008-09-02 09.04.52 3 ............... 76 0 0 2 1922062890 0 0 ............ ............... ................ ...... 7.00 (28)
bdyskxlr fnr 2008-09-02 09.05.31 2008-09-02 09.57.44 0 ............... 76 73 0 2 1922062890 3 1922116988 FULL online rman_util ------ 7.00 (28)
bdyslfnt inr 2008-09-02 10.36.33 2008-09-02 10.52.39 0 ............... 76 1 0 3 1922116988 4 1922120831 INCR online rman_util ------ 7.00 (28)
bdysmtqz fnr 2008-09-02 18.08.37 2008-09-02 19.39.58 9 ............... 76 73 0 7 1922175876 8 1922783284 FULL online rman_util ------ 7.00 (28)
(3).恢复备份信息文件bdyskxlr
brrestore -d util_file -b2 "#NULL" -m /oracle/SID/sapbackup/bdyskxlr.fnr
