In this article we are going to see Oracle Recovery Writer Process (RVWR) Background Process.
- Enabling Flashback Database starts a new RVWR background process. This process is similar to the LGWR (log writer) process. The new process writes Flashback Database data to the Flashback Database logs.
Whenever an oracle block undergoes a change, the Recovery Writer (RVWR) background process writes the flashback data to the Flashback Logs. The flashback data contains database data and the redo data.
- Flashbacking a database means going back to a previous database state.
- The Flashback Database feature provides a way to quickly revert an entire Oracle database to the state it was in at a past point in time.
- This is different from traditional point in time recovery.
- Recovery Writer (RVWR) introduced which is responsible for writing flashback logs which stores pre-image(s) of data blocks
- Using Flashback Database to back out changes that have resulted in logical data corruptions.
- When flashback is enabled or when there are guaranteed restore points, RVWR writes flashback data to flashback database logs in the fast recovery area.
- RVWR can run as a thread or as an operating system process.
Connect with me:-
FB Page : https://www.facebook.com/dbahariprasath/?
Twitter : https://twitter.com/oracledbwr