Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

archive log and Instance recovery

596722Oct 17 2007 — edited Oct 18 2007

Hi,
Does instance recovery needs Archive Log.

For example,

In a database there is heavy inserts going on - around 1 GB of data has been inserted, during which there have been various log switches thereby generating lots of archive logs. Before committing, I do a shutdown abort. In this case when instance starts next time does it require archive logs for doing a rollback from the datafile (because already datafile may have the uncommitted inserted transactions because of log switches).

Is there anything wrong in my thinking? Please clarify.

Thanks
SA

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 15 2007

Added on Oct 17 2007

#general-database-discussions

15 comments

1,481 views