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

What happens if there is no log switch for a long time?

If a log switch doesn't occur for a long time then what happens? Also, if I committed my transaction and suddenly the power was gone, then what will happen in the database file?

If a log switch doesn't occur for a long time then what happens? Also, if I committed my transaction and suddenly the power was gone, then what will happen in the database file?

If a log switch has not occurred for a long time and the database has not crashed, then there is little to worry about. If the database does crash, you really do not need to worry too much either since the transactions will be in the online redo logs. Even if a log switch does not occur, a checkpoint will occur frequently, forcing the DBWn process to write changed blocks back to disk.

If you committed your transaction and the instance fails, a record of your transaction will be in the online redo logs. A commit is not complete until the transaction and the commit are written to the online redo logs. When you start the instance, SMON will replay the transactions not yet written to disk and handle them appropriately.

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