RE: Online Redo Log During a Hot Backup (one more thing)

  • From: "Mark W. Farnham" <mwf@xxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 23 Sep 2004 08:58:47 -0400

There are three valid recommendations, depending on your situation:

1) If you have a period of relative inactivity, the simplest thing is to
check the log sequence, put all the tablespaces in hot backup mode, copy all
the database files, end backup on all the tablespace files, checkpoint,
switch logfiles, check the log sequence, copy all the archive logs required
to the backup set, backup controlfiles binary and to trace, and copy them to
the backup set.

2) If things are flying during your backup, one tablespace at a time is
better but slightly more complicated.

3) If you have complusive tuning disorder (or a really challenging situation
that needs everything it can get and for some reason you're not on RMAN
then you forecast activity within files at times of the day, begin backup on
each tablespace when activity is lowest on one of it's files, copy that
individual file, and get out of backup for that tablespace, and repeat this
for each and every FILE at the time you have forecast activity is least for
that file. Of course this adds significantly to the book keeping to track
what you need to recover a given file. I've never seen this level actually
materially useful compared to the extra complications, but I have measured
it. Usually it turns out that almost all the insert/update activity is in
the last file of a tablespace, so all you have to do is avoid maintenance
delete windows and the extra blocks for going tablespace at a time rather
than file at a time is minimal. (And try to pick the time when activity on
the tablespace overall is least, but even that is usually subordinate to
scheduling time slices on the tape drives. So the real answer is get enough
disk for two alternating online backups so you always have a recoverable
backup on line. Then the tape jobs are from backup to tape, so who cares
when, and those get shipped off site and you don't get the really annoying
problem of having to wait for tapes to be retrieved from off site before you
can start a recovery.) Oh -- if your management balks at the 2x, you can do
a magic trick with a little extra work and tell them you can get it down to
1x plus the size of the largest file and you should never need to reload a
tape other than testing your offsite recovery.


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Mark W. Farnham
Sent: Thursday, September 23, 2004 8:26 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: Online Redo Log During a Hot Backup

2. What is the recommended procedure of taking the database in backup up
mode, I mean put all tablespaces in backup mode at once or one tablespace at
a time?


Other related posts:

  • » RE: Online Redo Log During a Hot Backup (one more thing)