From: Joan Hsieh <[EMAIL PROTECTED]>
Chris,
We hang on shutdown immediate, not startup. That's why I choose to use
shutdown abort.
Well, in that case of course you'd use it, but personally, if it was me, I'd
want to find out why it was hanging, and fix that instead. I'
Alas, I'm until recently a prisoner of windows & so I can't speak to shell
scripts. On windows I'd probably try a windows script host vbscript like
so:
Option Explicit
Dim WinShell
Dim jobImmediate
Dim StartTime
Dim ImmediateFa
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:RE: dbshut script - shutdown or shutdown immediate
> -Original Message-
> From: Pardee, Roy E [mailto:[EMAIL PROTECTED]
>
> I would
> have guessed
> tha
Here's how we do it:
We have 2 cron jobs, one of which runs 10 minutes after the first.
The first does a shutdown immediate. The second checks if oracle is running
and, if so, does a shutdown abort.
-Original Message-
Sent: Thursday, April 03, 2003 2:24 PM
To: Multiple recipien
Jacques - We have used SHUTDOWN IMMEDIATE for over 5 years now for cold
backups, with zero problems. Weekend before last we had 3 production
databases that didn't go down for backup (all of our databases scheduled for
cold backups). When I checked the following morning they were just hanging
Title: RE: dbshut script - shutdown or shutdown immediate
> -Original Message-
> From: Pardee, Roy E [mailto:[EMAIL PROTECTED]]
>
> I would
> have guessed
> that optimally, you'd try immediate first & then abort if
> immediate takes
> too long.
Title: RE: dbshut script - shutdown or shutdown immediate
> -Original Message-
> From: Jeremiah Wilton [mailto:[EMAIL PROTECTED]]
>
> ...
>
> So use your test systems, load them up like production, and try both.
> I bet in 9 out of 10 cases, checkpoint+abort
continue... And on a number of occasions, the Sunday reboot actually took the
server down (and brought it up) on Monday mornings when users complained that they
could not get to databases that were shutdown properly with 'shutdown immediate'.
- Kirti
-Original Message
inal-
De: Rachel Carmichael [mailto:[EMAIL PROTECTED]
Enviado el: Miércoles, 02 de Abril de 2003 22:34
Para: Multiple recipients of list ORACLE-L
Asunto: RE: dbshut script - shutdown or shutdown immediate
yeah so? are you suggesting that Oracle instance recovery can't handle
a database crash
f personal preference. The point I am trying to make is if the
situation demands shutdown abort, then it doesn't make sense jumping through
hoops not to use it.
Regards,
Denny
Quoting "Daniel W. Fink" <[EMAIL PROTECTED]>:
> Shutdown Immediate v. Shutdown abort (Tastes Grea
"Nelson, Allan" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
03/04/2003 09:14 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
cc:
Subject: RE: dbshut script - shutdown or shutdown
immediate
that had a job in the job queue that ran frequently enough (and
you WANT monitoring software to monitor things!) that we could never
use a shutdown immediate
--- "Pardee, Roy E" <[EMAIL PROTECTED]> wrote:
> I am certainly not suggesting that recovery can't handle a crash
artin IT
> Extension 8487
>
> -Original Message-
> Sent: Wednesday, April 02, 2003 2:09 PM
> To: Multiple recipients of list ORACLE-L
>
>
> On Wed, 2 Apr 2003, Chris Berry wrote:
>
> > Shutdown abort is pretty drastic, are you sure shutdown immediate
>
Chris,
We hang on shutdown immediate, not startup. That's why I choose to use
shutdown abort.
Joan
Chris Berry wrote:
>
> > > > >"Schauss, Peter" wrote:
> > > > > I have one Oracle instance which supports an application
> > >
how do we minimize it.
I use shutdown abort to increase availability. If you 'alter system
checkpoint' before you shutdown abort, then automatic crash recovery
is extremely fast, since only a few bytes of redo need to be applied.
On the other hand, if you shutdown immediate, you may be w
instance recovery time is more manageable in 9i --
mttr_fast_start_target in the init.ora.
For a time, in version 6, Oracle said you HAD to use shutdown abort,
that a shutdown immediate could corrupt the database (that was an
"undocumented feature")
I've had cases where the reg
PM
> To: Multiple recipients of list ORACLE-L
>
>
> On Wed, 2 Apr 2003, Chris Berry wrote:
>
> > Shutdown abort is pretty drastic, are you sure shutdown immediate
> > didn't work?
>
> What is drastic about shutdown abort?
>
> Never one to opt
cc:
Subject:RE: dbshut script - shutdown or shutdown immediate
Suppose you have a database with a sid of mydb running on unix.
Shutdown abort is like doing the following from the unix command line:
ps -ef | grep mydb | grep -v grep | xargs kill -9. All the processes
that make u
Subject: RE: dbshut script - shutdown or
shutdown immediate
Sent by:
[EMAIL PROTECTED]
o: Multiple recipients of list ORACLE-L
>
>
> On Wed, 2 Apr 2003, Chris Berry wrote:
>
> > Shutdown abort is pretty drastic, are you sure shutdown immediate
> > didn't work?
>
> What is drastic about shutdown abort?
>
> Never one to opt out of a
be functionality.
You can wait for db tasks on shutdown immediate or you can wait for
recovery later. It just depends on when you want to wait and the times
are not always the same. Under some circumstances, immediate may cause
a much very long wait and that can be unacceptable. If you need t
Shutdown Immediate v. Shutdown abort (Tastes Great...Less Filling!)
I'll admit to being in the Immediate camp. Why? I like the database to come down in a
consistent state except in emergency circumstances. There have been bugs related to
shutdown abort causing database problems.
Do those i
>To me it seemed the same as turning off your computer with the power >button instead
>of the shutdown command or using kill -9, sometimes you >have to, but it's not what
>you do normally.
>
>Chris Berry
Sounds practical.
GovindanK
--
|X
st
SWFPAC Lockheed Martin IT
Extension 8487
-Original Message-
Sent: Wednesday, April 02, 2003 2:09 PM
To: Multiple recipients of list ORACLE-L
On Wed, 2 Apr 2003, Chris Berry wrote:
> Shutdown abort is pretty drastic, are you sure shutdown immediate
> didn't work?
What is d
stic, are you sure shutdown immediate
> didn't work?
What is drastic about shutdown abort?
Never one to opt out of a shutdown abort thread,
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
- Uses shutdown abort exclusively
- successful shutdowns/startups: over 10,000
- problems w
From: Jeremiah Wilton <[EMAIL PROTECTED]>
On Wed, 2 Apr 2003, Chris Berry wrote:
> Shutdown abort is pretty drastic, are you sure shutdown immediate
> didn't work?
What is drastic about shutdown abort?
Never one to opt out of a shutdown abort thread,
--
Jeremiah Wilton
http://
Agreed. I admit my English needs some improvement. What i wanted to say was about
rollback but used the words no.of.users. Thanks for pointing out.
GovindanK
Jeremiah Wilton <[EMAIL PROTECTED]> wrote:
>On Wed, 2 Apr 2003, GovindanK wrote:
>
>> Shutdown immediate does roll
http://download-west.oracle.com/docs/cd/A81042_01/DOC/server.816/a76956/onlinere.htm#3981
would be nice reference.
What i was trying to communicate was this: If the log is not multiplexed and the only
log member is not avbl for writing then LGWR cannot write and the db instance will go
down. How
03 2:09 PM
To: Multiple recipients of list ORACLE-L
On Wed, 2 Apr 2003, Chris Berry wrote:
> Shutdown abort is pretty drastic, are you sure shutdown immediate
> didn't work?
What is drastic about shutdown abort?
Never one to opt out of a shutdown abort thread,
--
Jeremiah Wilton
htt
On Wed, 2 Apr 2003, GovindanK wrote:
> Shutdown immediate does rollback and will take time if no.of users
> is high.
Number of users is not the largest contributing factor to shutdown
immediate taking a long time. The longest poles in the tent are large
transaction rollback and laz
On Wed, 2 Apr 2003, Chris Berry wrote:
> Shutdown abort is pretty drastic, are you sure shutdown immediate
> didn't work?
What is drastic about shutdown abort?
Never one to opt out of a shutdown abort thread,
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
- Uses shu
On Wed, 2 Apr 2003, Stephen Murphy wrote:
> We replace the simple shutdown command with:
>
> shutdown immediate
> startup restrict
> alter system switch logfile;
> host sleep 10
> shutdown immediate
Why do you do this elaborate dance? Are
L PROTECTED]>
cc:
Subject:Re: dbshut script - shutdown or shutdown immediate
Multiplexing redo logs has nothing to do with the archive mode. Logs are
multiplexed so that an error writing to one of the members in a group does
not cause the instance to terminate.
Myth - If you us
she tries to shut down the system. The other instances,
> > > which do not support a 24x7 process shut down properly.
> > >
> > > Looking at $ORACLE_HOME/bin/dbshut, I notice that the input to
sqlplus
> > > is
> > > connect internal
> > &g
The scenario you describe would occur regardless of the archive mode. An
active log cannot be archived. This would require that the ARCH process read
the log while LGWR is writing it. Once a log switch occurs (automatic or
manual), the previously active log can be archived.
In this scenario, yo
ality - Mirroring only protects from hardware failure. It will not
> >protect you from accidental deletion of the log (been there, had to fix
> >it!).
> >
> >--
> >Daniel W. Fink
> >http://www.optimaldba.com
> >
> >GovindanK wrote:
> >
re, had to fix
>it!).
>
>--
>Daniel W. Fink
>http://www.optimaldba.com
>
>GovindanK wrote:
>
>>>Shutdown abort is pretty drastic, are you sure shutdown immediate didn't
>>>work?
>>>
>>>
>>
>>Well said. This topic has been cir
At first, we do shutdown immediate, then startup. But we do have couple
times hang there and couldn't do the cold backup. Since changed to
shutdown abort, startup and shutdown immediate, we don't have any
problem at all. our database is in archive mode. Since our production
database has
rsday, May 1 1:00pm - 2:00pm - Automatic Undo Internals
GovindanK wrote:
Shutdown abort is pretty drastic, are you sure shutdown immediate didn't
work?
Well said. This topic has been circulating in many DBA forums for a long time. Shutdown immediate does rollback and will ta
>Shutdown abort is pretty drastic, are you sure shutdown immediate didn't
>work?
Well said. This topic has been circulating in many DBA forums for a long time.
Shutdown immediate does rollback and will take time if no.of users
is high. On the otherside, shutdown abort simply takes
PROTECTED]
[EMAIL PROTECTED] cc:
om Subject: RE: dbshut script - shutdown or
shutdown
s,
> which do not support a 24x7 process shut down properly.
>
> Looking at $ORACLE_HOME/bin/dbshut, I notice that the input to sqlplus
> is
> connect internal
> shutdown
>
> Should I modify the script to "shutdown immediate" so that it kills
&g
On Wed, 2 Apr 2003, [EMAIL PROTECTED] wrote:
> Then, while bringing up, we do
>
> startup restrict;
> shutdown immediate;
> startup
Why? Doesn't it start up fine the first time?
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
--
Please see the officia
We replace the simple shutdown command with:
shutdown immediate
startup restrict
alter system switch logfile;
host sleep 10
shutdown immediate
We recently installed 9.2.0.2-64bit on AIX. As of that release, Oracle is
still shipping dbshut with simply
;
shutdown abort;
Then, while bringing up, we do
startup restrict;
shutdown immediate;
startup
Rao
-Original Message-
Sent: Wednesday, April 02, 2003 11:34 AM
To: Multiple recipients of list ORACLE-L
Peter,
I modified to shutdown abort, starup then shutdown immediate.
joan
she tries to shut down the system. The other instances,
which do not support a 24x7 process shut down properly.
Looking at $ORACLE_HOME/bin/dbshut, I notice that the input to sqlplus
is
connect internal
shutdown
Should I modify the script to "shutdown immediate" so tha
We do shutdown abort. But we do checkpoint before shutdown abort i.e,
alter system checkpoint;
shutdown abort;
Then, while bringing up, we do
startup restrict;
shutdown immediate;
startup
Rao
-Original Message-
Sent: Wednesday, April 02, 2003 11:34 AM
To: Multiple recipients of
Peter,
Shutdown immediate would be a better choice. Might also be a good idea to
have the app server process stopped prior to the database instance being
shutdown.
I have seen apps that have left ghost connections or go nuts when the
database disappeared (bad error handling I guess).
david
Peter,
I modified to shutdown abort, starup then shutdown immediate.
joan
"Schauss, Peter" wrote:
>
> I have one Oracle instance which supports an application
> server which always maintains a database connection.
> The UNIX system administrator tells me that this instan
Peter:
One of the first things we do after installing Oracle is
to modify dbshut to 'shutdown immediate'. We have
had no side-effects from this change.
Cheers,
Mike
-Original Message-
Sent: Wednesday, April 02, 2003 7:04 AM
To: Multiple recipients of list ORACLE-L
I have
.
Looking at $ORACLE_HOME/bin/dbshut, I notice that the input to sqlplus
is
connect internal
shutdown
Should I modify the script to "shutdown immediate" so that it kills
any connections?
Environment is Oracle 8.1.7 /AIX 4.3.3.
Thanks,
Peter Schauss
Northrop Grumman C
ge transactions that need commit/rollback prior to
> shutdown
>
> 4. Look for which processes are still alive during the shutdown,
> use
> lsof to trace them back to the client app OR select a list of
> sessions
> and their respective processes prior to shutdown
>
> 5. F
DENNIS WILLIAMS wrote:
We have been running Oracle 8.1.6 unchanged for several years. Within the
past 3 days, our cold backup scripts have had a shutdown immediate hang. In
the alert log the message is:
Shutting down instance (immediate)
Sun Mar 23 00:09:10 2003
SHUTDOWN: waiting for active
tions that need commit/rollback prior to
shutdown
4. Look for which processes are still alive during the shutdown, use
lsof to trace them back to the client app OR select a list of sessions
and their respective processes prior to shutdown
5. Forget about shutdown immediate, use shutdown abort.
-
alive during
> the shutdown, use
> lsof to trace them back to the client app OR select
> a list of sessions
> and their respective processes prior to shutdown
>
> 5. Forget about shutdown immediate, use shutdown
> abort.
>
> --
> Jeremiah Wilton
> http://www.spe
rge transactions that need
> commit/rollback prior to
> shutdown
>
> 4. Look for which processes are still alive during
> the shutdown, use
> lsof to trace them back to the client app OR select
> a list of sessions
> and their respective processes prior to shutdown
>
&
eed commit/rollback prior to
shutdown
4. Look for which processes are still alive during the shutdown, use
lsof to trace them back to the client app OR select a list of sessions
and their respective processes prior to shutdown
5. Forget about shutdown immediate, use shutdown abort.
--
Jeremiah W
We have been running Oracle 8.1.6 unchanged for several years. Within the
past 3 days, our cold backup scripts have had a shutdown immediate hang. In
the alert log the message is:
Shutting down instance (immediate)
Sun Mar 23 00:09:10 2003
SHUTDOWN: waiting for active calls to complete
Or, if you don't want all your pagers going off because OEM thinks that all
the instances on that server are down when it loses contact with the IA, on
Unixishes you can:
ps -ef|grep oracle$ORACLE_SID|grep -v grep
...from another session after starting the SHUTDOWN IMMEDIATE.
recipients of list ORACLE-L
> Two things to check:
>
> 1. Check dba_jobs to see if any jobs are running like an analyze. I've
had
> this happen to me. I tried to do a shutdown immediate but database is
> waiting for analyze job to finish (several hours).
>
> 2. Check if intellig
list to enlighten
us :)
-
Seán O' Neill
Organon (Ireland) Ltd.
[subscribed: digest mode]
>>From: Ravi Kulkarni <[EMAIL PROTECTED]>
>> Date: Sat, 5 Oct 2002 02:01:58 -0400
>> Subject: Shutdown Immediate
>>
>>Gurus,
>>
>>Solaris8/Oracle 8173-32bit.
&g
> Two things to check:
>
> 1. Check dba_jobs to see if any jobs are running like an analyze. I've had
> this happen to me. I tried to do a shutdown immediate but database is
> waiting for analyze job to finish (several hours).
>
> 2. Check if intelligent age
Two things to check:
1. Check dba_jobs to see if any jobs are running like an analyze. I've had
this happen to me. I tried to do a shutdown immediate but database is
waiting for analyze job to finish (several hours).
2. Check if intelligent agent is running. You should shutdown intell
Define hang.
In other words, how much time passes before you consider it a hang?
SHUTDOWN IMMEDIATE can take some time.
Our SAP admin got impatient last week and did a SHUTDOWN ABORT
on a database cuz she thought the SHUTDOWN IMMEDIATE was taking
too long.
Files were in need of recovery
te:
> Gurus,
>
> Solaris8/Oracle 8173-32bit.
> Shutdown abort works but Shutdown immediate hangs. Startup Normal is
> fine.
> No special entries in Alert log regarding smon/pmon
> activities-postStartup/During Shutdown. All DB Sessions/connections
> cleaned/killed before shut
Gurus,
Solaris8/Oracle 8173-32bit.
Shutdown abort works but Shutdown immediate hangs. Startup Normal is fine.
No special entries in Alert log regarding smon/pmon
activities-postStartup/During Shutdown. All DB Sessions/connections
cleaned/killed before shutdown. Tried several times.
Any Hints
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE
temp;
Muthar
Ahmed
DBA
-Original Message-From: Steve Perry
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, August 21, 2002 11:13
PMTo: Multiple recipients of list ORACLE-LSubject:
Shutdown Immediate Hanging
I hope somebody can he
need to shutdown) to not use shutdown immediate -
because they got the name wrong :-) If you need to
shutdown, I'd just do:
alter system checkpoint;
shutdown abort
hth
connor
--- Steve Perry <[EMAIL PROTECTED]> wrote: >
MessageI hope somebody can help me with this
> shutdown p
have intermittent shutdown
problems.
The shutdown never
completes.
Here's are the steps used to stop the
database
1.) Stop the application
servers
1.) run a kill session script to kill
all remaining sessions except the one running the script
2.) issue shutdown immediate and hope
it shuts down.
On Mon, 10 Sep 2001, [EMAIL PROTECTED] wrote:
> One correction, shutdown immediate waits till all uncommitted
> transactions are committed or rolled back. The client session must
> do one or the other, otherwise the shutdown hangs waiting for the
> end user.
No, that's shutd
Dave,
We've periodically had this problem with various jobs that
were running at the time of the shutdown immediate. I try
to isolate the cause by killing the various processes I still
see running via ps -ef | grep SID.
Sometimes the problem has been our RMAN backup that
is ru
Jon,
One correction, shutdown immediate waits till all uncommitted transactions
are committed or rolled back. The client session must do one or the other,
otherwise the shutdown hangs waiting for the end user. This is a good example
of where setting the idle time in user_profiles is a good
Dave:
The message in the alert log means that there are uncommitted transactions.
During a shutdown immediate uncommitted transactions are rolled back and
Oracle must wait until this rollback is complete before the db can be
actually shut down.
You could do a shutdown abort, but then you would
Dave,
Worth Checking -
Sometimes the OracleAgent service or the OracleDataGatherer
service, if running, will cause the SHUTDOWN IMMEDIATE to hang. Try
shutting such services down by including a 'net stop OracleAgent..'
etc. in your script, just before you issue the SHUTDOWN IMMED
I have Oracle 8.1.7 running on windoze NT 4.0. Every night I have a script
that kicks off a cold backup. Part of the script issues the command
SHUTDOWN IMMEDIATE
which normally works just fine before I actually copy my files. However,
periodically the "shutdown immediate" comman
Title: RE: shutdown immediate
I am
at Oracle 8.0.5 AIX 4.3.2
should
I upgrade my Oracle db to get
a good
shutdown immediate?
-Original Message-From: Behar, Rivaldi
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, May 09,
2001 2:46 PMTo: Multiple recipients of list
ORACLE
Title: RE: shutdown immediate
I had experienced the same problem. That was because of rolling back in progress. 'Select used_ublk from v$transaction' should return no rows. Wait until that query return no rows.
It's bugs if you are using 805.
Rivaldi
-Original Me
Joseph
If you are using Novell as your OS then a memory leak that exists in older versions
of Novell might be the problem. The message mixed in with the output messages stated
that a lot of resources were not released. The upgrade to Novell 4.2 appears to have
solved the shutdown problem for u
Sometimes the instance never shuts down,
BUT the database gets closed. What else could
hang up SVRMGRL ?
TIA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Leyden, Joseph
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
Sa
79 matches
Mail list logo
