cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Oracle Backup restore failed due to previous errors

Former Member

on ‎02-18-2014 10:52 AM

0 Kudos

Hi Expert,

I have to restore Oracle DB offline backup on test system. While trying to restore with BR tools, it get error BR0359E Restore of E:\ORACLE\SM7\SAPDATA1\SR3_1\SR3.DATA1 from E:\oracle\SM7\sapbackup\bendfive\SR3.DATA1 failed due to previous errors.

OS – Windows

DB – Oracle 11.2


Error -


BR0351I Restoring E:\ORACLE\SM7\SAPDATA1\SR3_1\SR3.DATA1

BR0355I from E:\oracle\SM7\sapbackup\bendfive\SR3.DATA1 ...

BR0278E Command output of 'ocopy E:\oracle\SM7\sapbackup\bendfive\SR3.DATA1 E:\ORACLE\SM7\SAPDATA1\SR3_1\SR3.DATA1':

E:\ORACLE\SM7\SAPDATA1\SR3_1\SR3.DATA1

BR0280I BRRESTORE time stamp: 2014-02-17 18.33.20

BR0279E Return code from 'ocopy E:\oracle\SM7\sapbackup\bendfive\SR3.DATA1 E:\ORACLE\SM7\SAPDATA1\SR3_1\SR3.DATA1': 0

BR0359E Restore of E:\ORACLE\SM7\SAPDATA1\SR3_1\SR3.DATA1 from E:\oracle\SM7\sapbackup\bendfive\SR3.DATA1 failed due to previous errors

BR0406I End of file restore: renfnldp.rsb 2014-02-17 18.33.20

BR0280I BRRESTORE time stamp: 2014-02-17 18.33.20

BR0404I BRRESTORE terminated with errors



===============================================================================

BR0292I Execution of BRRESTORE finished with return code 5

BR0280I BRRECOVER time stamp: 2014-02-17 18.33.20

BR0668I Warnings or errors occurred - you can continue to ignore them or go back to repeat the last action

BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:



Pls Suggest.


Rgds,

Ashok

Show replies
Show replies
Answer

Accepted Solutions (0)

Answers (6)

Answers (6)

Former Member
‎02-18-2014 1:08 PM
0 Kudos

Hi All,

I would like to inform you that the problem has been solve with the changes made in profile init<SID>.sap file as below.

Previously disk_copy_cmd using the ocopy and now it change to copy and it works.

# disk copy command [copy | copy_gnu | dd | dd_gnu | rman | rman_gnu

# | rman_set | rman_set_gnu | ocopy]

# ocopy - only on Windows

# default: copy

#changed from copy to ocopy

disk_copy_cmd = copy

Thanks all for the quick help.

Rgds,

Ashok

Show replies
Show replies
Former Member
‎02-19-2014 4:22 AM
0 Kudos

Hi,

I suggest you to close the thread if your problem is solved/query is answered.

Regards,

Nick Loy

Former Member
‎02-18-2014 12:24 PM
0 Kudos

Hi Sunil,

Here is the log.

BR0401I BRRESTORE 7.20 (34)

BR0405I Start of file restore: renfnldp.rsb 2014-02-17 18.28.09

BR0484I BRRESTORE log file: E:\oracle\SM7\sapbackup\renfnldp.rsb

BR0101I Parameters

Name                           Value

oracle_sid                     SM7

oracle_home                    E:\oracle\SM7\11203

oracle_profile                 E:\oracle\SM7\11203\database\initSM7.ora

sapdata_home                   E:\oracle\SM7

sap_profile                    E:\oracle\SM7\11203\database\initSM7.sap

recov_interval                 30

restore_mode                   1-23,

                               01-04,

                               0

backup_dev_type                disk

compress                       no

disk_copy_cmd                  ocopy

exec_parallel                  0

system_info                    BOMW101A\sm7adm BOMW101A Windows 6.0 Build 6002 Service Pack 2 AMD64

oracle_info                    SM7 11.2.0.3.0

make_info                      NTAMD64 OCI_10201_SHARE Sep 16 2013 720_EXT_REL

