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

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 - 16:32:18 CDT