While taking hot backups, where the data will be write ?
It writes in DB Cache,Redo Buffer cache then Redo log files. Is the process correct ? In addition, it writes changed blocks of data files(which is in backup mode) to redo log files instead of just row information. is it correct ? then
Old value in the Undo and New value in the redo. Whats the confusion?
Everything works the same except that additional data block snapshots are written to the redo to fix the fractures caused by the data modification while the backup is going on. Read the backup concepts.
Amar "There is a difference between knowing the path and walking the path."