Database Administration (MOSC)

MOSC Banner

Redo Log Files

edited Jul 5, 2012 3:58AM in Database Administration (MOSC) 4 commentsAnswered
 I know that :-

The primary function of the redo log is to record all changes made to data. If a failure prevents modified data from being permanently written to the datafiles, then the changes can be obtained from the redo log, so work is never lost.

I want to ask , how redo log files used to recover data when an unexpected power outage occurs and terminates database operation,

of course oracle will not able to write the data in memory to datafiles and the data will lost, 

(I think that oracle also will be late to write the data to the redo log files)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center