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

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

-- 

"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

>

>