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: 

brrestore failed at rewinding tape volume

Former Member

on ‎03-04-2015 5:11 AM

0 Kudos

Hi expert We are doing activity of "Brrestore" on aix system with oracle db. We took online backup of PRD on tape /rmt1.1 Then going to restore same on sandbox system. Before 20 days ago we did same activity with offline db backup of prd. Now we are doing online backup of prd to present sandbox system (overwrite on presentt sanbox db file) We attaché tape (prd backup) to sandbox system Sandbox tape ; /rmt0.1 PRD backup tape:  /rmt1.1 Same os and db version of PRD and SND I changed sid (prd to snd) of file :bepzaykb.fnt (location: /oracle/snd/sapbackup) and run following command: > brrestore -b bepzaykb.fnt -m full followind is the full details of command and error: iccsnd:orasnd 2> brrestore -b bepzaykb.fnt -m full BR0401I BRRESTORE 7.20 (1) BR0405I Start of file restore: repzkbmx.rsb 2015-03-04 21.31.55 BR0484I BRRESTORE log file: /oracle/SND/sapbackup/repzkbmx.rsb BR0428W File /oracle/SND/sapdata2/sr3_33/sr3.data33 will be overwritten BR0428W File /oracle/SND/sapdata3/sr3_20/sr3.data20 will be overwritten BR0428W File /oracle/SND/sapdata2/sr3_31/sr3.data31 will be overwritten BR0428W File /oracle/SND/sapdata2/sr3_30/sr3.data30 will be overwritten BR0428W File /oracle/SND/sapdata3/sr3_29/sr3.data29 will be overwritten BR0428W File /oracle/SND/sapdata3/sr3_28/sr3.data28 will be overwritten BR0428W File /oracle/SND/sapdata3/sr3_27/sr3.data27 will be overwritten BR0428W File /oracle/SND/sapdata3/sr3_26/sr3.data26 will be overwritten BR0428W File /oracle/SND/sapdata3/sr3_25/sr3.data25 will be overwritten BR0428W File /oracle/SND/sapdata3/sr3_24/sr3.data24 will be overwritten BR0428W File /oracle/SND/sapdata3/sr3_23/sr3.data23 will be overwritten BR0428W File /oracle/SND/sapdata3/sr3_22/sr3.data22 will be overwritten BR0428W File /oracle/SND/sapdata3/sr3_21/sr3.data21 will be overwritten BR0428W File /oracle/SND/sapdata2/sr3_11/sr3.data11 will be overwritten BR0428W File /oracle/SND/sapdata2/sr3_12/sr3.data12 will be overwritten BR0428W File /oracle/SND/sapdata2/sr3_13/sr3.data13 will be overwritten BR0428W File /oracle/SND/sapdata2/sr3_14/sr3.data14 will be overwritten BR0428W File /oracle/SND/sapdata2/sr3_15/sr3.data15 will be overwritten BR0428W File /oracle/SND/sapdata2/sr3_16/sr3.data16 will be overwritten BR0428W File /oracle/SND/sapdata4/sr3_38/sr3.data38 will be overwritten BR0428W File /oracle/SND/sapdata4/sr3_37/sr3.data37 will be overwritten BR0428W File /oracle/SND/sapdata4/sr3_36/sr3.data36 will be overwritten BR0428W File /oracle/SND/sapdata2/sr3_1/sr3.data1 will be overwritten BR0428W File /oracle/SND/sapdata2/sr3_2/sr3.data2 will be overwritten BR0428W File /oracle/SND/sapdata2/sr3_3/sr3.data3 will be overwritten BR0428W File /oracle/SND/sapdata2/sr3_4/sr3.data4 will be overwritten BR0428W File /oracle/SND/sapdata2/sr3_5/sr3.data5 will be overwritten BR0428W File /oracle/SND/sapdata2/sr3_6/sr3.data6 will be overwritten BR0428W File /oracle/SND/sapdata4/sr3_35/sr3.data35 will be overwritten BR0428W File /oracle/SND/sapdata2/sr3_7/sr3.data7 will be overwritten BR0428W File /oracle/SND/sapdata2/sr3_8/sr3.data8 will be overwritten BR0428W File /oracle/SND/sapdata2/sr3_9/sr3.data9 will be overwritten BR0428W File /oracle/SND/sapdata2/sr3_10/sr3.data10 will be overwritten BR0428W File /oracle/SND/sapdata4/sr3_34/sr3.data34 will be overwritten BR0428W File /oracle/SND/sapdata3/sr3_17/sr3.data17 will be overwritten BR0428W File /oracle/SND/sapdata3/sr3_18/sr3.data18 will be overwritten BR0428W File /oracle/SND/sapdata3/sr3_19/sr3.data19 will be overwritten BR0428W File /oracle/SND/sapdata2/sr3_32/sr3.data32 will be overwritten BR0428W File /oracle/SND/sapdata3/sr3702_14/sr3702.data14 will be overwritten BR0428W File /oracle/SND/sapdata3/sr3702_13/sr3702.data13 will be overwritten BR0428W File /oracle/SND/sapdata3/sr3702_12/sr3702.data12 will be overwritten BR0428W File /oracle/SND/sapdata3/sr3702_11/sr3702.data11 will be overwritten BR0428W File /oracle/SND/sapdata3/sr3702_9/sr3702.data9 will be overwritten BR0428W File /oracle/SND/sapdata3/sr3702_8/sr3702.data8 will be overwritten BR0428W File /oracle/SND/sapdata3/sr3702_7/sr3702.data7 will be overwritten BR0428W File /oracle/SND/sapdata3/sr3702_6/sr3702.data6 will be overwritten BR0428W File /oracle/SND/sapdata3/sr3702_5/sr3702.data5 will be overwritten BR0428W File /oracle/SND/sapdata3/sr3702_4/sr3702.data4 will be overwritten BR0428W File /oracle/SND/sapdata3/sr3702_3/sr3702.data3 will be overwritten BR0428W File /oracle/SND/sapdata3/sr3702_2/sr3702.data2 will be overwritten BR0428W File /oracle/SND/sapdata3/sr3702_1/sr3702.data1 will be overwritten BR0428W File /oracle/SND/sapdata3/sr3702_10/sr3702.data10 will be overwritten BR0428W File /oracle/SND/sapdata4/sr3usr_1/sr3usr.data1 will be overwritten BR0428W File /oracle/SND/sapdata1/undo_1/undo.data1 will be overwritten BR0428W File /oracle/SND/sapdata1/sysaux_1/sysaux.data1 will be overwritten BR0428W File /oracle/SND/sapdata1/system_1/system.data1 will be overwritten BR0428W File /oracle/SND/origlogA/cntrl/cntrlSND.dbf will be overwritten BR0428W File /oracle/SND/origlogB/cntrl/cntrlSND.dbf will be overwritten BR0428W File /oracle/SND/sapdata1/cntrl/cntrlSND.dbf will be overwritten BR0280I BRRESTORE time stamp: 2015-03-04 21.31.55 BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRRESTORE: c BR0280I BRRESTORE time stamp: 2015-03-04 21.31.57 BR0257I Your reply: 'c' BR0259I Program execution will be continued... BR0456I Probably the database must be recovered due to restore from online backup BR0280I BRRESTORE time stamp: 2015-03-04 21.31.57 BR0407I Restore of database: SND BR0408I BRRESTORE action ID: repzkbmx BR0409I BRRESTORE function ID: rsb BR0449I Restore mode: FULL BR0411I Database files for restore: /oracle/SND/origlogA/cntrl/cntrlSND.dbf /oracle/SND/origlogB/cntrl/cntrlSND.dbf /oracle/SND/sapdata1/cntrl/cntrlSND.dbf BR0419I Files will be restored from backup: bepzaykb.fnt 2015-03-03 01.00.29 BR0416I 57 files found to restore, total size 434738.516 MB BR0424I Files will not be decompressed BR0421I Restore device type: tape BR0102I Following backup device will be used: /dev/rmt1.1 BR0103I Following backup volume will be used: SNDB25 (2015-03-03 01.00.29) BR0280I BRRESTORE time stamp: 2015-03-04 21.31.57 BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRRESTORE: c BR0280I BRRESTORE time stamp: 2015-03-04 21.32.17 BR0257I Your reply: 'c' BR0259I Program execution will be continued... BR0208I Volume with name SNDB25 (2015-03-03 01.00.29) required in device /dev/rmt1.1 BR0210I Please mount BRBACKUP volume, if you have not already done so BR0280I BRRESTORE time stamp: 2015-03-04 21.32.17 BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRRESTORE: c BR0280I BRRESTORE time stamp: 2015-03-04 21.32.34 BR0257I Your reply: 'c' BR0259I Program execution will be continued... BR0280I BRRESTORE time stamp: 2015-03-04 21.32.34 BR0226I Rewinding tape volume in device /dev/rmt1 ... BR0278W Command output of 'LANG=C tctl -f /dev/rmt1 rewind': /dev/rmt1: Device not ready BR0280I BRRESTORE time stamp: 2015-03-04 21.34.49 BR0279W Return code from 'LANG=C tctl -f /dev/rmt1 rewind': 2 BR0213W Winding tape volume in device /dev/rmt1.1 failed BR0212I Please check the volume or the device BR0280I BRRESTORE time stamp: 2015-03-04 21.34.49 BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRRESTORE:                                                                                                                                                                 Kindyl help me to resolve issue Regards, dev

