| 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: To Cycle or Not to Cycle : That is the question
This is a multi-part message in MIME format.
--------------1A6DC2CC82379C7CC4E4FA3A Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit
Pat,
An Oracle Instance (at least on an UNIX box) has no problem running for quite an
extented period of time. However, in the case of recycling the physical box,
you should check Metalink. A bug was posted concerning boxes that were up > 248
days.
---Bill Gentry
gentry_at_allina.com
Pat Howe - Contractor wrote:
> I would like to see some dialog on the following issue :
> Is there a "need" to cycle an Oracle database ? and if so how frequently ?
>
> IE;
> Can you and should you keep a Oracle database up and running continually for
> 3, 6,..months?
>
> I have always thought that it is a good idea to recycle an instance weekly
> (if you can) to cleanup memory and take a cold backup.
> >From a server perspective (SUN SPARC SOLARIS) I do not have any
> pre-conceived ideas and have left this up to the SA's to decide.
>
> The shop I am currently at performs hot backups and does not have a
> scheduled cycle of the databases or the servers. In fact they want to avoid
> re-cycling the box because of problems they have had in the past with the
> disk drives not spinning back up (if there is a planned outage they make
> sure they have a hardware techie on site and a good backup). They have had
> one database up and running for 3 months.
>
> Is this the norm ??
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Pat Howe - Contractor
> INET: pat.howe_at_Terabeam.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).
--------------1A6DC2CC82379C7CC4E4FA3A
Content-Type: text/x-vcard; charset=us-ascii;
name="gentry.vcf"
Content-Transfer-Encoding: 7bit Content-Description: Card for Bill Gentry Content-Disposition: attachment;
begin:vcard
n:Gentry;Bill
tel;fax:612-775-1161
tel;work:612-775-1190
x-mozilla-html:FALSE
org:ALLINA HEALTH SYSTEM
adr:;;1375 Willow Street;Minneapolis;MN;55403;
version:2.1
email;internet:gentry_at_allina.com
title:ORACLE DBA
fn:Bill Gentry
Received on Fri Dec 08 2000 - 10:50:29 CST
 |
 |