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

Hi Mike,
Yes they do, they are treated as ordinary transactions and committed automatically.
Your problem with the datafile is different. This is a change to the controlfile. If you restore an old controlfile, the change will yet not have been reflected. Your dba needs to issue an
alter database backup controlfile to trace | <file name> immediately after he adds a datafile
This would have prevented your situation.

Hth,
Sybrand Bakker, Oracle DBA

lacymj_at_my-dejanews.com wrote:

> 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.).
>
> Thanks for you help!
> Mike Lacy
> mike.lacy_at_alcoa.com
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

Received on Mon Jan 11 1999 - 17:07:31 CST