database image size


 
Thread Tools Search this Thread
Operating Systems Solaris database image size
# 1  
Old 05-16-2005
database image size

hi ,

we are using Veritas netbackup 5 to backup all databases at our site.
i noticed lately that a specific filesystem on the netbackup servers in running critically out of space , after some investigations i found that there are images that are increasing in size everytime a backup is taken .
the images are found under "/opt/openv/netbackup/db/images" .
my question is :
1 - Is it safe to delete these database images .
2 - these images are used for what .

please note :that we are running solaris 8 over sparc .

thanks for ur help
cheers
# 2  
Old 05-22-2005
Late Answer:

NetBackup stores all information from Backups in its Database.
It records the client,the file being backuped, the Tape that was used,...
Every new backup /restore will store infos to this database.
VERITAS recommends to install NetBackup and the Backup Catalog on a growable Filesystem like Veritas Filesystem.

What you can do:

x) Backup the complete NetBackup Server, plug in a bigger hard disk,
re-install the OS, install NetBackup and restore from Tape

Or:

x) Assuming you have 1 disk:

Insert a second disk to your server, create a Filesystem, and tell NetBackup
to backup the DB/Catalog to the new disk/mountpoint. Manually initate a DB/Catalog Backup to the new location. Then tell netbackup to use this disk a the primary source for the DB/Catalog. Now all Database data is on the new,bigger disk
# 3  
Old 05-24-2005
thanks networkr@k

i got what u said ; but i was wondering if u could tell me the steps to "initate a DB/Catalog Backup to the new location" .

10 x cheers
# 4  
Old 05-26-2005
@ppass:

I will test it for you on monday at work...
I will move the catalog/db to a new disk and will post the necessary tasks and results.

My test setup:

x) NetBackup 4.5 FP6 running on Solaris 9 SPARC (E250)

x) Master and Media Server on the same machine

I will manually shrink the filesystem to run in your problem of to less space.
# 5  
Old 05-26-2005
just curious ... why not just move the directory to a bigger filesystem and keep the same path either by sym-linking or by mounting?
# 6  
Old 05-30-2005
Just Ice :

this is a good suggestion but the file system that the image currently is mounted is / .

i only have 2 80 GB hardisks that are mirrored ,so maybe making a simlink would work but i can not see how i can mount it to another file system .
please note that in the hardisk there are no more free spcace , all space are mounted and partitioned .
cheers

Last edited by ppass; 05-30-2005 at 06:16 AM..
# 7  
Old 05-31-2005
if you have space in another filesystem and you only want to use it for the database in question, mount that filesystem into /mnt and then copy the database over into it, diff the copy and the source and then remove the source, and then umount the filesystem on /mnt and remount it on /opt/openv/netbackup/db/images ... make sure you update /etc/vfstab ...

if you don't want to do through all that trouble, create a new directory in a bigger filesystem, move the database to it, and then make /opt/openv/netbackup/db/images a symlink to it ...

... do verify that netbackup will work with symlinked paths before you thrash your server data ...
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Programming

[xlib] Image has just 1/4 size

Hello, i'm trying to show the Image of an monochrome webcam in an xlib-Window. initializing of the window: if (NULL == ((*XWindow)->display = XOpenDisplay(NULL))) APPLICATION_Set_Error(V4LCamera->Application, XWINDOW, "failed to open display", 123, -1, APPLICATION_ERROR_MESSAGE); ... (1 Reply)
Discussion started by: mirrowwinger
1 Replies

2. UNIX for Dummies Questions & Answers

Help with Database size script

Hello, I'm not very good at scripting as my job is an DBA for a small firm, but now I'd like to implement a few cron jobs which access and report on the databases on an automatic basis. This is my SQL TEXT # -- Total size of Database Size in GB set echo off feedback off verify off... (4 Replies)
Discussion started by: jnrpeardba
4 Replies

3. Shell Programming and Scripting

Help with Database size script

Hello, I'm not very good at scripting as my job is an DBA for a small firm, but now I'd like to implement a few cron jobs which access and report on the databases on an automatic basis. This is my SQL TEXT # -- Total size of Database Size in GB set echo off feedback off verify off pause... (2 Replies)
Discussion started by: jnrpeardba
2 Replies

4. Shell Programming and Scripting

perl Image::size function

Hi, How to use Image::size function ? because I want to list all image thatare less than size pixels in horizontal resolution. so here is my code : #!/usr/bin/perl -w use Image::Size; use constant GIVEN_WIDTH = '100'; my @filtered_images = grep { my @d = imgsize( $_ ); $d < GIVEN_WIDTH }... (8 Replies)
Discussion started by: guidely
8 Replies

5. UNIX and Linux Applications

Database Size

Can anybody tell me how to look for the size of the database on the solariis servers. I am using Solaris 5.6 and Solaris 1.1.1 Any help will be appreciated.................. (1 Reply)
Discussion started by: asalman.qazi
1 Replies

6. UNIX for Dummies Questions & Answers

find the size of a database by counting all the used pages

Hi all, I am looking to find the size of the database by counting all the used pages. 1. I have a file which reads like below 16384 4750850 32768 165 The first column is the pagesize and the second column is the number of pages... (6 Replies)
Discussion started by: family_guy
6 Replies

7. HP-UX

know the size of database

Hi all , How to know the size of a oracle database running in hp-ux server. (1 Reply)
Discussion started by: megh
1 Replies

8. UNIX for Dummies Questions & Answers

Add Image Size (W-H) to a UNIX statement

I am using a counter on Comcast and I have it working OK. What I need to do is to add the width and height of 'counter.gif'. Below is the statement I am using: &richportal is the counter name on the Comcast Server. EX: w=10px h=10px <img src="/cgi-bin/counter.gif?&richportal"> Thanks: Barry (0 Replies)
Discussion started by: barrie
0 Replies

9. UNIX for Advanced & Expert Users

how to figure out the size in MB for an informix database

This is the info i have so far. please if you are dead positive can u let me know if i my math/process is correct. Chunks address chk/dbs offset size free bpages flags pathname 5003e1f8 1 1 0 250000 177177 PO- /database/link_cw_p01_rootdbs 5003e494 2 ... (5 Replies)
Discussion started by: Optimus_P
5 Replies
Login or Register to Ask a Question