Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Archive Mode On for Read Only DB
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_at_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_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 10:12 AM
To: oracle-l_at_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_at_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_at_lifetouch.com
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [
mailto:oracle-l-bounce_at_freelists.org]On
<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
-- Archives are at http://www.freelists.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.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_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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 - 10:29:33 CST