Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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