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

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 - 12:31:41 CDT