| 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: is shutdown immediate adequate for consistent cold backup?
Yeah and I know who displaced that assumption...... :)
shutdown immediate SHOULD be sufficient, since in theory it does do rollback before shutting down (which is why sometimes it seems to take forever). But I'd rather be safe and know that I had a really clean shutdown before a cold backup.
Just my opinion.
Rachel
>From: Paul Drake <drake_at_psscorp.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: is shutdown immediate adequate for consistent cold backup?
>Date: Wed, 06 Dec 2000 08:50:54 -0800
>
><set feedback on>
>
>I had an assumption displaced today. Not a big one, but I might be making
>some changes tomorrow.
>(tonight I was under the hood of the development server, upping
>db_block_lru_latches =2, and db_writer_processes = 2), etc.
>
>Some time ago - I had read in some Oracle doc somewhere, that a shutdown
>immediate was sufficient before performing a cold backup. I used to do a
>(stop listener) shutdown immediate, startup (restrict if I felt evil) and
>shutdown normal. When I re-wrote for 8.1.6 - I just used shutdown
>immediate.
>
>I've had databases recovered (successfully) off of the shutdown immediate
>method.
>Is it just that there is an outside chance that shutdown immediate prior to
>backup could leave some type of garbage behind?
>
>Please note that the words 'shutdown abort' were not used in this little
>firestarter before replying.
>
>thanks,
>
>Paul
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Paul Drake
> INET: drake_at_psscorp.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).
 |
 |