command_line                   D:\usr\sap\SM7\DVEBMGS00\exe\brrestore.exe -p initSM7.sap -b bendfive.afd -d disk -m 1-23,01-04,0 -k no -e 0 -l E -i 30

br_env                         JAVA_HOME=D:\usr\sap\SM7\DVEBMGS00\exe\sapjvm_4,

                               NLS_LANG=AMERICAN_AMERICA.UTF8,

                               ORACLE_HOME=E:\oracle\SM7\11203,

                               ORACLE_SID=SM7,

                               RSEC_SSFS_DATAPATH=\\BOMW101A\sapmnt\SM7\SYS\global\security\rsecssfs\data,

                               RSEC_SSFS_KEYPATH=\\BOMW101A/sapmnt/SM7/SYS/global/security/rsecssfs/key,

                               SAPDATA_HOME=E:\oracle\SM7,

                               SAPEXE=D:\usr\sap\SM7\DVEBMGS00\exe,

                               SAPSYSTEMNAME=SM7,

                               TNS_ADMIN=\\BOMW101A\sapmnt\SM7\SYS\profile\oracle

BR0428W File E:\ORACLE\SM7\SAPDATA1\SR3_1\SR3.DATA1 will be overwritten

BR0428W File E:\ORACLE\SM7\SAPDATA2\SR3_2\SR3.DATA2 will be overwritten

BR0428W File E:\ORACLE\SM7\SAPDATA3\SR3_3\SR3.DATA3 will be overwritten

BR0428W File E:\ORACLE\SM7\SAPDATA4\SR3_4\SR3.DATA4 will be overwritten

BR0428W File E:\ORACLE\SM7\SAPDATA4\SR3_5\SR3.DATA5 will be overwritten

BR0428W File E:\ORACLE\SM7\SAPDATA4\SR3_6\SR3.DATA6 will be overwritten

BR0428W File E:\ORACLE\SM7\SAPDATA1\SR3702_1\SR3702.DATA1 will be overwritten

BR0428W File E:\ORACLE\SM7\SAPDATA2\SR3702_2\SR3702.DATA2 will be overwritten

BR0428W File E:\ORACLE\SM7\SAPDATA3\SR3702_3\SR3702.DATA3 will be overwritten

BR0428W File E:\ORACLE\SM7\SAPDATA4\SR3702_4\SR3702.DATA4 will be overwritten

BR0428W File E:\ORACLE\SM7\SAPDATA4\SR3702_5\SR3702.DATA5 will be overwritten

BR0428W File E:\ORACLE\SM7\SAPDATA4\SR3702X_1\SR3702X.DATA1 will be overwritten

BR0428W File E:\ORACLE\SM7\SAPDATA4\SR3702X_2\SR3702X.DATA2 will be overwritten

BR0428W File E:\ORACLE\SM7\SAPDATA4\SR3702X_3\SR3702X.DATA3 will be overwritten

BR0428W File E:\ORACLE\SM7\SAPDATA4\SR3702X_4\SR3702X.DATA4 will be overwritten

BR0428W File E:\ORACLE\SM7\SAPDATA4\SR3702X_5\SR3702X.DATA5 will be overwritten

BR0428W File E:\ORACLE\SM7\SAPDATA4\SR3702X_6\SR3702X.DATA6 will be overwritten

BR0428W File E:\ORACLE\SM7\SAPDATA4\SR3DB_1\SR3DB.DATA1 will be overwritten

BR0428W File E:\ORACLE\SM7\SAPDATA1\SR3USR_1\SR3USR.DATA1 will be overwritten

BR0428W File E:\ORACLE\SM7\SAPDATA1\UNDO_1\UNDO.DATA1 will be overwritten

BR0428W File E:\ORACLE\SM7\SAPDATA1\SYSAUX_1\SYSAUX.DATA1 will be overwritten

BR0428W File E:\ORACLE\SM7\SAPDATA1\SYSTEM_1\SYSTEM.DATA1 will be overwritten

BR0428W File E:\ORACLE\SM7\SAPDATA1\SYSTEM_2\SYSTEM.DATA2 will be overwritten

BR0428W File E:\ORACLE\SM7\ORIGLOGA\LOG_G11M1.DBF will be overwritten

BR0428W File E:\ORACLE\SM7\MIRRLOGA\LOG_G11M2.DBF will be overwritten

BR0428W File E:\ORACLE\SM7\ORIGLOGB\LOG_G12M1.DBF will be overwritten

BR0428W File E:\ORACLE\SM7\MIRRLOGB\LOG_G12M2.DBF will be overwritten

BR0428W File E:\ORACLE\SM7\ORIGLOGA\LOG_G13M1.DBF will be overwritten

BR0428W File E:\ORACLE\SM7\MIRRLOGA\LOG_G13M2.DBF will be overwritten

BR0428W File E:\ORACLE\SM7\ORIGLOGB\LOG_G14M1.DBF will be overwritten

BR0428W File E:\ORACLE\SM7\MIRRLOGB\LOG_G14M2.DBF will be overwritten

BR0428W File E:\oracle\SM7\origlogA\cntrl\cntrlSM7.dbf will be overwritten

BR0428W File E:\oracle\SM7\origlogB\cntrl\cntrlSM7.dbf will be overwritten

BR0428W File E:\oracle\SM7\sapdata1\cntrl\cntrlSM7.dbf will be overwritten

BR0280I BRRESTORE time stamp: 2014-02-17 18.28.09

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

BR0280I BRRESTORE time stamp: 2014-02-17 18.28.52

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0457I Probably the database must be recovered due to partial restore

BR0280I BRRESTORE time stamp: 2014-02-17 18.28.52

BR0407I Restore of database: SM7

BR0408I BRRESTORE action ID: renfnldp

BR0409I BRRESTORE function ID: rsb

BR0449I Restore mode: partial

BR0411I Database files for restore:

E:\ORACLE\SM7\SAPDATA1\SR3_1\SR3.DATA1

E:\ORACLE\SM7\SAPDATA2\SR3_2\SR3.DATA2

E:\ORACLE\SM7\SAPDATA3\SR3_3\SR3.DATA3

E:\ORACLE\SM7\SAPDATA4\SR3_4\SR3.DATA4

E:\ORACLE\SM7\SAPDATA4\SR3_5\SR3.DATA5

E:\ORACLE\SM7\SAPDATA4\SR3_6\SR3.DATA6

E:\ORACLE\SM7\SAPDATA1\SR3702_1\SR3702.DATA1

E:\ORACLE\SM7\SAPDATA2\SR3702_2\SR3702.DATA2

E:\ORACLE\SM7\SAPDATA3\SR3702_3\SR3702.DATA3

E:\ORACLE\SM7\SAPDATA4\SR3702_4\SR3702.DATA4

E:\ORACLE\SM7\SAPDATA4\SR3702_5\SR3702.DATA5

E:\ORACLE\SM7\SAPDATA4\SR3702X_1\SR3702X.DATA1

E:\ORACLE\SM7\SAPDATA4\SR3702X_2\SR3702X.DATA2

E:\ORACLE\SM7\SAPDATA4\SR3702X_3\SR3702X.DATA3

E:\ORACLE\SM7\SAPDATA4\SR3702X_4\SR3702X.DATA4

E:\ORACLE\SM7\SAPDATA4\SR3702X_5\SR3702X.DATA5

E:\ORACLE\SM7\SAPDATA4\SR3702X_6\SR3702X.DATA6

E:\ORACLE\SM7\SAPDATA4\SR3DB_1\SR3DB.DATA1

E:\ORACLE\SM7\SAPDATA1\SR3USR_1\SR3USR.DATA1

E:\ORACLE\SM7\SAPDATA1\UNDO_1\UNDO.DATA1

E:\ORACLE\SM7\SAPDATA1\SYSAUX_1\SYSAUX.DATA1

E:\ORACLE\SM7\SAPDATA1\SYSTEM_1\SYSTEM.DATA1

E:\ORACLE\SM7\SAPDATA1\SYSTEM_2\SYSTEM.DATA2

