1. First shutdown abort
2.Start the database
3.Shutdown immediate
4.take a cold backup
"Patterson Joel "
<oracledba-ezmlmshield-x39670960.[Email address protected]
06/29/2005 04:23 AM
To
"LazyDBA Discussion" <[Email address protected]
cc
Subject
RE: Shutdown immediate Problem
Yes, sometimes some dbms_jobs, or cron jobs could be running... rebuilding
indexes, gathering database statisitics or backups. (well maybe backups
don't count), but some of these will cause you to wait.
-----Original Message-----
From: Shergill Gurmohan [mailto:oracledba-ezmlmshield-x76131991.[Email
address protected]
Sent: Tuesday, June 28, 2005 10:19 AM
To: LazyDBA Discussion
Subject: RE: Shutdown immediate Problem
Mr. Schulz's suggestion is a very valid suggestion and you may want to
consider if some huge transaction was being rolled back at the time
shutdown immediate was issued, but if Mr. Schulz's suggestion is not the
case then consider this.
'I recently ran into a similar issue and found that one of the oracle
background process was not shutting down completely. When one of the
oracle background process hangs oracle can't complete the shutdown process
and stay confused with or without stating what is going on. Please check
if this is not the case with you. Go to the operating system and check for
remaining oracle background processes, if any. Alternately look for any
special or related entries in alert log and trace files during this time.'
Gurmohan
www.onlymath.com
-------------------------------------------------------------------------------
-----Original Message-----
From: "Rüdiger J. Schulz"
[mailto:oracledba-ezmlmshield-x83404444.[Email address protected]
Sent: Tuesday, June 28, 2005 8:11 AM
To: LazyDBA Discussion
Subject: Re: Shutdown immediate Problem
it's possible, that the hanging session takes a long time rollback.
hth
Rüdiger J. Schulz
sosys-berlin.de
jayeshrshah schrieb:
>Dear Guru
>
>when i gave command "sql>shutdown immediate" the session has been in
hang
>& not going proper.
>
>So i can not take cold backup
>
>Please reply soon why it happend?
>
>Thanks in advance
>regards,
>
>Jayesh shah
>
>
>
>
>
>--------
>website: http://www.LazyDBA.com
>Please don't reply to RTFM questions
>Oracle documentation is here: http://tahiti.oracle.com
>To unsubscribe: see http://www.lazydba.com/unsubscribe.html
>To subscribe: see http://www.lazydba.com
>By using this list you agree to these terms:http://www.lazydba.com/legal.html
>
>
>
>
>
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page