cancel
Showing results for 
Search instead for 
Did you mean: 

SAP DR restore procedure....

kidlatngkavite
Level 3
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....
 
 
 
 
 
0 REPLIES 0