LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices


Reply
  Search this Thread
Old 02-12-2008, 07:09 AM   #1
joeldhanaraj
LQ Newbie
 
Registered: Feb 2008
Posts: 2

Rep: Reputation: 0
Question Backup on tape


Dear All,

we are running SAP on suseLinux and db2 database

When we try to take a backup on tape , it throws the following error

"SQL2025N An I/O error "124" occurred on media "/dev/st0"."

UTOPDEVL:db2utd 41> db2 backup db UTD to /dev/st0
SQL2031W Warning! Please mount the target or source media on device
"/dev/st0".
Do you want to continue(c), terminate this device only(d), abort the utility(t) ? (c/d/t) c
SQL2025N An I/O error "124" occurred on media "/dev/st0".

UTOPDEVL:/dev # ls -l st0
crw-rw---- 1 db2utd disk 9, 0 Feb 11 20:34 st0
UTOPDEVL:/dev # mt -f /dev/st0 status
drive type = Generic SCSI-2 tape
drive status = 1140850688
sense key error = 0
residue count = 0
file number = 0
block number = 0
Tape block size 0 bytes. Density code 0x44 (unknown).
Soft error count since last status=0
General status bits on (41010000):
BOT ONLINE IM_REP_EN


Please give some valuable inputs to the fix the same

Regards

Joe.
 
Old 02-12-2008, 10:47 AM   #2
trashbird1240
Member
 
Registered: Sep 2006
Location: Durham, NC
Distribution: Slackware, Ubuntu (yes, both)
Posts: 463

Rep: Reputation: 31
When you use what to do the backup? What software?

Joel
 
Old 02-13-2008, 12:47 AM   #3
joeldhanaraj
LQ Newbie
 
Registered: Feb 2008
Posts: 2

Original Poster
Rep: Reputation: 0
Quote:
Originally Posted by trashbird1240 View Post
When you use what to do the backup? What software?

Joel


its a SAP utility to do the backup.
 
Old 02-13-2008, 02:02 AM   #4
Disillusionist
Senior Member
 
Registered: Aug 2004
Location: England
Distribution: Ubuntu
Posts: 1,039

Rep: Reputation: 97
Not sure about SAP but I know that Oracle backup utility RMAN cannot backup directly to tape without third party software handling the tape device.

It might be worth ensuring that your utility is capable of writing directly to tape.

If the utility is supposed to write to tape but it's not working, it might be worth running some tests with simple tar commands to ensure that there isn't a hardware issue with the tape unit.
 
Old 02-13-2008, 08:47 AM   #5
sundialsvcs
LQ Guru
 
Registered: Feb 2004
Location: SE Tennessee, USA
Distribution: Gentoo, LFS
Posts: 9,078
Blog Entries: 4

Rep: Reputation: 3179Reputation: 3179Reputation: 3179Reputation: 3179Reputation: 3179Reputation: 3179Reputation: 3179Reputation: 3179Reputation: 3179Reputation: 3179Reputation: 3179
It also might be more practical to back-up to disk.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to backup more than one time on same tape using DLT tape? hocheetiong Linux - Newbie 3 01-30-2008 06:54 AM
Using a DDS5 tape drive to restore from a DDS3 backup tape. AndrewCAtWayofthebit Linux - Hardware 1 05-14-2006 09:15 AM
Tape incremental backup to different tape tungaw2001 Linux - Software 0 08-13-2003 09:42 PM
Tape Backup Falieson Linux - Hardware 4 06-12-2003 08:07 PM
Which Tape backup? biggiefatts Linux - Hardware 4 02-19-2003 03:21 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Server

All times are GMT -5. The time now is 07:52 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration