which background process works in background when we perform recovery
Printable View
which background process works in background when we perform recovery
I can picture SMON and DBWn doing most of the leg work.
SMON ok.But how come DBWn....Can you pls expain in detail..what about RECO....?
But still I think SMON will come in to picture for automatic instance recovery.....I was asking manual recovery.....
Why DBWn? let me answer with a question: Who writes to the datafiles?
RECO process is related to distributed transactions, not to database recovery.
SMON - performs instance recovery
PMON - performs process recovery (user process) which cleans up database buffer cache and frees resources that the user process was using
DBW - When we issue recovery, archive redo log files begin to apply to data files. It's DBW duty