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

What happens to redo files in a crash?

Whenever we read about backup and recovery in Oracle, a crash always corrupts the datafiles. What happens to the redo files? Do they never get corrupted? If yes, then how is recovery done in these cases?

Whenever we read about backup and recovery in Oracle, a crash always corrupts the datafiles. What happens to the redo files? Do they never get corrupted? If yes, then how is recovery done in these cases?
I would not characterize the datafiles as being "corrupt" when Oracle crashes. A better term is that the datafiles will be "inconsistent" after an instance crash. The files will be inconsistent because there may be uncommitted transactions in the datafile. So the online redo log files are used to resolve the uncommitted data. It is also possible that the datafiles will not contain the results of a committed transaction.

It is highly possible that when the instance crashes, there are uncommitted transactions in the redo log files as well. This means the online redo log files share the same inconsistency. However, when you start the instance, SMON performs instance recovery which means the online redo log files are used to commit any changes not yet written to the database data files, as well as rollback any uncommitted transactions that were in progress during the crash.

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