Show replies
Show replies
Answer

Accepted Solutions (0)

Answers (7)

Answers (7)

Former Member
‎03-11-2015 7:45 AM
0 Kudos

Hi,

I want to copy prd oraarch files in sndbox system.

files present in tape /dev/rmt1 and need to copy into /dev/rmt0

How to copy files using aix command from putty.

Show replies
Show replies
former_member182657
Active Contributor
‎03-11-2015 7:53 AM
0 Kudos

Hi,

Is your previous issue resolved ? Please confirm

Also you could refer SCN doc at 

Regards,

Former Member
‎03-11-2015 9:40 AM
0 Kudos

Hi gaurav,

Brrestore issue solved by modifying ".fnt" file with proper sid (last time I changed all sid in file which not work).

Now I am going to copy oraarch files which is present in tape /dev/rmt1.1 and need to copy in tape /dev/rmt0

AIX 6.1

please suggest proper command

former_member182657
Active Contributor
‎03-11-2015 9:45 AM
0 Kudos

Dear Devendra,

I would suggest you to kindly close this thread first & open a new discussion for new issues to support you well.

Good luck !!

Former Member
‎03-04-2015 12:19 PM
0 Kudos

Hi,

While taking the backup volume label is used as ICPB25.

Now I changed it to SNDB25 from command...."brbackup -i -v SNDB25

but now it showing as wrong date error.

how to change volume with proper date or is it possible to jump restore without label initialize

??

Show replies
Show replies
former_member182657
Active Contributor
‎03-04-2015 10:06 AM
0 Kudos

Hi,

Here you need to specify correct volume to restore the backup.Kindly refer SAP Note  17163 - BRARCHIVE/BRBACKUP messages and codes

& can consider below from same



BR0216W Wrong volume %s in device %s, should be %s


BR0216W Falscher Datentraeger %s in Geraet %s, sollte %s sein.


BR0216E Wrong volume %s in device %s, should be %s


BR0216E Falscher Datentraeger %s in Geraet %s, sollte %s sein.


Explanation:  You inserted an incorrect volume in the backup device. The volume name was determined automatically. The program requires that you accept this proposal.


Program reaction:  Waits for the user to insert the correct volume (BR0216W) or processing to terminate (BR0216E).


User action:  Insert the correct volume and continue the operation or repeat the processing.

Regards,

Gaurav

Show replies
Show replies
Former Member
‎03-04-2015 10:54 AM
0 Kudos

Hi,

Right now I am facing issue with change the volume of tape.

brbackup -q prompt error ora 01017 invalid username or password

Former Member
‎03-04-2015 11:11 AM
0 Kudos

IHi,

