Re: Hot and Cold backups

the reality is ... on an MS win32 OS ... that if one has not bumped up the WaitToKillSerivceTimeout value in the registry ... that while the instance is attempting to complete a shutdown immediate ... that if the shutdown occurred via a "NET STOP OracleService%ORACLE_SID%" command ... that a clean shutdown would not have been completed prior to the cold backup, and recovery using the current online redo log would be required at instance startup, and in the event that the cold backup set was used (restored).
so don't run a cold backup of oracle on windows using a NET STOP to shutdown the instance - script it in sqlplus so that it waits properly - or perform a shutdown abort/startup restrict/shutdown immediate in the shutdown script.

(this falls under the general subject of things that have been covered so many times that I find the subject frustrating).

-bdbafh Received on Wed Jul 13 2005 - 18:29:43 CDT