|
|
|
|||||||
| Home | Forums | Register | Rules & FAQ | Members List | Arcade | Search | Today's Posts | Mark Forums Read |
| UNIX and Linux Applications Questions involving software not covered by other forum go here. This includes Databases and Middleware. |
Other UNIX.COM Threads You Might Find Helpful
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Crontab Database Problem | dipakjoshi | UNIX for Advanced & Expert Users | 0 | 04-09-2008 02:13 AM |
| Veritas DataBase Backup | ppass | SUN Solaris | 5 | 06-25-2005 06:27 AM |
| Backup of Product Database | Student37 | UNIX for Dummies Questions & Answers | 2 | 06-05-2005 01:16 PM |
| MYSQL command to take a backup of the database in Redhat linux 7.2 | bache_gowda | UNIX for Advanced & Expert Users | 4 | 01-21-2004 10:16 AM |
| Backup problem---Again | lealyz | UNIX for Advanced & Expert Users | 4 | 06-21-2002 10:35 AM |
 |
|
|
Submit Tools | LinkBack | Thread Tools | Search this Thread | Display Modes |
02-28-2008
|
|||
|
|||
|
Problem with Database backup
Hi! This is my first post and im not that familiar with UNIX but I'll try to explain my problem..
I have a server here at work running Open UNIX Release 8.0.0 It has a special application on it that I'm trying to run a database backup on. For the last 2 weeks this has failed.. Usually the backup takes 1 hour to run but now it failes after 8 hours (often have to reboot the machine in the morning for the users to be able to access the application again) I have the backup log that i can attach but its very large.. And im not sure it will say anything... I have some CPU and Disk activity output for you.. But my question is basicly is there some way i can see what is happening.. What the system is trying to write where? To find out why it failes? The backup has been running for 1h 45min as i write this and it have some heavy disk activity on the c0b0t0d0s1 "slice?" all the time.. Is this /dev/root partition/slice? Code:
07:45:30 %usr %sys %wio %idle %intr 08:00:00 3 4 45 49 0 08:20:00 1 4 95 1 0 08:40:00 1 4 95 1 0 09:00:00 1 4 95 1 0 Average 1 4 85 10 0 filesystem kbytes used avail capacity mounted on /dev/root 460800 291847 168953 64% / /dev/stand 20480 7332 13148 36% /stand /dev/dsk/c0b0t0d0s5 1024000 837202 186798 82% /var /proc 0 0 0 0% /proc /dev/fd 0 0 0 0% /dev/fd /dev/_tcp 0 0 0 0% /dev/_tcp /processorfs 0 0 0 0% /system/processor /dev/dsk/c0b0t0d0s4 204800 83918 120882 41% /home /dev/dsk/c0b0t0d0s6 819200 62788 756412 8% /var/col /dev/dsk/c0b0t0d0s9 819200 52406 766794 7% /SWS /dev/dsk/c0b0t0d0sb 1536000 1344794 191206 88% /opt /dev/dsk/c0b0t0d0sc 614400 115204 499196 19% /.AS/SWS /dev/dsk/c0b0t0d0sd 77188096 5642228 71545868 8% /.AS/BACKUP 09:24:34 device MB %busy avque r+w/s blks/s avwait avserv 09:24:35 c0b0t0d0s1 450 99 1.1 149 386 0.5 6.6 09:24:35 c0b0t0d0s5 1000 31 1.5 13 64 11.5 23.8 09:24:35 c0b0t0d0s11 1500 12 12.7 19 304 73.7 6.3 09:24:35 c0b0t0d0s15 2047 7 1.0 10 164 0.0 7.0 09:24:35 c0b0t0d0 138799 99 3.1 191 918 11.1 5.2 Last edited by TaZ : 02-28-2008 at 01:36 AM. 
|
| Forum Sponsor | ||
|
|
|
02-28-2008
|
|||
|
|||
|
I will attach a logfile from the database backup. A backup is started every night at 02:00 and usally takes 1 hour to complete.
I notice that the days before the backup starts to fail the backup takes longer and longer time. Last successful day before failure it took 6h 20min to complete. Not it gets interupted 10:14 every day if i do not reboot the server before that. (Means it runs 8h 14min and then abort) By the way.. The database is Informix.
|
Linear Mode