I am trying to change volume name from brtools ... addional functionality

it prompt for error as :

Locked period for volume ICPB25 in device /dev/rmt1.1 not expirted.

thus not able to rename volume

How to do this

former_member207186
Contributor
‎03-04-2015 11:26 AM
0 Kudos

Hi,

Regarding the "invalid username/password" issue, please check carefully the below SAP KBA for troubleshooting 1576837 - "ORA-01017: invalid username/password".

The "Lock period not expired" message indicates that the volume inserted in the device is still physically locked. As outlined in SAP Note 17163 -"BRARCHIVE/BRBACKUP messages and codes" (section BR0217W and BR0217E) please ensure that expiration period is configured correctly.

Regards,

Bíborka

Former Member
‎03-04-2015 11:31 AM
0 Kudos

Hi,

I changed expired date as 0

Volume name changed successfully

but now brrestore showing new error as:

"Wrong creation data 2000-01-01 00.00.00 for volume SNDB25 in device /dev/rmt1.1

How to resolve it?

former_member207186
Contributor
‎03-04-2015 11:43 AM
0 Kudos

Hi,

This indicates that the creation date in the label is wrong, the volume was not described during the backup that you want to use for restore. As outlined in SAP Note 17163 -"BRARCHIVE/BRBACKUP messages and codes"  please ensure that the correct volume is inserted and repeat the process with a correct volume.

Regards,

Bíborka

former_member182657
Active Contributor
‎03-04-2015 9:18 AM
0 Kudos 


Is I need to stop sap as well as oracle db for restoration?

Restart only hardware here,no need to stop DB as well as SAP.

Show replies
Show replies
Former Member
‎03-04-2015 9:46 AM
0 Kudos

Hi Gaurav,

I checked with IT team.

Now issue resolve with command :" tctl -f /dev/rmt1 rewind"

After executing command "brrestore -b bepzaykb.fnt -m full"

following error occurs

Wrong volume ICPB25 found in device /dev/rmt1.1, expected SNDB25

How to rename tape volume to SNDB25

Former Member
‎03-04-2015 9:50 AM
0 Kudos 


How to rename tape volume to SNDB25

as mentioned earlier you cant change/rename the tape volume, please insert the correct volume in the tape drive. you can check the tape drive volume by using 'brtools -q' command.

former_member182657
Active Contributor
‎03-04-2015 9:53 AM
0 Kudos

Hi Devendra,



Now issue resolve with command :" tctl -f /dev/rmt1 rewind"

Is restart of tape drive hardware did magic for you ?



Wrong volume ICPB25 found in device /dev/rmt1.1, expected SNDB25

You may need to re mount the tape or re label the same.

Regards,

former_member207186
Contributor
‎03-04-2015 10:08 AM
0 Kudos

Hi,

The "Wrong volume found in device" indicates, that an incorrect volume is inserted in the device. As outlined in SAP Note 17163 -"BRARCHIVE/BRBACKUP messages and codes" please ensure that the correct volume is inserted.

Regards,

Bíborka

Former Member
‎03-04-2015 10:38 AM
0 Kudos

