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:[EMAIL PROTECTED]]
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, [EMAIL PROTECTED]
AT
INTERNET@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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
