Re: Oracle backup to tape Please help....

"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.

> --
>
> "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:11:25 CDT