How to run Oracle 8.1.6 in archive mode and have the archive files roll or compressed

Posted on 2003-02-19
Medium Priority
Last Modified: 2013-12-27
I'm running Oracle 8.1.6 with archiving on. The problem is, I get tons of files in the arch directory. Is there a way to configure Oracle to roll its archive files or compress them and store them elsewhere? What I really need it kind of mgmt for archiving. does this exist in Oracle?
Question by:swensel
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Expert Comment

ID: 7986234
We have a similar situation. I have a cron job set up to compress (using gzip) the files every 5 minutes. This could also be set up to delete the older files (following a successful backup of course) or relocate them elsewhere, but I prefer to do this manually. HTH.

Accepted Solution

Otetelisanu earned 150 total points
ID: 7987520
Hello, I have the same problemm with Oracle for exp. Much-calibrated
that helps.

Workaround #2:
Use UNIX pipes and the split command:

  Export command:

    echo|exp file=>(split -b 1024m - exp-) userid=system/manager tables=A

    Note: You can put any "exp" parameters. This is working only in ksh and
          has been tested on Sun Solaris 5.5.1.

  Import command:

    echo|imp file=<(cat exp-??) userid=system/manager tables=A

Splitting and compressing at the same time:

  Export command:

    echo|exp file=>(compress|split -b 1024m - exp-) userid=system/manager

  Import command:

    echo|imp file=<(cat exp-*|zcat) userid=system/manager tables=A

Workaround #3:
This is almost the same as above, but, in a three-step implementation using
explicit UNIX pipes without the split command, only relying on compress:

  Export command:

    1) Make the pipe
    mknod /tmp/exp_pipe  p

    2) Compress in background
    compress < /tmp/exp_pipe > export.dmp.Z &
    cat p | compress > output.Z &
    cat p > output.file & )

    3) Export to the pipe
    exp file=/tmp/exp_pipe userid=system/manager tables=A

  Import command:

    1) Make the pipe
    mknod /tmp/imp_pipe  p

    2) uncompress in background
    uncompress < export.dmp.Z > /tmp/imp_pipe &
    cat output_file > /tmp/imp_pipe &

    3) Import thru the pipe
    imp file=/tmp/imp_pipe userid=system/manager tables=A


Author Comment

ID: 7988959
Thanks for the tips. I'm thinking that there is a way to manage the archive files from within Oracle. I'd like to put this into my application set-up, rather than requiring a seperate cron job to run. Is that possible? Does Oracle have this kind of a facility available?

Expert Comment

ID: 8015412

Reading your suggestion has made me realise I dont really understand pipes.  Can you explain mknod, making pipes in /tmp and the benefits of using such things ?? When you would use pipes ?

I remember seeing a unix sa using pipes before, it was to aid performance / speed ?? Isa that correct.

If you could give me a quick explaination, I would great appriecate it.

LVL 18

Expert Comment

ID: 10425857
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

Answered by  Otetelisanu

Please leave any comments here within the next four days.


EE Cleanup Volunteer

Featured Post

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Let's say you need to move the data of a file system from one partition to another. This generally involves dismounting the file system, backing it up to tapes, and restoring it to a new partition. You may also copy the file system from one place to…
I have been running these systems for a few years now and I am just very happy with them.   I just wanted to share the manual that I have created for upgrades and other things.  Oooh yes! FreeBSD makes me happy (as a server), no maintenance and I al…
Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Suggested Courses
Course of the Month15 days, 8 hours left to enroll

741 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question