on 08-24-2014 11:26 AM
Hi all
We are facing the following error when we are trying to restore our quality SAP server with a offline BRBACKUP (native backup over a tape) taken from a TSM backup facility onto a new server using BRRESTORE using HP Tape Drives.
The weird part is if we are lucky the restore does run after changing the tape drives a number of times. However we end up facing this error more often than ever. The error is the same after using a new tape / new backup for the restore.
Kindly provide any pointers that could help resolve this issue.
BR0405I Start of file restore: reopaxfi.rsb 2014-08-24 17.31.34
BR0484I BRRESTORE log file: /oracle/QXX/sapbackup/reopaxfi.rsb
BR0101I Parameters
Name Value
oracle_sid QXX
oracle_home /oracle/QXX/102_64
oracle_profile /oracle/QXX/102_64/dbs/initQXX.ora
sapdata_home /oracle/QXX
sap_profile /oracle/QXX/102_64/dbs/initQXX.sap.lto
recov_interval 30
restore_mode ALL
backup_dev_type tape
compress hardware
tape_copy_cmd dd
cpio_in_flags -iuvC2048
cpio_disk_flags -pdcu
dd_in_flags ibs=1024k bs=1024k
rewind tctl -f $ rewind
rewind_offline tctl -f $ offline
tape_pos_cmd tctl -f $ fsf $
tape_address /dev/rmt2.1
tape_address_rew /dev/rmt2
exec_parallel 0
system_info oraqxx/oraqxx s128b108 AIX 1 6 00CD75914C00
oracle_info QXX 10.2.0.4.0
make_info rs6000_64 OCI_920 Jan 30 2010
command_line brrestore -m all -c force -b beoovwin.aft -p initQXX.sap.lto -u /
BR0280I BRRESTORE time stamp: 2014-08-24 17.31.34
BR0407I Restore of database: QXX
BR0408I BRRESTORE action ID: reopaxfi
BR0409I BRRESTORE function ID: rsb
BR0449I Restore mode: ALL
BR0419I Files will be restored from backup: beoovwin.aft 2014-08-23 16.57.01
BR0416I 111 files found to restore, total size 383056.672 MB
BR0425I Files will be decompressed by hardware
BR0421I Restore device type: tape
BR0102I Following backup device will be used: /dev/rmt2.1
BR0103I Following backup volume will be used: D20473L4 (2014-08-23 16.57.01)
BR0134I Unattended mode with 'force' active - no operator confirmation allowed
BR0208I Volume with name D20473L4 (2014-08-23 16.57.01) required in device /dev/rmt2.1
BR0280I BRRESTORE time stamp: 2014-08-24 17.31.34
BR0226I Rewinding tape volume in device /dev/rmt2 ...
BR0351I Restoring /oracle/QXX/sapbackup/.tape.hdr0
BR0355I from /dev/rmt2.1 ...
BR0278E Command output of 'LANG=C cd /oracle/QXX/sapbackup && /usr/sap/QXX/SYS/exe/run/brtools -f detach LANG=C cpio -iuvC2048 .tap
Can't read input
If you want to go on, type device/file name when ready
/dev/tty: No such device or address
BR0280I BRRESTORE time stamp: 2014-08-24 17.31.34
BR0279E Return code from 'LANG=C cd /oracle/QXX/sapbackup && /usr/sap/QXX/SYS/exe/run/brtools -f detach LANG=C cpio -iuvC2048 .tape
BR0359E Restore of /oracle/QXX/sapbackup/.tape.hdr0 from /dev/rmt2.1 failed due to previous errors
BR0218E Checking label on volume in device /dev/rmt2.1 failed
BR0236I Perhaps volume initialization with option '-i force' required
BR0406I End of file restore: reopaxfi.rsb 2014-08-24 17.31.34
BR0280I BRRESTORE time stamp: 2014-08-24 17.31.34
BR0404I BRRESTORE terminated with errors
Thanks
SV
Hello,
Based on the provided information, the below issue was encountered:
<====>
BR0278E Command output of 'LANG=C cd /oracle/QXX/sapbackup && /usr/sap/QXX/SYS/exe/run/brtools -f detach LANG=C cpio -iuvC2048 .tap
Can't read input
If you want to go on, type device/file name when ready
/dev/tty: No such device or address
<====>
This indicates problems with the tape device either initialization issue or damaged tape/tape station:
1) The tape was not correctly initialized. In this case initialize it as recommended in SAP note 10664
2) Hardware issue with the tape or tape station. More details in the SAP note 20574
Therefore please check tape and tape device. For more details, please also check SAP note 17163 (section BR0278E).
Regards,
David
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vinodh
1. Where you are going to restore the data target volume ready to use?
2. BR tool restore switch. refer the SAP help link
Restore and Recovery - SAP Database Guide: Oracle - SAP Library
BR
SS
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.