Hi Raj,
SHUTDOWN IMMEDIATE will close all the running process. So commit would not
happen for all processes.
Where as the other will shut down after commiting and all archivelog files
will be closed before shutdown.
Hope this clearifies to a extend.
Regards,
Selva.
"raj " <oracledba-ezmlmshield-x93559656.[Email address protected]
02/12/08 12:14 PM
To
"LazyDBA Discussion" <[Email address protected]
cc
Subject
Alter database cose
Hi DBA Gurus
Good Moring to Every Body
I am new to oracle Admin works
I have seen the ALTER DATABASE CLOSE AND ALTER DATABASE DISMOUNT
what is use of these statements over SHUTDOWN IMMEDIATE OR NORMAL
Thanks & Regards,
V. RajaVardhan Reddy
Database Administrator
GSS America Infotech Ltd
Third Floor, Block 'B',
Cyber Gateway, HITEC City, Madhapur,
Hyderabad - 500 081. AP. India
Visit us: http://www.gssamerica.com
_________________________________________________________________________________________________
Top Diversity Owned Businesses in Illinois (Div100State-2004)
Disclaimer
This message contains confidential information and is intended only for
the individual named. If you are not the named addressee you should not
disseminate, distribute or copy this e-mail. Please notify the sender
immediately by e-mail if you have received this e-mail by mistake and
delete this e-mail from your system. E-mail transmission cannot be
guaranteed to be secure or error-free as information could be intercepted,
corrupted, lost, destroyed, arrive late or incomplete, or contain viruses.
The sender therefore does not accept liability for any errors or omissions
in the contents of this message, w
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
This e-Mail may contain proprietary and confidential information and is sent for the intended recipient(s) only. If by an addressing or transmission error this mail has been misdirected to you, you are requested to delete this mail immediately. You are also hereby notified that any use, any form of reproduction, dissemination, copying, disclosure, modification, distribution and/or publication of this e-mail message, contents or its attachment other than by its intended recipient/s is strictly prohibited.
Visit us at http://www.polaris.co.in
Oracle LazyDBA home page