--
"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 Mon Jun 09 2003 - 23:31:20 CDT
