How to take backup if database size is 7 gb and 4gb and we do not have enough space in disk.

Mike

Mike

Moderator
Dear all,
I have 4gb and 7gb database and and i have file system is less then 7 gb .Pleas e help me how to take backup according to my dabase size :-

1 . 7gb database size
2 4 gb database size


unix flavour AIX

file system space showing only 7 gb left.

/data/data1 7gb

can i use -vs command ?

i do not know how to use for 7 gb and 4gb database . please help its urgent.
 
no i did not add disk. Dear Tamhas my question is for 7 gb and 4 gb database how can i define -vs parameter? please help me sir.

Only 7 gb file system space left . Please help me its bit urgent.

With regards

Mike
 
The -vs parameter is not a parameter I would recommend using. We use it and it causes all sorts of problems and nightmares. I want to get us away from using it.
You don't have to back up to the same drive as the database resides on. You can backup anywhere, even over the network to a different machine if you have the permissions. You'd be much better off doing that, even it it's slower, than using the -vs parameter.
More importantly, learn from this. You should never, ever, ever get a situation where you have that little disk available. 7GB is nothing these days.
 
no i did not add disk. Dear Tamhas my question is for 7 gb and 4 gb database how can i define -vs parameter? please help me sir.

Only 7 gb file system space left . Please help me its bit urgent.

With regards

Mike
 
I was suggesting that the solution was to add more disk. Somewhere.

It is frightening that this is coming as a surprise...
 
But Dear Sir,
I am confused that what -vs is do? i mean if we use this in probkup using -vs and disk space is 7 gb only . How it helps the backup to be split. i mean if we use -vs is that space not be fill all 7gb space?
 
-vs (volume size) is an old parameter that let you specify that your tape/floppy or whatever you were backing up to only had a specific size. It would create a volume of that size and then ask you to specify the next media to create the next chunk. Then when you're restoring the backup it would prompt you for the next volume each time. It is most definitely not the solution you want. It is still in the product for legacy reasons and should not be used as part of a backup strategy on modern hardware.
My opinion anyway.
 
It is a parameter whose reason for existence was putting a 4 GB database on 4 1 GB tapes. That does nothing for you with a disk.
 
You could use -vs to backup in pieces which are sometimes called "extents".

Traditionally this was used with tape so that you could change tapes after X blocks but you can also use it with disk.

For instance:

probkup online dbname dbname.01 -vs 100000 -com < backup.list

Will backup dbname in chunks of 100000 blocks. The first extent will be named "dbname.01". Additional extents names will be read from "backup.list" as needed. Usually this would be a list of names, one per line, like so:

dbname.02
dbname.03
dbname.04

One problem with this approach is that you have to guess how many file names to put into backup.list. Usually people put in "more than we will ever need" and 3 years later find out that backups stopped working 6 months ago because they didn't have enough...

This does not directly help you with your current problem but it does provide a bit of useful background.

What you /could/ do in the short term is to set -vs to slightly less than your available free space on the target drive. As each "extent" finishes probkup will stop and prompt for a new filename. Rather than get the file names from a redirected list ("< backup.list" above) provide them manually. But first copy the completed extent via FTP (or whatever) to an external system that has adequate space. Delete it once it is safely copied and verified. Then enter the next filename. Rinse and repeat.

I wouldn't want to do this more than a few times while I wait for adequate disk space to be provisioned. But it would get the job done in a pinch.
 
BTW -- if anyone is thinking that -vs is a magic parameter that will tell Progress to make a valid backup fit in X amount of space you are wrong.
 
You must log in or register to reply here.
Back
Top