Restore SAP Database from USD drive

Steps during staging to restore database from usb drive.

Brrestore command from usb drive..steps make sure to stop sap and oracle except services then perform the restore also once db is stopped to either rename or delete the sapdata-4 directories.

1) mappped the usb drive as drive Y

2) brrestore command later to be used brrestore -d disk -m all -b bekwtmvc.and

3) copy over the initbp1.sap file which was modified to backup to disk from usb to R:\oracle\bp1\102\database folder

4) change the initbp1.sap entries
backup_root_dir = R:\oracle\BP1\sapbackup
stage_root_dir = R:\oracle\BP1\sapbackup
archive_copy_dir = Q:\sapbackup\log ( not required at this moment )
archive_stage_dir = Q:\sapbackup\log ( not required at this moment )

5) Copy the backup bekwtmvc.and bp1, backbp1.log to the R:\oracle\bp1\sapbackup folders

6) Modify the entries in the bekwtmcv assuming the Y drive is the usd drive mapped so change the below paramteres
backup_root_dir                Y:\data
Archive format                 %t_%s_%r.dbf ( change this parameter in initBP1.ora )

Change all the file location to destination folder such as V drive

BR0118I Tablespaces and data files

Tablespace     TS-Status  F-Status  File                                                       Size   Id.     Device  Link    Type       MaxSize     IncrSize  BlkSize      CrtSize         CrtScn

PSAPSR3        ONLINE*    ONLINE+   V:\ORACLE\BP1\SAPDATA2\SR3_3\SR3.DATA63             15728648192   86           3  NOLINK  FILE   15728640000    536870912     8192  15032385536     4898579969
PSAPSR3        ONLINE*    ONLINE+   V:\ORACLE\BP1\SAPDATA2\SR3_1\SR3.DATA1              33554440192    4           3  NOLINK  FILE   3355443200


Change all the redologs locations where it suppose to be located such as below

BR0119I Redolog files

File                                                     Size  Group     Device  Status    Link    Type

R:\ORACLE\BP1\ORIGLOGA\LOG_G11M1.DBF                 52429312    1            3  INUSE     NOLINK  FILE
T:\ORACLE\BP1\MIRRLOGA\LOG_G11M2.DBF 


Change all the control file location

BR0120I Control files

File                                                     Size   Id.      Device  Link    Type

R:\ORACLE\BP1\ORIGLOGA\CNTRL\CNTLRBP1.DBF           112902144    0            3  NOLINK  FILE
R:\ORACLE\BP1\ORIGLOGB\CNTRL\CNTRLBP1.DBF           112902144    0            3  NOLINK  FILE
V:\ORACLE\BP1\SAPDATA1\CNTRL\CNTRLBP1.DBF   

Last change all the source and destination of datafiles to be retrieved and restored. for example Y is the source and V is the destination

BR0202I Saving D:\oracle\product\10.2.0\db_1\database\initBP1_driveQ.sap
BR0203I to Y:\data\BP1 ...

BR0280I BRBACKUP time stamp: 2013-04-02 10.22.36
BR0198I Profiles saved successfully

BR0280I BRBACKUP time stamp: 2013-04-02 10.22.36
BR0315I 'Alter tablespace PSAPSR3 begin backup' successful

BR0202I Saving V:\ORACLE\BP1\SAPDATA2\SR3_3\SR3.DATA63
BR0203I to Y:\data\bekwtmvc\SR3.DATA63 ...

Restore mush finish with no errors. shutdown database and start to configure standby or build the database with control from from source system