- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: How to do multiple Informix exports to a singl...
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-10-2000 02:13 AM
тАО10-10-2000 02:13 AM
Apparently tar and cpio are limited to 2 Go and dbexport only exports 1 database to a tape.
I read a lot on fbackup. Is there a possibility ?
Any other tries will be welcomed !
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-10-2000 02:27 AM
тАО10-10-2000 02:27 AM
Re: How to do multiple Informix exports to a single tape ?
Several comments.
I'm not familar with Informix and its inherent backup schemes. However:
1. fbackup does support files that exceed 2GB (largefiles) whereas tar and cpio do not.
2. Oracle handles the export of very large databases by splitting its export processes into background pipes into multiple filesystems. The thread that describes this, and that references the Oracle document is:
http://my1.itrc.hp.com/cm/QuestionAnswer/1,1150,0xcc4668c57f64d4118fee0090279cd0f9,00.html
Hopefully this will assist you. Good luck.
...JRF...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-10-2000 02:27 AM
тАО10-10-2000 02:27 AM
Re: How to do multiple Informix exports to a single tape ?
Several comments.
I'm not familar with Informix and its inherent backup schemes. However:
1. fbackup does support files that exceed 2GB (largefiles) whereas tar and cpio do not.
2. Oracle handles the export of very large databases by splitting its export processes into background pipes into multiple filesystems. The thread that describes this, and that references the Oracle document is:
http://my1.itrc.hp.com/cm/QuestionAnswer/1,1150,0xcc4668c57f64d4118fee0090279cd0f9,00.html
Hopefully this will assist you. Good luck.
...JRF...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-10-2000 03:38 AM
тАО10-10-2000 03:38 AM
Re: How to do multiple Informix exports to a single tape ?
When you want to do same backup sesions to a tape you must use norewind device /dev/rmt/xmn.
Using this device you can append files to a tape.
ie:
tar cvf /dev/rmt/0mn /tmp/1
tar cvf /dev/rmt/0mn /tmp/2
....
mt -t /dev/rmt/0mn rew # ind
tar tvf /dev/rmt/0mn
r--r--r-- xxxxxxxxxxxxxx /tmp/1
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-10-2000 03:39 AM
тАО10-10-2000 03:39 AM
Re: How to do multiple Informix exports to a single tape ?
When you want to do same backup sesions to a tape you must use norewind device /dev/rmt/xmn.
Using this device you can append files to a tape.
ie:
tar cvf /dev/rmt/0mn /tmp/1
tar cvf /dev/rmt/0mn /tmp/2
....
mt -t /dev/rmt/0mn rew # ind
tar tvf /dev/rmt/0mn
r--r--r-- xxxxxxxxxxxxxx /tmp/1
Use no rewind device when export directly to tape
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-10-2000 03:59 AM
тАО10-10-2000 03:59 AM
Re: How to do multiple Informix exports to a single tape ?
When you want to do same backup sesions to a tape you must use norewind device /dev/rmt/xmn.
Using this device you can append files to a tape.
ie:
tar cvf /dev/rmt/0mn /tmp/1
tar cvf /dev/rmt/0mn /tmp/2
....
mt -t /dev/rmt/0mn rew # ind
tar tvf /dev/rmt/0mn
r--r--r-- xxxxxxxxxxxxxx /tmp/1
Use no rewind device when export directly to tape
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-10-2000 04:50 AM
тАО10-10-2000 04:50 AM
Re: How to do multiple Informix exports to a single tape ?
fbackup will only back up disk files.
I don't know about dbexport but I assume that it will write it's export file to either a disk or tape file. If you use the non-rewind tape file then you should be OK, it's very unusual for a utility to rewind a tape before writing to it (fbackup does).
Try it! Write three dbexports to a non-rewind tape device then you can test if all three files are on tape with the mt command:-
export TAPE=/dev/rmt/?mn
mt rew
mt fsf 3
The last mt command will fail if there is only one file on the tape.
Another approach that requires spare diskspace is to 'dbexport' to a disk file then back that up to tape (non-rewind device) with dd using a large blocksize.
Regards,
John
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-10-2000 06:14 AM
тАО10-10-2000 06:14 AM
Re: How to do multiple Informix exports to a single tape ?
I can now do several exports directly to the same tape (norewind device): /dev/rmt/0mn
1) mt rewind
2) dbexport dbtest1 -X -ss -t /dev/rmt/0mn -b 16 -s 24576000
3) dbexport dbtest2 -X -ss -t /dev/rmt/0mn -b 16 -s 24576000
4) dbexport dbtest3 -X -ss -t /dev/rmt/0mn -b 16 -s 24576000
If i want to import only dbtest3:
1) mt rewind
2) mt fsf 2
3) dbimport dbtest3 -t /dev/rmt/0mn -b 16 -s 24576000
The only worry i have is it i can really put 24Go on this tape ? (It's a DDS3 tape drive and i have a 24 Go tape)
where i though we could only 12 Go
JGD
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-10-2000 06:24 AM
тАО10-10-2000 06:24 AM
SolutionThe 24Gb figure assumes a 2:1 compression ratio achieved by the tape drive. You can usually better this providing that you are not writing data that has already been compressed.
I believe that the tape hardware uses a similar compression algorithm to 'gzip' so you could check how well that performs by dbexport'ing to a disk file and gzip'ing that (provided you've got the spare disk space).
Regards,
John
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-10-2000 06:29 AM
тАО10-10-2000 06:29 AM
Re: How to do multiple Informix exports to a single tape ?
Well 12 gb are nominal capacity of tapes ( DDS3 125m not DDS2 120m).
Using compression ( compressing 2 bytes in 1 ratio 2:1) lets you 24 GB, BUT ascii files as exports let better ratio, so dont be surprised if you can put 36 Gb in one tape.
Compresion ratio is better when data come fast to drive, and blocksize . Try different methods, dd , export ... and use big (64K) blocks.
Note: Magic responses are over 8 points.