BR0443W and BR0417W during brrestore

[former_member182034]

Dear All,

I am trying to make Homogeneous System Copy with Option(Backup and Restore). successfully completed the Full database offline backup with DB 13 of DEV server and want to restore on Test Server(PRD).

I have created files (Control.sql, Control.trc , initPRD.ora) with ora_br_copy and did paste in Folder (E:\oracle\PRD\102\database, sapinst_instdir\ERP\LM\COPY\ORA\SYSTEM\CENTRAL\AS-ABAP)

Oracle patch level , BRTOOLS and JDK version is same on Source(DEV) and Target System (PRD)

now Installation on Backup/Restore database phase

I am getting following issue when executing brrestore command.

C:\Users\prdadm>brrestore -m full -b beiclxsx.ffd
BR0401I BRRESTORE 7.10 (42)
BR0405I Start of file restore: reicnzlf.rsb 2012-03-16 09.55.43
BR0484I BRRESTORE log file: F:\oracle\PRD\sapbackup\reicnzlf.rsb
BR0454W Values of oracle_sid are different: current 'PRD', backup beiclxsx.ffd '
DEV'
BR0455W Value 'PRD' of oracle_sid will be used for restore
BR0454W Values of oracle_home are different: current 'E:\oracle\PRD\102', backup
 beiclxsx.ffd 'F:\oracle\DEV\102'
BR0455W Value 'E:\oracle\PRD\102' of oracle_home will be used for restore
BR0454W Values of sapdata_home are different: current 'F:\oracle\PRD', backup be
iclxsx.ffd 'F:\oracle\DEV'
BR0455W Value 'F:\oracle\PRD' of sapdata_home will be used for restore
BR0280I BRRESTORE time stamp: 2012-03-16 09.55.43
BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRRESTORE:
c
BR0280I BRRESTORE time stamp: 2012-03-16 09.55.46
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...
BR0443W File 'F:\oracle\DEV\sapbackup\beiclxsx\SR3.DATA10.Z' to be restored not
found
BR0443W File 'F:\oracle\DEV\sapbackup\beiclxsx\SR3.DATA11.Z' to be restored not
BR0427I Files from the old sapdata_home F:\oracle\DEV will be restored into the
new sapdata_home F:\oracle\PRD
BR0280I BRRESTORE time stamp: 2012-03-16 09.55.46
BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRRESTORE:
c
BR0280I BRRESTORE time stamp: 2012-03-16 09.55.58
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...
BR0417W No files found for restore/verification
BR0406I End of file restore: reicnzlf.rsb 2012-03-16 09.55.58
BR0280I BRRESTORE time stamp: 2012-03-16 09.55.58
BR0403I BRRESTORE completed successfully with warnings

please fine attached initPRD.sap of source (DEV) and Target(PRD) system.

would anyone tell me that how can rectify above issue to restore.

Regards,

initDEV_BackupFile.txt.zip

initPRD_onTargetSystem.txt.zip

[Former Member]

Hi,

Check this thread

http://scn.sap.com/thread/1427881

Regards,

Venkata S Pagolu

[former_member182034]

hi Venkata,

Dear, I already checked this thread even I discussed with Mr. Imran Khan and he checked this issue but problem still persist. He did recover the backup with following command but my issue did not solve with this commmand.

brrecover -c -t dbpit  -b last -f PRD -seq

BR0443W File 'F:\oracle\DEV\sapbackup\beiclxsx\SR3.DATA11.Z' to be restored not

the path(F:\oracle\DEV\sapbackup\) from above statement is showing initDEV.sap which is exist in backup dump.

would you tell me why I am getting this issue BR0443W and which parameter I have to set and where mean inwhich file(initPRD.sap or initDEV.sap or beiclxsx.ffd, backDEV).

Your help is appreciated...

Regards,

[Former Member]

Hi,

Please provide init<SID>.utl file you are using for restore.

Regards,

Venkata S Pagolu.

[former_member182034]

hi Venkata,

Sorry for late reply,

now I am making hemogeneous system copy with option backup/restore and want to restore the PRD's Full Database Offline Backup on DEV server but still getting same issue(BR0443W,BR0417W )

Dear, the file with name init<SID>.utl is not exist on system while I am using initPRD.sap file for restore backup. please see backPRD log and find remainig attached log.

beiczwsp ffd  2012-03-18 20.00.19  2012-03-18 22.34.39  9         0.0000:0     42    42     0     61847       1285016422    61848       1285025026  FULL         offline_force   disk             ---b-c 7.10 (42)  PRD      @G:\oracle\PRD\sapbackup

the location of folder on source and Target system

Oracle Software: E:\oracle\DEV\102  (same)
Archive: F:\Oracle\DEV\oraarch\PRDarch (same)
SAP Datafiles: G:\Oracle\DEV\sapbackup (same)
the location of G:\usr\sap is not same 

if you need more information then please tell me and help me to resolve this issue

Regards,

beiczwsp.ffd.txt.zip

iniPRD.sap.txt.txt.zip

initPRD.ora.txt.zip

[Former Member]

Hi,

Thank you. Let em know the command you are using for restore.

Regards,

Venkata S Pagolu.

[former_member182034]

brrestore -m full -b <File Name>

as i said that now I am going to restore PRD to DEV.

BR0443W File 'F:\oracle\PRD\sapbackup\beiclxsx\SR3.DATA11.Z' to be restored not found

I am getting above error (BR0443W) due to different SID(PRD). where i have to change this SID in backup files.

would you confirm me that which log files I have to rename from PRD to DEV like one is backPRD to backDEV and remaining.

what do you say about the SID of entire file text mean I need to change it or no need or i just need to change the backup file name from PRD to DEV?

Regards