Re: DDL statements in archive logs?

Hi Mike:

To the best of my understanding:

All changes are recorded to the redo logs/archive logs. DDL statements are expanded into the respective DML statements issued against the data dictionary tables. So, the DDL (really DML) that reflects the creation of the datafile (it's info being added to the data dictionary) is stored. However, the datafile is not physically re-created by recovery.

I suppose this makes sense. If the recovery process physically re-created the datafile, then it would overwrite the datafile if it already existed (although I'm sure Oracle could find a way to prevent this), and you might not want that to happen.

IF you have all the archive logs that were generated since the datafile was created, you can create an "empty" datafile, and apply all the changes from the archive logs. Check the recovery section of the administrator's guide for details.

Regards,
--
David C. Sisk
The Unofficial ORACLE on NT site
http://www.ipass.net/~davesisk/oont.htm

mike.lacy_at_alcoa.com wrote in message <77dvc2$f4t$1_at_nnrp1.dejanews.com>...
>Does anyone know if DDL statements are archived in the archive log files?
We
>were doing a point in time recovery for testing and ran into a problem
where a
>new datafile was added but had not been backed up yet. Does anyone know
what
>is saved in the archive logs and what is not?
>
>Thanks
>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 Tue Jan 12 1999 - 21:55:59 CST