Restore Online/Offline Backup of Source System onto Target System

[Former Member]

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...

[Former Member]

s

[Former Member]

xx

[Former Member]

Take a look at Snote 1003028.

[Former Member]

Hi ,

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). 

You have restored the data to /oracle/IXP/sapbackup directory.....however BRTOOLS is looking in 'D:\oracle\IXD\sapbackup directory

Resolve this....

Thanks,

Salman

[Former Member]

Carefully read the error message.

Did you also copy the files from D:\oracle\IXD\sapbackup\befgowul to the target system?

The error message says either they are not there at all, or in a wrong directory.

(D:\oracle\IXP\sapbackup\befgowul perhaps?)

Besides that, make sure other required drectories exist and are writeable, like C:\ORACLE\IXP\ORIGLOGB.

[Former Member]

hi,

ixd is a sourse system

ixp is a target system

now i am trying restore the backup which i got it from ixd to ixp.

but its showing that its not found the path..

should i do any changes or anything to edit in initsid.sap?

this is the path:D:\oracle\IXD\sapbackup

NOTE: i copied d:\oracle\ixd\sapbackup from sourse system to target system (:D:\oracle\IXP\sapbackup) and then i just renamed it to ixp.

[Former Member]

Hi,

Try editing the backup log to look into the new directory.

I mean open the backup log in target system, change IXD to IXP where ever u see it

Thanks,

Salman

[Former Member]

hi,

ixd is a sourse system

ixp is a target system

now i am trying restore the backup which i got it from ixd to ixp.

but its showing that its not found the path..

should i do any changes or anything to edit in initsid.sap?

this is the path:D:\oracle\IXD\sapbackup

NOTE: i copied d:\oracle\ixd\sapbackup from sourse system to target system (:D:\oracle\IXP\sapbackup) and then i just renamed it to ixp.

[Former Member]

brrestore is looking in D:\oracle\IXD\sapbackup\befgowul. (Just read the error message!)

This directory has to exist.

Whether you copy or rename, will be your choice.

(Editing log files, as mentioned by Salman, could be another option. But it will require a bit more of accuracy.)

[mohammed_anish]

Hi,

Can you try the following..,

Check if you have the following directories created..

C:\ORACLE\IXP\ORIGLOGA\CNTRL

C:\ORACLE\IXP\ORIGLOGB\CNTRL

If they do not exist, there is no harm in creating it manually, so create them. Repeat BRRESTORE as you have done before and paste the output so that we can look at it in more detail.

I assume that you have used the tool OraBRcopy to create the control.sql for the target SID and copied it to the target system's <INSTDIR> as instructed in the Homogenous System Copy Guide.

Regards,

Anish

Edited by: Mohammed Anish on Feb 22, 2011 2:34 PM