Or use gzip/gunzip to compress - I usually get about twice the compression ratio!!
ETA.
"Burton Peltier" <burttemp1REMOVE_THIS_at_bellsouth.net> wrote in message news:<70dFa.32403$pk3.31165_at_fe09.atl2.webusenet.com>...
> --
>
> "Capt. Confusion" <dazed_at_confused.com> wrote in message
> news:NTcFa.2433$Nb1.125210672_at_newssvr21.news.prodigy.com...
> >
> > "Burton Peltier" <burttemp1REMOVE_THIS_at_bellsouth.net> wrote in message
> > news:SZbFa.50769$7l6.6543_at_fe03.atl2.webusenet.com...
> > > Secureless? What if your tape drive fails during backup ?
> > >
> > > I suppose I should have stated the obvious ... for the backup to disk
> > > option, the backup disk location HAS to be a different disk-spindle(s)
> than
> > > the datafile/controlfile/init.ora/etc. disk-spindle(s).
> > >
> > > Also, seems to me you could lose more than 1 hour using your method,
> unless
> > > of course we assume you are doing a manual log switch right before the
> > > hourly backup to disk of archived log files AND you ensure that you
> backup
> > > that latest archived log from the manual log switch.
> > >
> > > Also, do you backup the archived logs and then delete them. What if the
> tape
> > > is bad? We also always backup the archived logs twice before deleting
> them,
> > > again to a different disk spindle.
> > >
> > > Backups to disk are not a problem (assuming done correctly as stated
> above).
> > > They are usually faster to backup to and faster to restore from (since
> you
> > > usually restore from the latest copy on disk).
> > >
> > > But, I always try to keep 2 disk copies, just in case the 1st is bad and
> of
> > > course you always have the tape backups for a while. Actually, in our
> shop
> > > we keep the file server backups simple and just keep everything for 1
> year,
> > > including my hot/cold/export backups. Most (99%) of those hots/colds
> will
> > > never be used but at least we don't backup any *.dbf files to the file
> > > server backup, just the backups of these files which are in compressed
> mode
> > > of course (tar output compressed).
> > >
> > > The only disadvantage of disk backups is of course your database has to
> be
> > > small enough . All of the databases I support are less than 75 Gig (a
> few
> > > are over 50Gig).
> > >
> >
> > If you use a product like tivoli or netbackup, you can define storage
> groups
> > on disk which compress the files pretty nicely.
> >
>
>
> As I said above, our backups are in compressed mode.
>
> And on Linux/Unix , you just pipe the output of the backup command to the
> free Unix/Linux command , compress.
>
> Does a great job and is free/standard command , just like all those
> bizillions of other things you can do on Unix that have been there forever,
> are on all versions of Unix (and Linux), and increase productivity :)
>
> Too bad the OP is on windozes.
>
>
> > > --
> > >
> > > "Antoine BRUNEL" <antoinebrunel/yahoo.fr> wrote in message
> > > news:3ee4fce2$0$18665$79c14f64_at_nan-newsreader-01.noos.net...
> > > > hi from Paris
> > > >
> > > >
> > > > this kind of strategy is secureless: imagine your hard disks begin to
> stop
> > > > right during the copy to disk, of right before physical backup. In
> case
> of
> > > > big disaster, you may lose all a day of work.
> > > >
> > > > backup strategies using stagging disks as deposit for robotics are
> always
> a
> > > > bad ideas. They presents a major spof: the disk himself.
> > > >
> > > > Data flow to backup should always be sent directly to tape drive,
> disks
> are
> > > > only coming for simpler restores.
> > > >
> > > > Two things to never lose data:
> > > >
> > > > - backup to tape every hours archived logs,
> > > > - hot backup dbfiles directy to tape, including control an init.ora
> files.
> > > >
> > > > This done correctly, you cannot lose more than 1 hour of your
> customers
> > > > work.
> > > >
> > > > "Burt" <burtpelt_at_bellsouth.net> a écrit dans le message de
> > > > news:98b09e2b.0306090931.12a2b5d6_at_posting.google.com...
> > > > > One method we use is to backup Oracle to a disk location and then
> let
> > > > > the "normal" backup method backup the backup files.
> > > > >
> > > > > Usually, letting a "file server" type backup do a backup of the
> Oracle
> > > > > backup files is easier than coordinating Oracle backups (while
> > > > > tablepsaces are in backup mode - at least for the prior-to-RMAN
> > > > > method).
> > > > >
> > > > > Works good for the old method (prior to RMAN) of hot/online backups
> > > > > and should work with RMAN too (I think):
> > > > > 1) alter tablespace xxxx begin backup;
> > > > > 2) copy files for tablespace to another location
> > > > > 3) alter tablespace xxxx end backup ;
> > > > >
> > > > > Of course, this has to be done for each tablespace and also you need
> > > > > to backup the controlfile, archived log files, and init.ora . And,
> > > > > test, test, test ... :)
> > > > >
> > > > > Anyway, just another option that might be quicker/easier to
> implement
> > > > > - not necessarily easier to maintain . Each time you add a
> tablespace
> > > > > you have to update the script or write a script to build the list of
> > > > > tablespaces.
> > > > >
> > > > >
> > > > > rmadduluri_at_stantec.com (Rukmini Madduluri) wrote in message
> news:<a4d18386.0306090438.5cfe25d4_at_posting.google.com>...
> > > > > > Hi,
> > > > > >
> > > > > > I'm currently accepting responsibility to Backup our database
> > > > > > periodically. I have been doing various other dba tasks like
> > > > > > performance tuning, writing scripts, stored procedures and
> triggers.
> > > > > > I'm very good at PL/SQL and SQL . I know how to backup to a disk
> and
> > > > > > to exports and imports , but the problem is we have a server that
> has
> > > > > > to be backed up onto a tape. The server is a dell server that has
> its
> > > > > > own tape device and we have ARC Serve to manage the tapes. I can
> see
> > > > > > the Tape only from arc serve Media manager but cannot see the tape
> > > > > > from Windows explorer. I have never worked with tapes. I'm
> comfortable
> > > > > > doing backup's to disks but do not know how to backup to tape. Is
> > > > > > there a way to backup to the tape through Arc Serve or can I do it
> > > > > > directly from oracle. Any direction in this regard is greatly
> > > > > > appreciated.
> > > > > >
> > > > > > Rukmini
> > > > > > rmadduluri_at_stantec.com
> > > >
> > > >
> > >
> > >
> > >
> >
> >
Received on Thu Jun 12 2003 - 12:23:39 CDT
