Problem with Database backup Post: 302171270

Sponsored Content

Special Forums UNIX and Linux Applications Problem with Database backup Post 302171270 by TaZ on Thursday 28th of February 2008 03:41:23 AM

02-28-2008

Registered User

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..

TaZ

View Public Profile for TaZ

Find all posts by TaZ

9 More Discussions You Might Find Interesting

1. 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

2. 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... #...

3. 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...

4. 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....

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,

6. 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

7. 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...

8. 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...

9. 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...

LEARN ABOUT HPUX

bdb.db0

BDB.DB0(5)							AFS File Reference							BDB.DB0(5)

NAME

       bdb.DB0, bdb.DBSYS1 - Contain the Backup Database and associated log

DESCRIPTION

       The bdb.DB0 file contains the Backup Database, which records configuration information used by the AFS Backup System along with cross-
       indexed records of the tapes created and volumes dumped using the Backup System commands.

       The bdb.DBSYS1 file is a log file in which the Backup Server (buserver process) logs each database operation before performing it. When an
       operation is interrupted, the Backup Server replays the log to complete the operation.

       Both files are in binary format and reside in the /var/lib/openafs/db directory on each database server machine that runs the Backup
       Server.	When the Backup Server starts or restarts on a given machine, it establishes a connection with its peers and verifies that its
       copy of the bdb.DB0 file matches the copy on the other database server machines. If not, the Backup Servers use AFS's distributed database
       technology, Ubik, to distribute to all of the machines the copy of the database with the highest version number.

       Use the commands in the backup suite to administer the Backup Database. It is advisable to create a backup copy of the bdb.DB0 file on tape
       on a regular basis, using the UNIX tar command or another local disk backup utility.

SEE ALSO

       backup(8), backup_savedb(8), buserver(8)

COPYRIGHT

       IBM Corporation 2000. <http://www.ibm.com/> All Rights Reserved.

       This documentation is covered by the IBM Public License Version 1.0.  It was converted from HTML to POD by software written by Chas
       Williams and Russ Allbery, based on work by Alf Wachsmann and Elizabeth Cassell.

OpenAFS 							    2012-03-26								BDB.DB0(5)