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

SCN entries in controlfile during database crash

While taking an RMAN backup, if the DB crashes, will the entry in the controlfile be removed? If yes, when will it be removed?

According to your material, you said the SCN details will be stored in controlfiles or the recovery catalog. I would like to know, while taking an RMAN backup, if the DB crashes then will the entry in the controlfile be removed? If yes, when will it be removed? Thanks.
The SCN entries are constantly being updated in the control files. If your database crashes during your RMAN backup, then there will be a recent SCN in the control files. When using RMAN for recovery (if necessary), RMAN will not use the backup that was taking place during the crash as that backup is incomplete. RMAN will find the SCN of the completed backup pieces needed to restore your database, using the SCN in the control file for comparison.

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