yxes2013 wrote:Scenario is like THIS:
Hmmm I am confused....So if my database crashed for the day and I have a backup last night, + plus I have redos intact I do not have to worry lost transactions? even if I do not have archived logs?
The scenario is like this:
Archiving turned off.
The system.dbf got removed accidentally or got corrupted.
I need to restore from backups last night and recover the transactions for the day stored in the redos. Is it possible?
I am thinking that all the online redo logs still holds all the transaction for the day.
So are you convinced ed? ;)
yxes2013 wrote:And so is Hemant. He and I are in agreement. We are just pointing different aspects and considerations of the same principle.
Yeah, thats what I meant :)
But I also understand Ed's point and I know he is right ;)
I am just making a scenario where it can be possible to happen for the sake of argument discussions, and not really to recommend it.
Edited by: yxes2013 on 18.2.2013 17:59