From oracle-l-bounce@freelists.org Wed Mar 3 10:29:33 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i23GTX018259 for ; Wed, 3 Mar 2004 10:29:33 -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 i23GTVo18254 for ; Wed, 3 Mar 2004 10:29:31 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5CB683952B0; Wed, 3 Mar 2004 11:27:57 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 03 Mar 2004 11:26:51 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from issfire6.co.palm-beach.fl.us (issfire6.co.palm-beach.fl.us [151.132.206.241]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4A6FD39522F for ; Wed, 3 Mar 2004 11:26:48 -0500 (EST) Received: from mailsweep3.co.palm-beach.fl.us ([151.132.23.47]) by issfire6.co.palm-beach.fl.us with ESMTP id i23GUTJ8012715 for ; Wed, 3 Mar 2004 11:30:29 -0500 (EST) Received: from ISSFS2.co.palm-beach.fl.us (unverified) by mailsweep3.co.palm-beach.fl.us (Content Technologies SMTPRS 4.3.12) with ESMTP id for ; Wed, 3 Mar 2004 11:30:46 -0500 Received: from PBC PRIMARY DOMAIN-MTA by ISSFS2.co.palm-beach.fl.us with Novell_GroupWise; Wed, 03 Mar 2004 11:30:29 -0500 Message-Id: X-Mailer: Novell GroupWise Internet Agent 6.5.2 Beta Date: Wed, 03 Mar 2004 11:30:19 -0500 From: "Gene Sais" To: , Subject: RE: Archive Mode On for Read Only DB Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="=__Part6D4C660B.0__=" X-archive-position: 182 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Gsais@co.palm-beach.fl.us Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l --=__Part6D4C660B.0__= Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit I have tested a different read only db, backed it up while open and restored, worked fine. Just wondering if archive mode would benefit me and if anyone else is backing up an open read only database using OS utilities? Thanks, Gene >>> DWILLIAMS@LIFETOUCH.COM 3/3/2004 11:18:04 AM >>> Gene - Perhaps someone on the list has directly tried this. It is theoretically possible to get a good backup on a quiet but open database with just a cold backup, but not the sort of thing you want to bet your job on. One idea would be for you to take your backup and restore it on a test system. It is always a good practice to test your database restore anyway. Then you would be assured throughout the year that you do indeed have a valid backup. But I would do it each year since there might be some condition that would make the backup succeed 50% of the time, you would be covered all the time. Dennis Williams DBA Lifetouch, Inc. dwilliams@lifetouch.com -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Gene Sais Sent: Wednesday, March 03, 2004 10:12 AM To: oracle-l@freelists.org; DENNIS WILLIAMS 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 :). 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. Dennis Williams DBA Lifetouch, Inc. dwilliams@lifetouch.com -----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. 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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 ----------------------------------------------------------------- --=__Part6D4C660B.0__= Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Description: HTML
I have tested a different read only db, backed it up while open and = restored, worked fine.  Just wondering if archive mode would benefit = me and if anyone else is backing up an open read only database using OS = utilities?
Thanks,
Gene
>>> DWILLIAMS@LIFETOUCH.COM 3/3/2004 11:18:04 AM = >>>
Gene - Perhaps someone on the list has = directly tried this. It is
theoretically possible to get a good backup = on a quiet but open database
with just a cold backup, but not the sort = of thing you want to bet your job
on. One idea would be for you to take = your backup and restore it on a test
system. It is always a good = practice to test your database restore anyway.
Then you would be = assured throughout the year that you do indeed have a
valid backup. But = I would do it each year since there might be some
condition that would = make the backup succeed 50% of the time, you would be
covered all the = time.



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

-----Original Message-----
From: oracle-l-bounce@= freelists.org [mailto:o= racle-l-bounce@freelists.org]On
Behalf Of Gene Sais
Sent: = Wednesday, March 03, 2004 10:12 AM
To: oracle-l@freelists.org; DENNIS = WILLIAMS
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 = :).

Thanks for your help,
Gene

>>> DWILLIAMS@LIFE= TOUCH.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.


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

-----Original Message-----
From: oracle-l-bounce@freelists.org = [
mailto:oracle-l-bo= unce@freelists.org]On
<mailto:oracle-l-bounce@freelists.org]On>
Behalf Of = Gene Sais
Sent: Wednesday, March 03, 2004 9:04 AM
To: oracle-l@freeli= sts.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. 

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
<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.f= reelists.org/archives/oracle-l/
<http://www.freelists.org/archives/oracle-l/>=
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
<http://www.fr= eelists.org/help/fom-serve/cache/1.html>
-----------------------= ------------------------------------------


---------------------= -------------------------------------------
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-----------------------------------------------------------------
--=__Part6D4C660B.0__=-- ---------------------------------------------------------------- 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 -----------------------------------------------------------------