hi sunil, I am getting following error when I execute command brbackup -q brbackup -q BR0051I BRBACKUP 7.20 (1) BR0055I Start of database backup: bepzlhat.qub 2015-03-05 03.27.11 BR0484I BRBACKUP log file: /oracle/SND/sapbackup/bepzlhat.qub BR0280I BRBACKUP time stamp: 2015-03-05 03.27.11 BR0301E SQL error -1017 at location BrDbConnect-2, SQL statement: 'CONNECT system/*******' ORA-01017: invalid username/password; logon denied BR0310E Connect to database instance SND failed BR0280I BRBACKUP time stamp: 2015-03-05 03.27.12 BR0301E SQL error -1017 at location BrDbConnect-2, SQL statement: 'CONNECT system/*******' ORA-01017: invalid username/password; logon denied BR0310E Connect to database instance SND failed BR0056I End of database backup: bepzlhat.qub 2015-03-05 03.27.11 BR0280I BRBACKUP time stamp: 2015-03-05 03.27.12 BR0054I BRBACKUP terminated with errors .. ... I unlock ora user account..but still it showing same error

Former Member
‎03-04-2015 9:05 AM
0 Kudos

Hi gaurav,

Is I need to change initSND.sap file?

I execute command tctl -f /dev/rmt1 rewind

waiting for result.

is I need to take copy of file initPRD.sap to snd system?

Show replies
Show replies
Former Member
‎03-04-2015 9:07 AM
0 Kudos

Hi ,

tctl -f /dev/rmt1 rewind ....result:

/dev/rmt1: The device not ready for operation

Is I need to stop sap as well as oracle db for restoration?

former_member182657
Active Contributor
‎03-04-2015 9:13 AM
0 Kudos

Hi,



Is I need to change initSND.sap file?

No need to modify initSND.sap file here,as issue is not related with the specified file.



I execute command tctl -f /dev/rmt1 rewind


waiting for result.

If output is still under process to give us results,than surely you need to consult with hardware vendor here or need support from Hardware team at your end.

You could try a workaround by restarting the tape drive here & can re check with same command.



is I need to take copy of file initPRD.sap to snd system?

Restore doesn't requires to replace or copy of init<SID>.sap into the systems.

Regards,

Gaurav

former_member182657
Active Contributor
‎03-04-2015 8:50 AM
0 Kudos

Hi,



Device not ready BR0280I BRRESTORE time stamp: 2015-03-04 21.34.49 BR0279W Return code from 'LANG=C tctl -f /dev/rmt1 rewind': 2 BR0213W Winding tape volume in device /dev/rmt1.1 failed BR0212I Please check the volume or the device BR0280I BRRESTORE

I suggest you to locate any issues at tape drive end,seems drive not ready here.If possible try to use some other tape to take backup on it instead of SNDB25.

Additionally follow SAP Note  104719 - NT: Problems with MT.EXE (BRBackup error: mt: ...)

Regards,

Gaurav

Show replies
Show replies
Former Member
‎03-04-2015 8:54 AM
0 Kudos

I am doing activity of BRrestore (prd to snd)

PRD online backup has been taken on tape and same tape attached to SND server.

Now restoring PRD data on SND

former_member182657
Active Contributor
‎03-04-2015 8:57 AM
0 Kudos

Could you share result for command

tctl -f /dev/rmt1 rewind

Former Member
‎03-04-2015 9:07 AM
0 Kudos

please insert tape labelled SNDB25 in rmt0.

you can check the tape 'brbackup -q' command.

Former Member
‎03-04-2015 8:31 AM
0 Kudos

make sure you attach the log file and not copy/paste. This is bit difficult to read the log as text format.

please check you have SNDB25 tape volume in the tape drive.

Show replies
Show replies
Former Member
‎03-04-2015 8:49 AM
0 Kudos

Thanks sunil for reply,

when I execute command "lsdev -Cc tape" it shows following details;:

rmt0 available

rmt1 available

**rmt0 is sandbox tape and rmt1 is prd online backup tape

which tape name should change as SNDB25

how to check volume of tape via aix command and how to rename it as SNDB25.

I copies .fnt file of prd to sandbox path /oracle/snd/sapbackup... and change into file sid of prd as SND

find the attachment of error log

Regards,

devk

Message was edited by: Devendra Sapbasis

br_error.txt.zip
Ask a Question