shutdown immediate is too slow [message #147412] |
Thu, 17 November 2005 09:15 |
lazycat
Messages: 57 Registered: November 2005
|
Member |
|
|
QL*Plus: Release 9.2.0.4.0 - Production on Thu Nov 17 20:59:16 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserve
SQL> shutdown immediate
but it is too slow
how to
|
|
|
|
Re: shutdown immediate is too slow [message #147447 is a reply to message #147412] |
Thu, 17 November 2005 11:17 |
nmacdannald
Messages: 460 Registered: July 2005 Location: Stockton, California - US...
|
Senior Member |
|
|
Try shutdown abort - it will be MUCH quicker. However, you need a normal shutdown(shutdown) to get a cold backup. You should only do shutdown abort to kick people off and the database down quickly, then shutdown the listener(lsnrctl stop) and startup the database(startup), let it do its recovery, then (shutdown).
[Updated on: Thu, 17 November 2005 11:20] Report message to a moderator
|
|
|