Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Backup control file

Backup control file

From: Roland Cycan <Roland_Cycan_at_yahoo.com>
Date: Mon, 01 Feb 1999 21:35:55 GMT
Message-ID: <36B61E37.1014B615@yahoo.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US