Skip to Content
0
Former Member
Feb 21, 2011 at 09:45 AM

Restore Online/Offline Backup of Source System onto Target System

153 Views

hi all,

Now i am doing system copy from backup/restore method

Activities done on Source system:

I have Created CONTROLFILE creation script on Source System.

I have take online with redolog backup on Source system on Disk (D:\oracle\IXD\sapbackup).

Activities Done on Tareget system :

I have cleaned Data and log dir on Target system before restoring Source database.

sapdata1..4*

origlog

mirrlog

sapreorg

saparch

saptrace/usertrace

saptrace/background/*

sapbackup/*

sapcheck

I have Copied all required detailed backup log file into /oracle/IXP/sapbackup directory on target system.and also Use

BRRESTORE command below to restore the source database (IXD) on target system (IXP).

D:\oracle\IXP\sapbackup>brrestore -m full -b befgowul.and -c

BR0401I BRRESTORE 7.00 (48)

BR0405I Start of file restore: refhdkog.rsb 2011-02-21 14.51.14

BR0484I BRRESTORE log file: D:\oracle\IXP\sapbackup\refhdkog.rsb

BR0454W Values of oracle_sid are different: current 'IXP', backup befgowul.and '

IXD'

BR0455W Value 'IXP' of oracle_sid will be used for restore

BR0454W Values of oracle_home are different: current 'D:\oracle\IXP\102', backup

befgowul.and 'D:\oracle\IXD\102'

BR0455W Value 'D:\oracle\IXP\102' of oracle_home will be used for restore

BR0454W Values of sapdata_home are different: current 'D:\oracle\IXP', backup be

fgowul.and 'D:\oracle\IXD'

BR0455W Value 'D:\oracle\IXP' of sapdata_home will be used for restore

BR0280I BRRESTORE time stamp: 2011-02-21 14.51.14

BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRRESTORE:

c

BR0280I BRRESTORE time stamp: 2011-02-21 14.51.22

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0443W File 'D:\oracle\IXD\sapbackup\befgowul\SR3.DATA1' to be restored not fou

nd

BR0443W File 'D:\oracle\IXD\sapbackup\befgowul\SR3.DATA2' to be restored not fou

nd

BR0443W File 'D:\oracle\IXD\sapbackup\befgowul\SR3.DATA3' to be restored not fou

nd

BR0443W File 'D:\oracle\IXD\sapbackup\befgowul\SR3.DATA4' to be restored not fou

nd

BR0443W File 'D:\oracle\IXD\sapbackup\befgowul\SR3700.DATA1' to be restored not

found

BR0443W File 'D:\oracle\IXD\sapbackup\befgowul\SR3700.DATA2' to be restored not

found

BR0443W File 'D:\oracle\IXD\sapbackup\befgowul\SR3700.DATA3' to be restored not

found

BR0443W File 'D:\oracle\IXD\sapbackup\befgowul\SR3700.DATA4' to be restored not

found

BR0443W File 'D:\oracle\IXD\sapbackup\befgowul\SR3DB.DATA1' to be restored not f

ound

BR0443W File 'D:\oracle\IXD\sapbackup\befgowul\SR3DB.DATA2' to be restored not f

ound

BR0443W File 'D:\oracle\IXD\sapbackup\befgowul\SR3DB.DATA3' to be restored not f

ound

BR0443W File 'D:\oracle\IXD\sapbackup\befgowul\SR3USR.DATA1' to be restored not

found

BR0443W File 'D:\oracle\IXD\sapbackup\befgowul\UNDO.DATA1' to be restored not fo

und

BR0443W File 'D:\oracle\IXD\sapbackup\befgowul\SYSAUX.DATA1' to be restored not

found

BR0443W File 'D:\oracle\IXD\sapbackup\befgowul\SYSTEM.DATA1' to be restored not

found

BR0443W File 'D:\oracle\IXD\sapbackup\befgowul\CNTRLIXD.DBF' to be restored not

found

BR0427I Files from the old sapdata_home D:\oracle\IXD will be restored into the

new sapdata_home D:\oracle\IXP

BR0280I BRRESTORE time stamp: 2011-02-21 14.51.22

BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRRESTORE:

c

BR0280I BRRESTORE time stamp: 2011-02-21 14.51.27

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0252E Function _mkdir() failed for 'C:\ORACLE\IXP\ORIGLOGA\CNTRL' at location

BrDirCreate-1

BR0253E errno 2: No such file or directory

BR0252E Function _mkdir() failed for 'C:\ORACLE\IXP\ORIGLOGB\CNTRL' at location

BrDirCreate-1

BR0253E errno 2: No such file or directory

BR0406I End of file restore: refhdkog.rsb 2011-02-21 14.51.27

BR0280I BRRESTORE time stamp: 2011-02-21 14.51.27

BR0404I BRRESTORE terminated with errors

D:\oracle\IXP\sapbackup>

Kindly help to restore Source database to Target System...