Amanda-Users

Re: Backup Oracle

2003-01-25 14:22:07
Subject: Re: Backup Oracle
From: "John R. Jackson" <jrj AT purdue DOT edu>
To: "Aline" <aline_alencar AT bol.com DOT br>
Date: Sat, 25 Jan 2003 12:47:58 -0500
>I would like to use the Amanda Software in order to make 
>backup of some oracle's tables. Is it possible? Is it 
>good?

We back up several Oracle databases (and have even had to restore :-).
The trick is to run a script just before the amdump run that:

        - for each tablespace in the database
                - identify all datafiles belonging to that tablespace 
                - set the tablespace to backup mode
                - copy the datafiles to the backup location
                - set the tablespace to regular mode
        - switch the log file so any changes made during backup get archived
        - back up the control file

The files are written to a large separate partition that is what Amanda
is actually told to back up.

The scripts, etc, are here:

  ftp://gandalf.cc.purdue.edu/pub/amanda/dbbackup.*

>Aline

John R. Jackson, Technical Software Specialist, jrj AT purdue DOT edu

<Prev in Thread] Current Thread [Next in Thread>