E:\ORACLE\SM7\ORIGLOGA\LOG_G11M1.DBF

E:\ORACLE\SM7\MIRRLOGA\LOG_G11M2.DBF

E:\ORACLE\SM7\ORIGLOGB\LOG_G12M1.DBF

E:\ORACLE\SM7\MIRRLOGB\LOG_G12M2.DBF

E:\ORACLE\SM7\ORIGLOGA\LOG_G13M1.DBF

E:\ORACLE\SM7\MIRRLOGA\LOG_G13M2.DBF

E:\ORACLE\SM7\ORIGLOGB\LOG_G14M1.DBF

E:\ORACLE\SM7\MIRRLOGB\LOG_G14M2.DBF

E:\oracle\SM7\origlogA\cntrl\cntrlSM7.dbf

E:\oracle\SM7\origlogB\cntrl\cntrlSM7.dbf

E:\oracle\SM7\sapdata1\cntrl\cntrlSM7.dbf

BR0419I Files will be restored from backup: bendfive.afd 2014-02-05 13.05.58

BR0416I 28 files found to restore, total size 140519.510 MB

BR0424I Files will not be decompressed

BR0421I Restore device type: disk

BR0420I Files will be restored from directory: E:\oracle\SM7\sapbackup\bendfive

BR0280I BRRESTORE time stamp: 2014-02-17 18.28.52

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

BR0280I BRRESTORE time stamp: 2014-02-17 18.29.40

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0351I Restoring E:\ORACLE\SM7\SAPDATA1\SR3_1\SR3.DATA1

BR0355I from E:\oracle\SM7\sapbackup\bendfive\SR3.DATA1 ...

BR0278E Command output of 'ocopy E:\oracle\SM7\sapbackup\bendfive\SR3.DATA1 E:\ORACLE\SM7\SAPDATA1\SR3_1\SR3.DATA1':

E:\ORACLE\SM7\SAPDATA1\SR3_1\SR3.DATA1

BR0280I BRRESTORE time stamp: 2014-02-17 18.33.20

BR0279E Return code from 'ocopy E:\oracle\SM7\sapbackup\bendfive\SR3.DATA1 E:\ORACLE\SM7\SAPDATA1\SR3_1\SR3.DATA1': 0

BR0359E Restore of E:\ORACLE\SM7\SAPDATA1\SR3_1\SR3.DATA1 from E:\oracle\SM7\sapbackup\bendfive\SR3.DATA1 failed due to previous errors

BR0406I End of file restore: renfnldp.rsb 2014-02-17 18.33.20

BR0280I BRRESTORE time stamp: 2014-02-17 18.33.20

BR0404I BRRESTORE terminated with errors

Rgds,

Ashok

Show replies
Show replies
former_member188883
Active Contributor
‎02-18-2014 12:33 PM
0 Kudos

Hi Ashok,

BR0279E Return code from 'ocopy E:\oracle\SM7\sapbackup\bendfive\SR3.DATA1 E:\ORACLE\SM7\SAPDATA1\SR3_1\SR3.DATA1': 0

Please check whether backup files are located in the location specified above and it has read permission to "everyone"

Regards,

Deepak Kori

Sriram2009
Active Contributor
‎02-18-2014 11:12 AM
0 Kudos

Hi Ashok

Kindly refer the SAP Note 17163 - BRARCHIVE/BRBACKUP messages and codes

Regards

Ram

Show replies
Show replies
former_member182657
Active Contributor
‎02-18-2014 11:11 AM
0 Kudos

Hi,

Is your database backup reside on the disk as from logs you are restoring backup from E:\ drive .Is m right.Also share options which you followed during brrestore procedure.

What happens if you provide direct brrestore -m full -b bendfive.anf


Thanks,

Gaurav

Show replies
Show replies
Former Member
‎02-18-2014 10:56 AM
0 Kudos

Hi,

Return code 5 is related to backup device/media.

Contact your vendor for support.

Regards,

Nick Loy

Show replies
Show replies
Former Member
‎02-18-2014 10:53 AM
0 Kudos

please attach  renfnldp.rsb log file

Show replies
Show replies
Ask a Question