Q
Problem solve Get help with specific problems with your technologies, process and projects.

Applying a redo log entry directly to a data file

We all know that the LGWR flushes redo log entry from redo log buffer to the online redo log file. So I want to know whether there can be any condition apart from any recovery process where the redo entry has to be transferred from redo log file to data file, and which process does it? I mean that my database is 100% up and running, so is there any chance where such a condition can come about where a redo entry has to be applied directly from redo log file to data file.
Unless you are using Data Guard, redo is never read from the online redo logs unless you are performing a recovery operation on your database. All of the changed blocks are still in the buffer cache and will be written to the datafiles by the DBWn process. This occurs when a checkpoint happens.

Dig Deeper on Oracle database backup and recovery

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close