From oracle-l-bounce@freelists.org Wed Mar 3 10:15:14 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i23GFEP14388 for ; Wed, 3 Mar 2004 10:15:14 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i23GFDo14378 for ; Wed, 3 Mar 2004 10:15:13 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 637FF394AAA; Wed, 3 Mar 2004 11:13:53 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 03 Mar 2004 11:12:31 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from tera.umi.com (tera.umi.com [192.195.245.144]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C465C395196 for ; Wed, 3 Mar 2004 11:12:28 -0500 (EST) Received: from bosmail02.bos.il.pqe (bosmail02.bos.il.pqe [172.24.3.66]) by tera.umi.com (8.11.6/8.11.6) with ESMTP id i23GGJ913975 for ; Wed, 3 Mar 2004 11:16:19 -0500 Received: from bosmail00.bos.il.pqe ([172.24.3.64]) by bosmail02.bos.il.pqe with Microsoft SMTPSVC(5.0.2195.6713); Wed, 3 Mar 2004 11:16:19 -0500 X-MimeOLE: Produced By Microsoft Exchange V6.0.6249.0 content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C4013A.DC69E096" Subject: RE: Archive Mode On for Read Only DB Date: Wed, 3 Mar 2004 11:16:19 -0500 Message-ID: <4C9B6FDA0B06FE4DAF5918BBF0AD82CF03B4530A@bosmail00.bos.il.pqe> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Archive Mode On for Read Only DB Thread-Index: AcQBOmPMSLsoMehbR0qZ/DGQts/8DAAAFHRA From: "Bobak, Mark" To: X-OriginalArrivalTime: 03 Mar 2004 16:16:19.0439 (UTC) FILETIME=[DC9F87F0:01C4013A] X-archive-position: 177 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Mark.Bobak@il.proquest.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l ------_=_NextPart_001_01C4013A.DC69E096 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Given your circumstances, I see no benefit to archive log mode. As = Dennis recommended, just back it up once a year and save the tapes. No = point in archivelog mode or more frequent backups. =20 -Mark -----Original Message----- From: Gene Sais [mailto:Gsais@co.palm-beach.fl.us] Sent: Wednesday, March 03, 2004 11:12 AM To: oracle-l@freelists.org; DWILLIAMS@LIFETOUCH.COM Subject: RE: Archive Mode On for Read Only DB Dennis - The database is opened in read only mode. The database changes = once a yr to be updated w/ new images. At that time, I put the db in = read write mode, add the images, then open db in read only and back it = up while db is open. It is a web query db that I would like to minimize = down time. Is there any benefit to putting this db in archive log mode? = I don't see any, but I may be missing something :). =20 Thanks for your help, Gene >>> DWILLIAMS@LIFETOUCH.COM 3/3/2004 10:47:26 AM >>> Gene - By read only, do you mean the contents of the database are never changing? Do you ever take it out of read only mode, like to change something? Why back it up occasionally? Just do a cold backup once and = save the tapes.=20 Dennis Williams DBA Lifetouch, Inc. dwilliams@lifetouch.com=20 -----Original Message----- From: oracle-l-bounce@freelists.org [ = mailto:oracle-l-bounce@freelists.org]On Behalf Of Gene Sais Sent: Wednesday, March 03, 2004 9:04 AM To: oracle-l@freelists.org Subject: Archive Mode On for Read Only DB I have an 8i read only database that is used for query of images. Occassionally, I back it up using OS utilities (cp, tar, TSM, etc) while = the db is open. =20 Question: Is there any benefit to having this db in archive log mode? = Since it is in read only mode, I see no benefit or am I missing something? Thanks for any insight you may provide, Gene ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ------_=_NextPart_001_01C4013A.DC69E096 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Given your circumstances, I see no = benefit=20 to archive log mode.  As Dennis recommended, just back it up once a = year=20 and save the tapes.  No point in archivelog mode or more frequent=20 backups.
 
-Mark
-----Original Message-----
From: Gene Sais=20 [mailto:Gsais@co.palm-beach.fl.us]
Sent: Wednesday, March = 03, 2004=20 11:12 AM
To: oracle-l@freelists.org;=20 DWILLIAMS@LIFETOUCH.COM
Subject: RE: Archive Mode On for = Read Only=20 DB

Dennis - The database is opened in read only mode.  The = database=20 changes once a yr to be updated w/ new images.  At that time, I = put the=20 db in read write mode, add the images, then open db in read only and = back it=20 up while db is open.  It is a web query db that I would like to = minimize=20 down time.  Is there any benefit to putting this db in archive = log=20 mode?  I don't see any, but I may be missing something :).
 
Thanks for your help,
Gene

>>> DWILLIAMS@LIFETOUCH.COM 3/3/2004 = 10:47:26 AM=20 >>>
Gene - By read only, do you mean the = contents of=20 the database are never
changing? Do you ever take it out of read = only mode,=20 like to change
something? Why back it up occasionally? Just do a = cold=20 backup once and save
the tapes.



Dennis=20 Williams
DBA
Lifetouch, Inc.
dwilliams@lifetouch.com=20

-----Original Message-----
From: = oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@f= reelists.org]On
Behalf=20 Of Gene Sais
Sent: Wednesday, March 03, 2004 9:04 AM
To:=20 oracle-l@freelists.org
Subject: Archive Mode On for Read Only=20 DB


I have an 8i read only database that is used for query = of=20 images.
Occassionally, I back it up using OS utilities (cp, tar, = TSM, etc)=20 while the
db is open. 

Question: Is there any benefit = to=20 having this db in archive log mode?  Since
it is in read only = mode, I=20 see no benefit or am I missing something?

Thanks for any = insight you=20 may=20 = provide,
Gene

-------------------------------------------------= ---------------
Please=20 see the official ORACLE-L FAQ: http://www.orafaq.com
-------------= ---------------------------------------------------
To=20 unsubscribe send email to:  oracle-l-request@freelists.org
put = 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists= .org/archives/oracle-l/
FAQ=20 is at http://www.= freelists.org/help/fom-serve/cache/1.html
------------------------= -----------------------------------------
------_=_NextPart_001_01C4013A.DC69E096-- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------