Startup force followed by shutdown immediate is what we use. We have not
had any problems with it yet.
-Original Message-
startup force?
What is your experience about it?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL
Jared,
startup force?
What is your experience about it?
One time my colleague DBA used it on Production and result was
1)some table corruption
2) Not removing memory segment (ipcs -mb was showing 2 segments of same SGA
as original was not removed).
3)Utlimate solution was to reboot the box
detail about 'shutdown abort'
or 'startup force'. Maybe on MetaLink somewhere.
HTH.
Jared
M Rafiq [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/30/2003 01:53 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject
abort; startup'.
Useful for starting crashed instances, and bouncing
recalcitrant instances that don't respond to
'shutdown immediate'.
The docs don't go into too much detail about 'shutdown abort'
or 'startup force'. Maybe on MetaLink somewhere.
HTH.
Jared
M Rafiq [EMAIL PROTECTED]
Sent
I am wrong...
http://www.wolfenet.com/~jeremiah/241.pdf
Startup force, on the other hand, I would never use this unless I had a high
level oracle support engineer holding my hand.
-Original Message-
From: Mark Leith [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, February 07, 2001 8:01 AM
. The other forms of shutdown take too long, and may never complete
if you have long running transactions that don't do frequent commits.
Check out the following paper if you think I am wrong...
http://www.wolfenet.com/~jeremiah/241.pdf
Startup force, on the other hand, I would never use this unless I had
that don't do frequent commits.
Check out the following paper if you think I am wrong...
http://www.wolfenet.com/~jeremiah/241.pdf
Startup force, on the other hand, I would never use this unless I had a high
level oracle support engineer holding my hand.
-Original Message-
From: Mark Leith
out the following paper if you think I am wrong...
http://www.wolfenet.com/~jeremiah/241.pdf
Startup force, on the other hand, I would never use this unless I had a high
level oracle support engineer holding my hand.
-Original Message-
From: Mark Leith [SMTP:[EMAIL PROTECTED]]
Sent
:
When do a DBA prefers to use STARTUP FORCE than SHUTDOWN
ABORT+STARTUP NORMAL ?
--Neena
--
Joe Testa http://www.oracle-dba.com
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
--
Please see