Re: Backup control file

Hi Roland,
No, any create tablespace or add or drop datafile is not recorded in the redo log, as this are changes to the PHYSICAL structure of the database. Any other -logical- change (drop table amongst them) is recorded in the redo log.
If your database crashes, and you need to retrieve a control file from backup, this control file will not have the changes you just made and you will loose your tablespace etc.

Hth,
Sybrand Bakker, Oracle DBA

Roland Cycan wrote:

> In a backup and recovery book I've been looking at it is
> suggested that control files be backed up after a create, alter,
> or drop on any datafile, table, or tablespace. It doesn't seem
> to state explicitly that these events are not recorded in the
> redo logs, although it does leave that impression.
>
> Are these events recorded in the redo logs? If so, is it really
> worth the effort to backup the control files after each of these
> events? If not, why on earth are they not recorded in the redo
> logs?
>
> And what about create, alter, or drop on any other object, such
> as a function or view? Are these recorded in the redo logs?

Received on Mon Feb 01 1999 - 16:43:09 CST