RE: Archive Mode On for Read Only DB

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Wed, 3 Mar 2004 09:47:26 -0600
Message-ID: <0186754BC82DD511B5C600B0D0AAC4D607B000C6@EXCHMN3>

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_at_lifetouch.com

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Gene Sais
Sent: Wednesday, March 03, 2004 9:04 AM
To: oracle-l_at_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_at_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


-----------------------------------------------------------------

Received on Wed Mar 03 2004 - 09:47:04 CST