brrestore on dik to disk backup

[Former Member]

Dear All,

My Devlopment Server I was taking the Full backup on disk.

Now this disk backup I want to restore on my Test Server.

Both Servers are the Hp Unix 11.23. , Oracle 10.2.0.2 & Ecc 6.0

Please reply me details steps how to Restore the same ?

Regards,

Santosh

[Former Member]

Hi Santosh,

Please follow standard sap system copy guides which are specific to your platform.

http://www.sdn.sap.com/irj/sdn/systemcopy

In addition to this go through these links.

Stage Copy Procedure

http://wiki.sdn.sap.com/wiki/pages/viewpage.action?pageId=248709149

Export/Import

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/5019eaab-afdd-2c10-61a1-ac50f784c...

Br,

Venky

[Former Member]

Thanks Venkatesh for reply.

My Problem is to restore the disk data backup. which are in the compress mode. I have copied this backup files in to Test Server. While doing the BRRESTORE following Error occurs :

BR0443W File '/dback/behtcosq/clud.data29.Z' to be restored not found

BR0443W File '/dback/behtcosq/clud.data3.Z' to be restored not found

All files are to be not found ...

Pl. reply where I am stuck.

Regards,

Santosh

[Former Member]

Hi Santosh,

Is the backup path correct?

Was .anf (brbackup log file) modified?

Give us the command the complete log including errors in your next post.

Br,

Venky

[Former Member]

Hi Venky ,

My Backup path is below :

(I)

1. pwd

/oracle/T02/sapbackup

1. ls -la *.afd

-rwxrwxrwx 1 orat02 sapsys 291984 Jan 27 16:57 behtcosq.afd

(II)

brbackup logfile

ERPDEV:orat02 32> pwd

/oracle/dumps/dback/behtcosq

ERPDEV:orat02 33> ls -la *.afd

-rwxrwxrwx 1 orat02 dba 291984 Jan 27 16:57 behtcosq.afd

ERPDEV:orat02 34>

(III)

following is the restore commad :

ERPDEV:orat02 36> pwd

/oracle/dumps/dback/behtcosq

ERPDEV:orat02 37> brrestore -m full -b behtcosq.afd -d disk -c -k yes

BR0454W Values of oracle_sid are different: current 'T02', backup behtcosq.afd '

D02'

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

BR0454W Values of oracle_home are different: current '/oracle/T02/102_64', backu

p behtcosq.afd '/oracle/D02/102_64'

BR0455W Value '/oracle/T02/102_64' of oracle_home will be used for restore

BR0454W Values of sapdata_home are different: current '/oracle/T02', backup beht

cosq.afd '/oracle/D02'

BR0455W Value '/oracle/T02' of sapdata_home will be used for restore

BR0460W Termination message not found in /oracle/T02/sapbackup/behtcosq.afd - lo

g file incomplete (this is OK if the log file was restored)

BR0280I BRRESTORE time stamp: 2012-02-10 11.07.40

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

c

(iv) Folloiwng is the Erro log :

BR0443W File '/dback/behtcosq/btabd.data37.Z' to be restored not found

BR0443W File '/dback/behtcosq/btabd.data38.Z' to be restored not found

BR0443W File '/dback/behtcosq/btabd.data18.Z' to be restored not found

BR0443W File '/dback/behtcosq/btabd.data19.Z' to be restored not found

BR0443W File '/dback/behtcosq/btabd.data20.Z' to be restored not found

BR0443W File '/dback/behtcosq/btabd.data21.Z' to be restored not found

BR0443W File '/dback/behtcosq/btabd.data22.Z' to be restored not found

BR0443W File '/dback/behtcosq/btabd.data23.Z' to be restored not found

BR0443W File '/dback/behtcosq/btabd.data24.Z' to be restored not found

BR0443W File '/dback/behtcosq/btabd.data25.Z' to be restored not found

BR0443W File '/dback/behtcosq/btabd.data26.Z' to be restored not found

BR0443W File '/dback/behtcosq/btabd.data27.Z' to be restored not found

BR0443W File '/dback/behtcosq/btabd.data39.Z' to be restored not found

BR0443W File '/dback/behtcosq/btabd.data40.Z' to be restored not found

BR0443W File '/dback/behtcosq/btabd.data41.Z' to be restored not found

BR0443W File '/dback/behtcosq/btabd.data82.Z' to be restored not found

BR0443W File '/dback/behtcosq/btabd.data83.Z' to be restored not found

BR0443W File '/dback/behtcosq/btabd.data84.Z' to be restored not found

BR0443W File '/dback/behtcosq/btabd.data85.Z' to be restored not found

BR0443W File '/dback/behtcosq/btabd.data86.Z' to be restored not found

BR0443W File '/dback/behtcosq/btabd.data87.Z' to be restored not found

BR0443W File '/dback/behtcosq/btabd.data88.Z' to be restored not found

BR0443W File '/dback/behtcosq/btabd.data89.Z' to be restored not found

BR0443W File '/dback/behtcosq/btabd.data1.Z' to be restored not found

BR0428W File /oracle/T02/mirrlogA/log_g11m2.dbf will be overwritten

BR0428W File /oracle/T02/mirrlogB/log_g12m2.dbf will be overwritten

BR0428W File /oracle/T02/mirrlogA/log_g13m2.dbf will be overwritten

BR0428W File /oracle/T02/mirrlogB/log_g14m2.dbf will be overwritten

BR0280I BRRESTORE time stamp: 2012-02-10 11.09.06

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

BR0280I BRRESTORE time stamp: 2012-02-10 11.09.17

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0417W No files found for restore/verification

BR0406I End of file restore: rehvybui.rsb 2012-02-10 11.09.17

BR0280I BRRESTORE time stamp: 2012-02-10 11.09.17

BR0403I BRRESTORE completed successfully with warnings

Regards,

Santosh

[Former Member]

Hi Santosh,

Is the path /dback/behtcosq/ mounted properly on target server?

Can you look at the permissions for the .Z files in this directory?

Compare the init<SID>.sap of source and target.

Especially uncompress_cmd and compress_cmd

Also, the other parameters in that file like backup_type, backup root directory, archive root directory.

Br,

Venky

Edited by: Venkatesh Pydi on Feb 10, 2012 7:26 AM