Re: Do DDL statements get stored in the archive logs?

lacymj_at_my-dejanews.com wrote in message <77dsfq$cod$1_at_nnrp1.dejanews.com>...
>I was restoring a database on a test machine and ran across an interesting
>problem. Our DBA had added a new datafile to the database but it had not
been
>backed up. When I tried to restore to a point in time prior to the daily
>backup but AFTER the add of the datafile, it was unable to perform the
>restore. I guess this makes sense, but it made us start wondering what other
>changes to our database may not be stored in the archive logs? Are DDL
>statements stored (create, replace, etc.).

Performing file related operations in most cases causes update of data dictionary /recursive SQL calls and implicit commit/ and control file update together. Change vectors of recursive calls and commits are normally written into redo log just like "normal" transactions entries. But controlfile updates having impact to recovery have no redo.

HTH,
--
Piotr Kolodziej pkol_at_otago.gda.pl
Just my private opinion. Received on Tue Jan 12 1999 - 03:52:56 CST