Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Backup control file
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 - 15:35:55 CST