Baanboard.com

Go Back   Baanboard.com > Common DBA Misconceptions

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
35%
Installation Wizard into new VRC
42%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 31

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.

 


0
No votes yet


All times are GMT +2. The time now is 21:16.


©2001-2017 - Baanboard.com - Baanforums.com