hi i have read some posts regarding SAP offsite restoration and you guys make it seem so easy....
I am having trouble thou...
here is our procedure..
1) import monthly full offline, daily online, every 3 hour archive log backup
1) restore a monthly full offline
2) restore sap_catalog_daily
3) full database recovery via BR tools
my sap_catalog_daily policy consists of the following backup selection:
/oracle/EP1/sapcheck/
/oracle/EP1/sapreorg/
/oracle/EP1/saparch/
/oracle/EP1/sapbackup/
/oracle/EP1/origlogA/cntrl/cntrlEP1.dbf
/oracle/EP1/sapdata1/system_1/cntrl/cntrlEP1.dbf
the goal of sap_catalog_daily policy is for BRTOOLS to be able to recognize the backup images
however when i fire up a full database recovery. i miss out on a lot of archive logs
BR0280I BRRECOVER time stamp: 2007-08-22 12.21.22
BR0331I Start and mount of database instance EP1 successful
BR0776I First redo log file sequence to apply for database instance EP1: 40668
BR0777I Last redo log file sequence to apply for database instance EP1: 45853
BR0699I Reading log file /oracle/EP1/saparch/archEP1.log for device type DISK...
BR0699I Reading log file /oracle/EP1/saparch/archEP1.log for device type TAPE/BACKINT/RMAN...
BR0699I Reading log file /oracle/EP1/saparch/archEP1.log for device type STAGE...
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40669.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40670.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40671.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40672.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40673.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40674.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40675.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40676.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40677.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40678.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40679.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40680.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40681.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40682.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40683.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40684.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40685.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40686.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40687.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40688.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40689.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40690.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40691.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40692.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40693.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40694.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40695.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40696.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40697.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40698.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40699.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40700.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40701.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40702.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40703.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40704.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40705.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40706.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40707.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40708.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40709.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40710.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40711.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40712.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40713.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40714.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40715.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40716.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40717.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40718.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40719.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40720.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40721.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40722.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40723.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40724.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40725.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40726.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40727.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40728.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40729.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40730.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40731.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40732.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40733.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40734.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40735.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40736.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40737.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40738.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40739.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40740.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40741.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40742.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40743.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40744.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40745.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40746.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40747.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40748.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40749.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40750.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40751.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40752.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40753.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40754.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40755.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40756.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40757.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40758.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40759.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40760.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40761.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40762.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40763.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40764.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40765.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40766.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40767.dbf not found
BR0017W Offline redo log file /oracle/EP1/oraarch/EP1arch1_40768.dbf not found
BR0775W More than 100 archivelog files of database instance EP1 missing - terminating searching...
BR0668I Warnings or errors occured - you can continue to ignore them or go back to repeat the last action
BR0280I BRRECOVER time stamp: 2007-08-22 12.21.34
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
c
BR0280I BRRECOVER time stamp: 2007-08-22 12.22.13
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...
BR0280I BRRECOVER time stamp: 2007-08-22 12.22.13
BR0660I List display 113 - no selection possible
-------------------------------------------------------------------------------
Archivelog files to apply of database instance EP1
Pos. Sequence Status Apply From Disk Tape Util Rman Stage
1 - 40668 in_arch yes arch .... .... .... .... ....
2 - 40669 NOT_FND yes .... .... .... .... .... ....
3 - 40670 NOT_FND yes .... .... .... .... .... ....
4 - 40671 NOT_FND yes .... .... .... .... .... ....
5 - 40672 NOT_FND yes .... .... .... .... .... ....
6 - 40673 NOT_FND yes .... .... .... .... .... ....
7 - 40674 NOT_FND yes .... .... .... .... .... ....
8 - 40675 NOT_FND yes .... .... .... .... .... ....
9 - 40676 NOT_FND yes .... .... .... .... .... ....
10 - 40677 NOT_FND yes .... .... .... .... .... ....
11 - 40678 NOT_FND yes .... .... .... .... .... ....
12 - 40679 NOT_FND yes .... .... .... .... .... ....
13 - 40680 NOT_FND yes .... .... .... .... .... ....
14 - 40681 NOT_FND yes .... .... .... .... .... ....
15 - 40682 NOT_FND yes .... .... .... .... .... ....
16 - 40683 NOT_FND yes .... .... .... .... .... ....
17 - 40684 NOT_FND yes .... .... .... .... .... ....
18 - 40685 NOT_FND yes .... .... .... .... .... ....
19 - 40686 NOT_FND yes .... .... .... .... .... ....
20 - 40687 NOT_FND yes .... .... .... .... .... ....
Press <Rtn> - scroll, 'c' - cont, 'h' - header, 's' - stop ...
c
21 - 40688 NOT_FND yes .... .... .... .... .... ....
22 - 40689 NOT_FND yes .... .... .... .... .... ....
23 - 40690 NOT_FND yes .... .... .... .... .... ....
24 - 40691 NOT_FND yes .... .... .... .... .... ....
25 - 40692 NOT_FND yes .... .... .... .... .... ....
26 - 40693 NOT_FND yes .... .... .... .... .... ....
27 - 40694 NOT_FND yes .... .... .... .... .... ....
28 - 40695 NOT_FND yes .... .... .... .... .... ....
29 - 40696 NOT_FND yes .... .... .... .... .... ....
30 - 40697 NOT_FND yes .... .... .... .... .... ....
31 - 40698 NOT_FND yes .... .... .... .... .... ....
32 - 40699 NOT_FND yes .... .... .... .... .... ....
33 - 40700 NOT_FND yes .... .... .... .... .... ....
34 - 40701 NOT_FND yes .... .... .... .... .... ....
35 - 40702 NOT_FND yes .... .... .... .... .... ....
36 - 40703 NOT_FND yes .... .... .... .... .... ....
37 - 40704 NOT_FND yes .... .... .... .... .... ....
38 - 40705 NOT_FND yes .... .... .... .... .... ....
39 - 40706 NOT_FND yes .... .... .... .... .... ....
40 - 40707 NOT_FND yes .... .... .... .... .... ....
41 - 40708 NOT_FND yes .... .... .... .... .... ....
42 - 40709 NOT_FND yes .... .... .... .... .... ....
43 - 40710 NOT_FND yes .... .... .... .... .... ....
44 - 40711 NOT_FND yes .... .... .... .... .... ....
45 - 40712 NOT_FND yes .... .... .... .... .... ....
46 - 40713 NOT_FND yes .... .... .... .... .... ....
47 - 40714 NOT_FND yes .... .... .... .... .... ....
48 - 40715 NOT_FND yes .... .... .... .... .... ....
49 - 40716 NOT_FND yes .... .... .... .... .... ....
50 - 40717 NOT_FND yes .... .... .... .... .... ....
51 - 40718 NOT_FND yes .... .... .... .... .... ....
52 - 40719 NOT_FND yes .... .... .... .... .... ....
53 - 40720 NOT_FND yes .... .... .... .... .... ....
54 - 40721 NOT_FND yes .... .... .... .... .... ....
55 - 40722 NOT_FND yes .... .... .... .... .... ....
56 - 40723 NOT_FND yes .... .... .... .... .... ....
57 - 40724 NOT_FND yes .... .... .... .... .... ....
58 - 40725 NOT_FND yes .... .... .... .... .... ....
59 - 40726 NOT_FND yes .... .... .... .... .... ....
60 - 40727 NOT_FND yes .... .... .... .... .... ....
61 - 40728 NOT_FND yes .... .... .... .... .... ....
62 - 40729 NOT_FND yes .... .... .... .... .... ....
63 - 40730 NOT_FND yes .... .... .... .... .... ....
64 - 40731 NOT_FND yes .... .... .... .... .... ....
65 - 40732 NOT_FND yes .... .... .... .... .... ....
66 - 40733 NOT_FND yes .... .... .... .... .... ....
67 - 40734 NOT_FND yes .... .... .... .... .... ....
68 - 40735 NOT_FND yes .... .... .... .... .... ....
69 - 40736 NOT_FND yes .... .... .... .... .... ....
70 - 40737 NOT_FND yes .... .... .... .... .... ....
71 - 40738 NOT_FND yes .... .... .... .... .... ....
72 - 40739 NOT_FND yes .... .... .... .... .... ....
73 - 40740 NOT_FND yes .... .... .... .... .... ....
74 - 40741 NOT_FND yes .... .... .... .... .... ....
75 - 40742 NOT_FND yes .... .... .... .... .... ....
76 - 40743 NOT_FND yes .... .... .... .... .... ....
77 - 40744 NOT_FND yes .... .... .... .... .... ....
78 - 40745 NOT_FND yes .... .... .... .... .... ....
79 - 40746 NOT_FND yes .... .... .... .... .... ....
80 - 40747 NOT_FND yes .... .... .... .... .... ....
81 - 40748 NOT_FND yes .... .... .... .... .... ....
82 - 40749 NOT_FND yes .... .... .... .... .... ....
83 - 40750 NOT_FND yes .... .... .... .... .... ....
84 - 40751 NOT_FND yes .... .... .... .... .... ....
85 - 40752 NOT_FND yes .... .... .... .... .... ....
86 - 40753 NOT_FND yes .... .... .... .... .... ....
87 - 40754 NOT_FND yes .... .... .... .... .... ....
88 - 40755 NOT_FND yes .... .... .... .... .... ....
89 - 40756 NOT_FND yes .... .... .... .... .... ....
90 - 40757 NOT_FND yes .... .... .... .... .... ....
91 - 40758 NOT_FND yes .... .... .... .... .... ....
92 - 40759 NOT_FND yes .... .... .... .... .... ....
93 - 40760 NOT_FND yes .... .... .... .... .... ....
94 - 40761 NOT_FND yes .... .... .... .... .... ....
95 - 40762 NOT_FND yes .... .... .... .... .... ....
96 - 40763 NOT_FND yes .... .... .... .... .... ....
97 - 40764 NOT_FND yes .... .... .... .... .... ....
98 - 40765 NOT_FND yes .... .... .... .... .... ....
99 - 40766 NOT_FND yes .... .... .... .... .... ....
100 - 40767 NOT_FND yes .... .... .... .... .... ....
101 - 40768 NOT_FND yes .... .... .... .... .... ....
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRRECOVER time stamp: 2007-08-22 12.23.47
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...
is my procedure correct or is there an easier procedure? can somebody help please....