| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Shutdown database abort
Hi Shreepad,
For scheduled batch job, I need to shutdown the database regardless whether there are users connected to the system. Hence I use 1) shutdown abort 2) startup normal 3) shutdown normal.
I know if I were to use shutdown immediate or shutdown normal, the database will not be able to shutdown before the backup.
If someone is connected to the database, could shutdown transactional be able to logout the user before shutting down the database ?
Regds,
New Bee
-----Original Message-----
From: Shreepad Vaidya [mailto:Shreepad.Vaidya_at_alltel.com]
Sent: Saturday, May 12, 2001 11:56 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Shutdown database abort
Hi,
Preferably try for
1) Shutdown (normal mode ) .If your application has many
user
connected tell them to disconnect first else this might
take eons.
or
1) shutdown immediate . (Remember this will rollback
transactions ,
but for long uncommitted transactions this will take a long
time) )
As far as possible do not give Shutdown abort
except in
extreme circumstances .
In Oracle 8 onwards
1) Shutdown transactional will allow you to complete the
transaction.
shreepad
To: Shreepad Vaidya/EMEA/ALLTELCORP, ORACLE-L_at_fatcity.com
AT
INTERNET_at_CCMAIL
cc:
Hi,
To shutdown the database for daily backup, I issue the
following
commands :
1) shutdown database abort
2) startup database normal
3) shutdown database normal.
Is this the recommended procedure, could gurus share your
experience ?
Thanks.
Regds,
New Bee
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: CHAN Chor Ling Catherine (CSC)
INET: clchan_at_nie.edu.sg
Fat City Network Services -- (858) 538-5051 FAX: (858)
538-5051
San Diego, California -- Public Internet access /
Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail
message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru')
and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).
You may
also send the HELP command for other information (like
subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Shreepad Vaidya
INET: Shreepad.Vaidya_at_alltel.com
Fat City Network Services -- (858) 538-5051 FAX: (858)
538-5051
San Diego, California -- Public Internet access /
Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail
message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru')
and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).
You may
also send the HELP command for other information (like
subscribing).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: clchan_at_nie.edu.sg Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing ListsReceived on Sat May 12 2001 - 00:31:15 CDT
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
 |
 |