Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: datafile compression

Re: datafile compression

From: Joan Hsieh <joan.hsieh_at_tufts.edu>
Date: Wed, 13 Feb 2002 06:27:15 -0800
Message-ID: <F001.0040DD43.20020213053320@fatcity.com>

Joan Hsieh wrote:
>
> Igor,
>
> I am looking for a solution to zip all the backup files into one
> backupset.zip file on NT. I have trouble to find the dos command line to
> do this.(pkzip or winzip command line? should executed in a batch file
> after backup) Can you share this info with us? This should be a very
> easy thing to do. NT comand compact /C is not what I want. Thanks,
>
> Joan
>
> Igor Neyman wrote:
> >
> > Keith,
> >
> > For the backup I am copying db files into 'compressed' directory (so they
> > get compressed while being copied). I recovered db from 'compressed' db
> > files many times (they get automatically de-compressed while being copied
> > from 'compressed' directory into 'normal'), and compression didn't cause any
> > problems.
> > Though, for some reason I didn't risk to set 'compressed' directory for
> > archived RedoLog files.
> >
> > Igor Neyman, OCP DBA
> > ineyman_at_perceptron.com
> >
> > ----- Original Message -----
> > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> > Sent: Thursday, February 07, 2002 6:23 PM
> >
> > Hello everyone. Let me say first to all who are on the list group THANK YOU.
> > >From reading the emails I receive I have learned a LOT the past few weeks.
> >
> > My question here is. I am trying to find a way to compress the datafiles
> > when I copy them to a backup folder on NT. Does anyone have a suggestion as
> > to what product they use to compress datafiles? Has anyone ever used the
> > COMPRESS option on a folder in NT to compress datafiles? If so, was there
> > ever a problem. I did try pkzip and when the files unzipped it gave errors
> > abour the crc checks. I also researched this and didn't find much about
> > compressing datafiles BUT i'm not that good with the oracle doc's yet
> > either.
> >
> > Thanks in advance for any responses to this email and everyone have a good
> > day.
> >
> > >>>>>>>>>>>>> Confidentiality Disclaimer <<<<<<<<<<<<<<<<
> > This email and any files transmitted with it may contain confidential and
> > /or proprietary information in the possession of WellStar Health System,
> > Inc. ("WellStar") and is intended only for the individual or entity to whom
> > addressed. This email may contain information that is held to be
> > privileged, confidential and exempt from disclosure under applicable law. If
> > the reader of this message is not the intended recipient, you are hereby
> > notified that any unauthorized access, dissemination, distribution or
> > copying of any information from this email is strictly prohibited, and may
> > subject you to criminal and/or civil liability. If you have received this
> > email in error, please notify the sender by reply email and then delete this
> > email and its attachments from your computer. Thank you.
> >
> > ================================================================
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Keith Worley
> > INET: Keith.Worley_at_wellstar.org
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Igor Neyman
> > INET: ineyman_at_perceptron.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joan Hsieh
  INET: joan.hsieh_at_tufts.edu

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Wed Feb 13 2002 - 08:27:15 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US