Originally posted by virajvk
dear sir
I found everybody's response very good.

But In last reply u r talking about storing Flag in archive log file that is not possible as said transactions occupies multiple archive log.

Probabally we are asking Oracle to change there style of Recovery in which at a time one archive log file is applied.
What we are expecting is Oracle shuld scan all the archive log file simultatnously and mark uncommited transactions.
Which in turn mean following things

1.No incomplete Recovery is possible
2.And Recovery time is increased MTTR is getting higher and higher

Viraj
----------------------------------
9i OCA
That was a wonderful way of looking at it. Thanks a ton, really learning a lot of things here.

P.S. Some maybe feeling I am asking silly questions and wasting time. May be it is. Since I am a baby growing in Oracle, I will have lot of inquisitive ness until I get a little matured. Kindly bear with me in case of any questions that may seem immatured.

Many thanks and kind regards.

QUESTER