Re: Re: Exports with pipes

Hi!

 was wondering whether there is a 'way of doing'  sqlload of 'compressed file'????

 has someone actually done it? or am i the only 'spooky one'!!!!

• Original Message -------------- jkstill_at_cybcon.com wrote: To:Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> From:jkstill_at_cybcon.com Date:Tue, 16 Jan 2001 09:40:50 -0800 Subject:Re: Exports with pipes

On Tue, 16 Jan 2001, lerobe - Lee Robertson wrote:

> Anyone noticed any unreliability/errors/probems/bugs etc. in using pipes
> whilst exporting big tables.
>
> As we are having space issues for export files we were going to use the
> above method. One of our DBAs however reckons that he has had problems
> before with this method and that it can be unreliable.
>
> Oracle 8.0.5.0.0, Tru64 Unix V4.0f
>

At my previous job, all of my exports were pushed through a pipe so they could be compressed via gzip.

*Never* caused a problem.

Your DBA's previous errors may have been and error in execution.

Jared

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: jkstill_at_cybcon.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).

_____________________________________________________
Chat with your friends as soon as they come online. Get Rediff Bol at
http://bol.rediff.com







------------------------------

 From: "Cyril  Thankappan" <cyril_thank_at_rediffmail.com>
 Date: 16 Jan 2001 18:52:19 -0000
 Subject: Re: Re: RMAN.. Success or Failure

Hi!

 do u use rman backup to disk (filesystem)
or directly to tape.

 If u r taking rman backups directly to tape, then I am very VERY keen to know the steps involved.

 Thanks
------------- Original Message --------------
"Ruth Gramolini" <rgramolini_at_tax.state.vt.us> wrote:
To:Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
From:"Ruth Gramolini" <rgramolini_at_tax.state.vt.us>
Date:Tue, 16 Jan 2001 07:35:52 -0800
Subject:Re: RMAN.. Success or Failure

We use rman for all of our backups, production and developement.  We run out
developement database without archive logging and production with
archivelogging.  We do online backups of production and offline for
development.  I have recoverd from both types.  Rman has many things going
for it.  It used Oracle's internal structure so it never has a problem with
a crash during a backup cause inconsitant data.

If you have more specific questions I will be glad to answer them.  Just
write directly to me.
Regards,
Ruth
----- Original Message -----
To: "L" <ORACLE-L_at_fatcity.com>; "L" <oracledba_at_quickdoc.co.uk>
Sent: Tuesday, January 16, 2001 10:26 AM




> Hello Fellow DBAs!

>

> I am in a shop where in I have to implement a backup strategy on a new

> environment.

> Its 8.1.6 on Solaris.

>

> We have EBU backups for 7.3 dbs (set up before I got in).

>

> I would like to know about how good/bad is it to implement RMAN?

> Anyone who would like to share their

> view/experience/topoloty/design/anything

> about this are welcome.