Supposing I will make my redo log with size of 5Gb, so that Even if I do not make my DB in archivelog mode,crash recovery does not depend on size of redo logs, only its speed
I still can recover my point in time crash recovery for the 1 day transaction. Since all the 1 day changes are contained in the 3 log files of total of 15G.
if you mean media recovery from cold backup, then keep in mind that redo log size is limited, but you can add more redo groupsYes what i mean is instance recovery. Its the one that you do not need to archivelog because all your trasactions for the day are intact in the online redologs.
yxes2013 wrote:Yes when Database crashes and while coming up it has to read the redo logs for the data for last 1 hour to do crash recovery, so duration taken for crash recovery will be more.
I am confused :(
What is the advantage of switching the logs every 20 minutes and switching it every hour?Is it for the goal of speedup instance crash recovery?