Re: Why Backup Temp and Rollback segs?

From: MotoX <rat_at_tat.a-tat.com>
Date: Tue, 20 Oct 1998 08:30:17 +0100
Message-ID: <908868545.23774.0.nnrp-05.c2de712e@news.demon.co.uk>

A couple of points to add to all the useful and generally correct replies you got:

Don't forget to *backup* the archive redo logs, including the one you switched at the end of the tablespace backup sequence.
Don't forget to mirror your control files on separate disks, and take both binary and textual SQL backups of them (with the ALTER DATABASE BACKUP CONTROLFILE command) and back them up.
Mirror your redo logs on separate disks.
Make sure you are in ARCHIVELOG mode! :-)

And in Oracle8 with RMAN, you *don't* backup TEMP tablespaces, and you don't use the 'hot' backup commands (BEGIN BACKUP and END BACKUP).

MotoX.

Graham Thornton wrote in message <362B376C.68E8_at_ln.ssw.abbott.com.nospam>...
>Hello,
>
>Reading through the Oracle DBA handbook, I noticed that the section on
>on-line backups includes examples of backing up the TEMPORARY and
>ROLLBACK datafiles.
>
>Why would you want to do this? - If you need to recover from a crash you
>can only recover committed transactions so why would you need the
>TEMPORARY and ROLLBACK datafiles? - Wouldn't it be easier to just
>recreate them?
>
>Maybe I'm missing something here.
>
>Thanks
>
>Graham.
Received on Tue Oct 20 1998 - 02:30:17 CDT