Login or Register to Ask a Question and Join Our Community


UNIX and Linux Applications

Problem with Database backup

 
Thread Tools Search this Thread
Special Forums UNIX and Linux Applications Problem with Database backup
Prev   Next
# 1  
Old 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 05:36 AM..
 
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Cold Backup of Oracle database.

Hi i need a command to cut the last column from the location in a file and want write a gzip command like cat a.txt /data01/oracle/oradata/vas/data/system01.dbf /data01/oracle/oradata/vas/data/sysaux01.dbf /data01/oracle/oradata/vas/data/undotbs01.dbf... (3 Replies)
Discussion started by: javeedkaleem
3 Replies

2. Shell Programming and Scripting

Problem with backup and copy a database

Hi, I have many servers distributed on my customer locations all servers has MYSQL database. I want to backup database for each server on server at my location using scheduler. So I create Shell script file to backup and copy the database file from customer server to my server as... (3 Replies)
Discussion started by: amsbas
3 Replies

3. Shell Programming and Scripting

Help with database backup script

Hi, i am very new with linux shell script. my colleague gave a portion of this script, it backups all of your database and there is a option that selects a database that u do not want to include in your backup. what i want is the other way around, i want to select the databases that i only want... (3 Replies)
Discussion started by: makoyski
3 Replies

4. Shell Programming and Scripting

script for backup database

Hello sir, i have used this for taking the database backup 5 * * * * \usr\bin\sh\mysqldump -h localhost -u username-ppassword cms> /home/dbbackup.sql. but it creates a zero size database and in mail it gives error like command not found. Please Help me (3 Replies)
Discussion started by: niva
3 Replies

5. Shell Programming and Scripting

Create database using Backup file

Hi, I have backup file of database in my server. I want to create a that database in the same Mysql Server. How can I do that? Please send the steps to create the database using backup file? Thanks a lot, (1 Reply)
Discussion started by: aish11
1 Replies

6. Shell Programming and Scripting

How to backup a particular Database in MYSQL?

Hi All, Thanks in Advance!! How to backup a particular Databases..through Bash script!! For example i have 6 databases; Anish linux Software Questions Rhce Google these are the databases i have from that i want to take "Anish" and "questions" database backup regularly.... (4 Replies)
Discussion started by: anishkumarv
4 Replies

7. Solaris

Veritas DataBase Backup

hi , we have a monthly policy for database backups . the database is a huge one about 200 GB in size and every month , we shut down the database and take a full system backup . my question is : Is there a way to know that i have taken a valid backup, I need to do something like a test restore... (5 Replies)
Discussion started by: ppass
5 Replies

8. UNIX for Dummies Questions & Answers

Backup of Product Database

HI, I know its scarey me asking this, but system is homegrown and I am just having fun, but at the same time dont want to have tooo much fun where the phrase "little knowledge is dangerous" perfectly fits my actions ;-). I have a couple of packages that are failing to be removed... #... (2 Replies)
Discussion started by: Student37
2 Replies

9. UNIX for Advanced & Expert Users

MYSQL command to take a backup of the database in Redhat linux 7.2

I am new to mysql database , we have a mysql database running on linux , and we use mysql database for bugzilla, so we wanted to take a backup . what is the command for taking the entire database backup from the command prompt with all options. Thanks in advance Bache Gowda (4 Replies)
Discussion started by: bache_gowda
4 Replies
Login or Register to Ask a Question