Redo Log

If we are running in NOARCHIVELOG mode and my all redo log files are full and data is still not committed by the current session. What activity will Oracle perform and what will happen with the un-comitted data?

Questions by gbansal4   answers by gbansal4

Showing Answers 1 - 2 of 2 Answers

MAbdullah47

  • Feb 5th, 2009
 

NONARCHIVE log will Protect the DB from Instence faliure but not from Media failure.
The Redo files will be covered until the last backup taken , but after that all uncommited datae will be lost for the period (after the last backup) taken.

  Was this answer useful?  Yes

ianilreddy

  • Aug 7th, 2010
 

In database whatever changes we made that going to store in redologs. The changes are record in redolog buffer when certain conditions lgwr will write to redologs
1)
When a transaction commit
2)  For every three seconds
3) 
More than 1mb changes are recorded
4) Before db writer writes

When lgwr writing redolog files circular fashion when it writing first logfile and it is full then it writes to second logfile.
This processes is known as logswitch. When logswitch occurs it writes to another file .f database is running in noarchivelogmode if second one also fill then it writes to first logfile the information in the logfile is over written by lgwr.
These data is required for recovery purpose so if it is over written we cannot perform recovery.


  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions