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

Checkpointing during hot backup

Will the hot backup file have the updated datablock or the previous data?

During hot user-managed backup, OS copy of the datafile has started. Checkpointing happens and DBWR updates the last block in the file in backup mode. This block was yet to be copied and pasted. Now will the backup file have the updated datablock or the previous data?
If the file was only partly copied during the backup and the last block was modified, the last block will probably be up to date in the backup copy. However, if the first block of the file was modified after the backup was started, the backup will not contain this change. But do not worry as the archived redo logs will have this information whether it is in the backup or not.

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