Hi, Paul,

on Freitag, 04. März 2005 at 18:07 you wrote to amanda-users:

PB> Last time I looked at doing backups of Oracle (Ora 6-7-8), I
PB> approached it as follows:  first set each tablespace in hot backup mode
PB> (alter tablespace TS begin backup) then doing a filesystem backup
PB> of all the directories with datafiles, using plain amanda DLE's,
PB> then setting each tablespace out of hot backup mode, (alter
PB> tablespace TS end backup);  then force a redo log switch (alter
PB> system switch logfile) and then doing a backup of the archived redologs.

PB> No need to stop the database at all.

PB> The dirty trick with amanda here is getting the archived redo logs done
PB> after the rest. That is difficult, because the datafiles
PB> are spread over different DLE's, and, as another thread this week
PB> already explained, you can't very well specify an order for the DLE's
PB> in amanda.  My solution was to mirror the archived redologs to a
PB> different machine. Having a tapebackup of datafiles + archived redologs
PB> on two different machines was enough to restore the database. That
PB> mirror was kept up to date during daytime too.
PB> To be really sure, I did a full export too (also nice to restore a
PB> single table if needed).

PB> Is Oracle 9-10 any different for "hot backup mode" (i.e. more
PB> complicated than it need to be?).

Paul, Bert, and anyone else:
Could anyone of you imagine writing a small "Howto back up Oracle dbs"
for the docs?

-- 
best regards,
Stefan

Stefan G. Weichinger
mailto:monitor AT oops.co DOT at