database no archive log
1. I have 3 redo log groups
2. I have 10 uncomitted transactions, 3 in redo 1 , 3 in redo 2 and 4 in redo 4
3. the uncomitted data are written to datafiles
4. redo 1 is overwritten by new redo
5. instance failre
6. we start database
I mean for example my uncomitted transactions in redo 1 has been overwritten then from where does Oracle
obtain information about these 4 uncomitted transactions?
I have another problem,
I have three redo groups , every groups has one 50-MB size logfile;
But I have a transaction which will generate 160MB size redo.
I should remind you this is a noarchived mode database.
So, would this transaction be processed , or fail ? and Why?
If you understand this question, your question will be answered by yourself.