Go Back > Common DBA Misconceptions

User login

Frontpage Sponsor


As a Customer What would do to keep your ERP Implementation intact
Proactively define Business Process-- Take the Project Ownership
Handover everything to System Integrator from drawing BP till implementation of ERP
Hire more inhouse skilled & capable IT Resource to work directly with SI
Rely on SI Architects/Consultants
Total votes: 4

Baanboard at LinkedIn

Reference Content

Book Navigation

Backup & Recovery: Media recovery will be required in the case of instance failure during backup mode
By patvdv at 23 Feb 2008 - 22:50

If an instance crashes or is aborted while one of the tablespaces is in backup mode, the tablespace(s) will appear to need media recovery upon startup. In normal instance failure situations, automatic crash recovery using the online redologs will be automatically performed, with no intervention required.


Because hot backup mode artificially freezes the checkpoint SCN in the datafile header, it will appear on startup after a crash to be a file restored from backup. Consequently, Oracle will suggest that you apply archived redologs from the time that the tablespace was placed in backup mode. As we learned in the previous section on hot backup mode, the only difference between a datafile in backup mode and not in backup mode is the checkpoint SCN in the header. Because there is no data missing from the datafile, there is no need to apply recovery to it. For this reason, Oracle provides a way to clear the hot backup flags in the datafile header before you open the database.


If an instance will not start up automatically after a failure, and the reason is that a datafile needs recovery, then the v$backup view may be queried from mount mode. This view will show which datafiles are in backup mode. Based on this information, the following command may be used to take the files out of backup mode:


alter database datafile <filenum> end backup;

Many DBAs create their own startup and shutdown scripts that improve on Oracle�s dbstart and dbshut scripts by introducing exception handling and other important features. A good feature to add to any database startup script is the ability to take files out of backup mode. By having scripts that handle simple common complications, overall stability may be improved.


No votes yet

All times are GMT +2. The time now is 05:38.

©2001-2018 - -