I think warm start is double shutdown and restart in this way:
oracle@myserver:~> oerr ora 00470 00470, 00000, "LGWR process terminated with error" // *Cause: The log writer process died // *Action: Warm start instance
Sami wrote:Doesn't matter what you do, Oracle db's restart or what is also referred as "bounce" , will always releases the instance's memory allocations. So there cant be any "warm start" possible , doesn't matter what! I believe you must confirm that the term was rightfully used for the database only and not for something else.
I have question from one of client as
Can operations continue uninterrupted during system/DB maintenance (e.g., database compacting)? If system has to be shut down and restart, please specify whether it is Cold Start or Warm Start ..
Am Just confused the difference between cold start & Warm start..
deebee_eh wrote:I think the last time I heard about cold or warm stats was with Oracle 5 and the IOR command - but I see from another reply that ORA-00740 uses the term.
where did you see or hear the context?
Roger Baker wrote:if you write into a file that the Earth is flat, does this change reality?
I'm chiming in a little late on this thread. I have a startup.log file in my ORACLE_HOME that has startup info and it has the history of the database starting and it says they were warm started.