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 -> Re: Do DDL statements get stored in the archive logs?

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

From: John P. Higgins <jh33378_at_deere.com>
Date: Mon, 11 Jan 1999 20:26:50 -0600
Message-ID: <369AB2EA.63F3C350@deere.com>


Any 'unrecoverable' statements are not logged, hence not recoverable.

lacymj@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@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 - 20:26:50 CST

Original text of this message

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