Sponsored Content
Operating Systems AIX Oracle Db Dump compression issue Post 302901686 by thameerakn on Thursday 15th of May 2014 03:30:04 AM
Old 05-15-2014
IBM Oracle Db Dump compression issue

Dear All,

I am trying to backup Databases in my company which installed on AIX oracle 10g. From the start they have not used the archives to backup DB. Instead they use expdp utility to export the data in to dump file and rename the file extension to .tmp and ftp to another machine to compress the file. (Don't ask why they change extension to .tmp)

I am trying to short the process by zip the file before sending file to Storage (NAS). But when compress large database dump files (oracle dump, used ZIP,gzip commands) I get below error. File size more than 20GB.

zip error: Entry too big to split, read, or write (file exceeds Zip's 4GB uncompressed size limit)

I have read increase ulimit will help on this issue but my machine ulimit values are:

time(seconds) unlimited
file(blocks) unlimited
data(kbytes) unlimited
stack(kbytes) 4194304
memory(kbytes) unlimited
coredump(blocks) unlimited
nofiles(descriptors) unlimited

AIX version - 5.3

is there anyway i can compress the dump file without using pipe method?

gzip 1.2.4
Zip 2.32
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

help, what is the difference between core dump and panic dump?

help, what is the difference between core dump and panic dump? (1 Reply)
Discussion started by: aileen
1 Replies

2. UNIX for Dummies Questions & Answers

Exact issue in Core dump

Hi, I have a core dump problem in HP-UX. I have searched in this forum, but could not get any answer related to my issue. I debugged the core file by 'gdb' and by using 'bt' cmd I got the function and line no, but I am not sure that the problem lies on the same function . I want to know... (0 Replies)
Discussion started by: ronix007
0 Replies

3. Linux

Clearning space - File compression issue

Hi, We have access to 2 filesystems: Filesystem Size Used Avail Use% Mounted on /dev/mapper/system-oraoid 30G 30G 119M 100% /app /dev/mapper/system-tmp 2.0G 442M 1.6G 22% /tmp As you can observe the file system on /app is full. In order to recover... (2 Replies)
Discussion started by: animesh303
2 Replies

4. Emergency UNIX and Linux Support

Core Dump Issue

Hi In SunOS the gdb command outputs the following info. ---Type <return> to continue, or q <return> to quit--- Reading symbols from /opt/dcs_5.1/lib/libssl.so...done. Loaded symbols for /opt/dcs_5.1/lib/libssl.so Reading symbols from /opt/dcs_5.1/lib/libcrypto.so...done. Loaded symbols for... (1 Reply)
Discussion started by: kumaran_5555
1 Replies

5. Shell Programming and Scripting

"links -dump" output format issue

Hi All, I tried searching a lot about this but to no avail. I have a HTML file. I used links -dump file_page.html > text_html.txt What the above command gave me was a filtered text from the HTML file with tags removed. Now, the the output from the above command looked something like this:... (1 Reply)
Discussion started by: shoaibjameel123
1 Replies

6. Shell Programming and Scripting

Connection to Oracle data and dump text file

Hi for all! I need for my job one shell script very concrete about connection to oracle databases and writing to text file. Well I tell you: 1.- I must read a file as parameter from linux interface: > example.sh fileToRead 2.-I must read line to line in "fileToRead" and take a... (9 Replies)
Discussion started by: wien996
9 Replies

7. UNIX for Dummies Questions & Answers

How can I import a particular schema from full dump in Oracle?

Hi All, I have a full oracle dump file that I have exported from a production server. I want to import a specific schema out of the full dump. Is that possible in oracle. What will be the command for that? (6 Replies)
Discussion started by: Palak Sharma
6 Replies

8. UNIX and Linux Applications

How to import and dump file to remote Oracle server?

Hi All, I have a linux centos instance which has a dump file. I need to import the dump file to the oracle server which is located at some remote location. I have installed the oracle client on my machine and I am able to connect to the remote oracle server. Now how to import the dump to the... (3 Replies)
Discussion started by: Palak Sharma
3 Replies

9. AIX

Issue while importing Oracle Dump File on AIX 5.3

Hi All, I am facing one problem related to importing Oracle Dump file. We have two different version of AIX boxes with oracle (version 10.2.0.4.0) installed. On one AIX box (version 6.1) we are creating oracle dump file (*.dmp) using oracle exp utility and importing it onto another AIX box... (1 Reply)
Discussion started by: gunjan_thakur
1 Replies

10. Homework & Coursework Questions

Oracle dump file (del format) import into db2

1. The problem statement, all variables and given/known data: are the oracle dump files compatible to direct import into db2? I already tried many times but it always truncated results. anyone can help/ advice or suggest? 2. Relevant commands, code, scripts, algorithms: exp... (3 Replies)
Discussion started by: Sonny_103024
3 Replies
GPODDER-BACKUP(1)						   User Commands						 GPODDER-BACKUP(1)

NAME
gpodder-backup - Backup and restore utility for gPodder user data SYNOPSIS
gpodder-backup [--create|--extract] <archive.gpo.tar.gz> [options] gpodder-backup --purge DESCRIPTION
This utility can be used to create a dump of the current gPodder data (configuration files + downloads), optionally replacing the real con- tents of the download folder with zero-byte files (for submitting your data to a bug report without having to transfer lots of data). OPTIONS
--version show program's version number and exit -h, --help show this help message and exit -c <FILE>, --create=<FILE> Create a new archive -x <FILE>, --extract=<FILE> Extract an existing archive -f, --fake-downloads Store downloads as zero-byte files in backup -n, --no-covers Do not include cover files in archive -D <DIR>, --destination=<DIR> Extract downloads in different folder -P, --purge Remove current data (can be combined with --extract) USAGE FOR BUG REPORTING
This command is useful if you want to report a bug in gPodder: gpodder-backup --create bug123.gpo.tar.gz --fake-downloads Backup your current data to file bug123.gpo.tar.gz, but don't store download data (create zero-size dummy files instead). You can then attach bug123.gpo.tar.gz to the bug report. If you are instructed to try gPodder from a "clean state", you can use the following command (be sure to backup your data before!): gpodder-backup --purge Remove all gPodder data, so you can start from a clean state EXAMPLES
gpodder-backup --create today.gpo.tar.gz Backup your current data to file today.gpo.tar.gz gpodder-backup --extract mybackup.gpo.tar.gz Restore (without purging) the contents of mybackup.gpo.tar.gz gpodder-backup --extract default.gpo.tar.gz --purge Remove current data, then restore the contents of default.gpo.tar.gz gpodder-backup --purge Remove all gPodder data, so you can start from a clean state EXTRACTING FAKED DOWNLOADS
Please note that any existing downloads will be overwritten with zero-byte files when using the --extract option of the gpodder-backup utility with a backup created with --fake-downloads AUTHOR
gpodder-backup was written by Thomas Perl (thp@gpodder.org) gpodder-backup 1.0 December 2010 GPODDER-BACKUP(1)
All times are GMT -4. The time now is 05:00 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy