Re: Backup Oracle
2003-01-25 14:22:07
>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
|
|
|