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.
-Mark
-- --Original Message-- --
From: Gene Sais [mailto:Gsais@(protected)]
Sent: Wednesday, March 03, 2004 11:12 AM
To: oracle-l@(protected); DWILLIAMS@(protected)
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@(protected) 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@(protected)
-- --Original Message-- --
From: oracle-l-bounce@(protected) [ mailto:oracle-l-bounce@(protected)]On
Behalf Of Gene Sais
Sent: Wednesday, March 03, 2004 9:04 AM
To: oracle-l@(protected)
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@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN " >
<HTML > <HEAD >
<META HTTP-EQUIV= "Content-Type " CONTENT= "text/html; charset=iso-8859-1 " >
<META content= "MSHTML 6.00.2713.1100 " name=GENERATOR > </HEAD >
<BODY style= "MARGIN: 4px 4px 1px; FONT: 10pt Arial " >
<DIV > <SPAN class=046141516-03032004 >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. </SPAN > </DIV >
<DIV > <SPAN class=046141516-03032004 > </SPAN > </DIV >
<DIV > <SPAN class=046141516-03032004 >-Mark </SPAN > </DIV >
<BLOCKQUOTE dir=ltr style= "MARGIN-RIGHT: 0px " >
<DIV class=OutlookMessageHeader dir=ltr align=left > <FONT
face=Tahoma >-- --Original Message-- -- <BR > <B >From: </B > Gene Sais
[mailto:Gsais@(protected)] <BR > <B >Sent: </B > Wednesday, March 03, 2004
11:12 AM <BR > <B >To: </B > oracle-l@(protected);
DWILLIAMS@(protected) <BR > <B >Subject: </B > RE: Archive Mode On for Read Only
DB <BR > <BR > </FONT > </DIV >
<DIV >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 :). </DIV >
<DIV > </DIV >
<DIV >Thanks for your help, </DIV >
<DIV >Gene <BR > <BR >>>> DWILLIAMS@(protected) 3/3/2004 10:47:26 AM
>>> <BR > </DIV >
<DIV style= "COLOR: #000000 " >Gene - By read only, do you mean the contents of
the database are never <BR >changing? Do you ever take it out of read only mode,
like to change <BR >something? Why back it up occasionally? Just do a cold
backup once and save <BR >the tapes. <BR > <BR > <BR > <BR >Dennis
Williams <BR >DBA <BR >Lifetouch, Inc. <BR >dwilliams@(protected)
<BR > <BR >-- --Original Message-- -- <BR >From: oracle-l-bounce@(protected) [ <A
href= "mailto:oracle-l-bounce@(protected)]On " >mailto:oracle-l-bounce@(protected)]On </A > <BR >Behalf
Of Gene Sais <BR >Sent: Wednesday, March 03, 2004 9:04 AM <BR >To:
oracle-l@(protected) <BR >Subject: Archive Mode On for Read Only
DB <BR > <BR > <BR >I have an 8i read only database that is used for query of
images. <BR >Occassionally, I back it up using OS utilities (cp, tar, TSM, etc)
while the <BR >db is open. <BR > <BR >Question: Is there any benefit to
having this db in archive log mode? Since <BR >it is in read only mode, I
see no benefit or am I missing something? <BR > <BR >Thanks for any insight you
may
provide, <BR >Gene <BR > <BR >-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------ <BR >Please
see the official ORACLE-L FAQ: <A
href= "http://www.orafaq.com " >http://www.orafaq.com </A > <BR >-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------ <BR >To
unsubscribe send email to: oracle-l-request@(protected) <BR >put
'unsubscribe ' in the subject line. <BR >-- <BR >Archives are at <A
href= "http://www.freelists.org/archives/oracle-l/ " >http://www.freelists.org/archives/oracle-l/ </A > <BR >FAQ
is at <A
href= "http://www.freelists.org/help/fom-serve/cache/1.html " >http://www.freelists.org/help/fom-serve/cache/1.html </A > <BR >-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- -- <BR > </DIV > </BLOCKQUOTE > </BODY > </HTML >
