===
If you think education is expensive, try ignorance. (Derek Bok)
===
At 10:41 PM 3/4/2004, you wrote:
>There are a few things one can NOT do when the DB is in NOArchiveLog, for
>example take a tablespace offline without a checkpoint (OFFLINE IMMEDIATE).
>The fake recovery trick is also dependent on Archivelog mode.
>
>Again, considering that the DB is read only (and it is allowed to do the ALTER
>DATABASE OPEN READ ONLY that hasnt been/seen any Standby stuff - tested on 92,
>and it is in my 816 docs onwards) then you cant switch logfiles (ORA-16000 (See ORA-16000.ora-code.com)).
>If I crash a DB (shutdown abort) in READ ONLY mode there is no recovery during
>the next startup. That proves you can take a "cold " backup of a READ ONLY DB
>without fear.
>
>The long and short of it - IMHO - drop the archive log mode, drop the backups
>and do one (OK, two copies if you really want to) simple cold backup after you
>have loaded fresh data and are back in READ ONLY mode.
>
>Still, its only my opinion - its your job/data, Gene.
>
>Michael M?ller, Miracle
>
>Carel-Jan Engel wrote:
>
> > As far is I know and can think of, there is no added value. But, to speak
> > with Sir Jonathan: Test!
> >
> > The question is: does archive log mode do more than archiving logfiles
> > whenever a log switch is performed?
> >
> > Regards, Carel-Jan
> >
> > ===
> > If you think education is expensive, try ignorance. (Derek Bok)
> > ===
> >
> > > Thanks. I would not be applying archives to recover a read only
> > > database, since I would not have any. But does archive log mode add any
> > > other value to recovering a read-only db?
> > >
> > > > > > cjpengel.dbalert@(protected) 3/4/2004 8:37:45 AM > > >
> > > Hi Gene,
> > >
> > > No, I didn 't mistunderstand your question. However, apparently I
> > > didn 't
> > > make my point very clear. What I tried to point out is that, when an
> > > active R/W database can be recovered from an 'open backup ', a R/O
> > > database
> > > won 't be a problem. When no log-switches occur, archive log mode won 't
> > > add
> > > too much to your recoverability. Which archives do you want to apply to
> > > a
> > > R/O database?
> > >
> > > Regards, Carel-Jan
> > >
> > > ===
> > > If you think education is expensive, try ignorance. (Derek Bok)
> > > ===
> > >
> > >
> > > > Carel-Jan - Thanks for your email, but I think you misunderstood my
> > > > question :). I would never backup an open read write database and
> > > > assume its good (i.e. w/out altering tbs begin backup, etc.).
> > > >
> > > > My question was: I am backing up a open READ ONLY database (using
> > > alter
> > > > database open read only, not by tbs) and questioning if archive log
> > > mode
> > > > turned on could benefit me? From some responses, it seems there is
> > > no
> > > > need to have archive mode turned on for a read only database.
> > > Thanks
> > > > for Connor 's link, good stuff.
> > > > Gene
> > > >
> > > > > > > cjpengel.dbalert@(protected) 3/3/2004 4:16:49 PM > > >
> > > >
> > > > At 06:18 PM 3/3/2004, you wrote:
> > > > Gene - Perhaps someone on the list has directly tried this.
> > > > Yes, I have. It 's a war story with a happy ending. Last October I
> > > was
> > > > called in with a custome for one day of consultancy, discussing a
> > > > backup/restore strategy (I prefer to create a restore/backup
> > > strategy)
> > > > for a DWH they were going to setup for a customer of them.
> > > > So far, so good. The delivery day was somewhere at the beginning of
> > > > this year, but got postponed to Feb 1st.
> > > >
> > > > Jan 29th I received a phone call. They accidently dropped a 300
> > > million
> > > > row facttable. No worries I said, you have implemented the backup
> > > > strategy we discussed in October, haven 't you?. 'No, we haven 't, the
> > > > system isn 't production yet ' they answered sadly. The only thing we
> > > have
> > > > is a tar backup of an open database, created last Sunday. I
> > > discussed
> > > > the possibilities to do the restore, but somehow they didn 't try and
> > > > recovered otherwise.
> > > >
> > > > Wednesday Feb. 18 the phone rang: 'We were testing a database reorg
> > > and
> > > > now we 've accidently dropped a multi-multi-GIG tablespace issuing
> > > 'Drop
> > > > tablespace <TS > including contents and datafiles; ' After issuing the
> > > > command we discovered we were connected to the production schema ISO
> > > the
> > > > test schema '. No worries I said, this time you have enabled your
> > > > backup '. He responded: '............. ' (silence). 'OK, that silence
> > > > lasts to long, what do you have '. There was a backup of an open
> > > > database, created at Monday, while the database was rebuilding
> > > indexes.
> > > > There were several logswitches whilst the backup bas made. To mak
> > > things
> > > > even worse they created the problem at Tuseday and started fiddling
> > > > around with the remains of the database without first making a proper
> > > (I
> > > > would suggest physical, i.e. dd-backup). It is all on Sun Slowaris
> > > with
> > > > Mirrored DAS. They called me in, and we worked two nights on the
> > > > subject. First night was simulating the whole situation with backing
> > > up
> > > > an open index building database, do some more work, and drop the
> > > > tablespace.
> > > >
> > > > I had some phonecalls with Peter Gram and Johannes Djernaes from
> > > > Miracle. These Miracle-full guys are amazing at this.What we planned
> > > and
> > > > did was this:
> > > >
> > > > Backup everything that was left ot a separate area on disk. Free up
> > > > enough space to hold the SYSTEM,
> > > > UNDO, TOOLS and dropped tablespace.
> > > > Restore the mentioned tablespaces from the Monday tape with the open
> > > > backup. We were lucky: there was a controlfile more recent than the
> > > > datafiles of these tablespace on the tape Startup mount the database
> > > > ALTER DATABASE DATAFILE # OFFLINE for all unrestored datafiles
> > > RECOVER
> > > > DATAFILE # for all restored datafiles ALTER DATABSE OPEN. This
> > > worked,
> > > > and now this tablespace was available again. After some struggling
> > > with
> > > > constraints/indexes causing the tablespace not to be selfcontained
> > > the
> > > > tablespace was exported using
> > > the transportable tablespace
> > > feautures.
> > > >
> > > > Next steps were: Backup the transported tablespace to another disk
> > > > Restore all datafiles/controlfiles/redologfiles that were backupped
> > > > during the first step Startup this database Import the restored
> > > > tablespace At this point, theoratically one can start rebuilding
> > > > indexes/re-enabling constraints.
> > > > Just to stay on the safe side, an extra tablespace was created and
> > > all
> > > > objects in the restored tablespace were moved to this tablespace.
> > > > Transportable tablespaces come with some bugs, and we wouldn 't risk
> > > to
> > > > hit anyone of them. After moving all objects (inlcuding some LOB 's)
> > > > indexes were recreated an constraints enabled.
> > > >
> > > > Everything is fine now.
> > > >
> > > > Remark: The tablespace that was dropped wasn 't hit by any objects
> > > for
> > > > several days before the backup was made.
> > > >
> > > > This case illustratetes my opinion that, from the view of a DBA,
> > > 'EVERY
> > > > DATABASE IS A PRODUCTION DATABASE '. Excepth maybe the test-thing on
> > > your
> > > > laptop/desktop.
> > > >
> > > > The argument, that a database (or DWH in this case) hasn 't reached
> > > > production state yet is stupid. What have the consultants, setting
> > > up
> > > > the database for over three months been doing then? Is development
> > > no
> > > > production? Lack of time to implement a backup-procedure is no
> > > excuse.
> > > > Maybe it is for the DBA, but it isn 't for his manager.
> > > >
> > > > They 've learned their lesson. They called in a consultant to
> > > implement
> > > > the backup rightaway.
> > > >
> > > >
> > > > Regarding READONLY databases, please read also Connor McDonalds note
> > > > about slow readonly at www.oracledba.co.uk, look under
> > > Administration,
> > > > the note is from 14/06/2002
> > > >
> > > > Regards, Carel-Jan
> > > >
> > > > ===
> > > > If you think education is expensive, try ignorance. (Derek Bok)
> > > > ===
> > > >
> > > >
> > > >
> > > > 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@(protected)
> > > >
> > > > -- --Original Message-- --
> > > > From: oracle-l-bounce@(protected)
> > > > [mailto:oracle-l-bounce@(protected)]On
> > > > Behalf Of Gene Sais
> > > > Sent: Wednesday, March 03, 2004 10:12 AM
> > > > To: oracle-l@(protected); 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@(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
> > > > <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
> > > > <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/
> > > > <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@(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
> > > > -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
> > >
> > >
> > > -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
> > > 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
> > > -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
> > >
> >
> > -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
> > 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
> > -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
>
>-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
>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
>-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
<html >
<body >
<font size=3 >Thank you Michael. <br > <br >
Regards, Carel-Jan <br > <br >
=== <br >
If you think education is expensive, try ignorance. (Derek Bok) <br >
=== <br > <br >
At 10:41 PM 3/4/2004, you wrote: <br >
<blockquote type=cite class=cite cite >There are a few things one can NOT
do when the DB is in NOArchiveLog, for <br >
example take a tablespace offline without a checkpoint (OFFLINE
IMMEDIATE). <br >
The fake recovery trick is also dependent on Archivelog mode. <br > <br >
Again, considering that the DB is read only (and it is allowed to do the
ALTER <br >
DATABASE OPEN READ ONLY that hasnt been/seen any Standby stuff - tested
on 92, <br >
and it is in my 816 docs onwards) then you cant switch logfiles
(ORA-16000 (See ORA-16000.ora-code.com)). <br >
If I crash a DB (shutdown abort) in READ ONLY mode there is no recovery
during <br >
the next startup. That proves you can take a "cold" backup of a
READ ONLY DB <br >
without fear. <br > <br >
The long and short of it - IMHO - drop the archive log mode, drop the
backups <br >
and do one (OK, two copies if you really want to) simple cold backup
after you <br >
have loaded fresh data and are back in READ ONLY mode. <br > <br >
Still, its only my opinion - its your job/data, Gene. <br > <br >
Michael M?ller, Miracle <br > <br >
Carel-Jan Engel wrote: <br > <br >
> As far is I know and can think of, there is no added value. But, to
speak <br >
> with Sir Jonathan: Test! <br >
> <br >
> The question is: does archive log mode do more than archiving
logfiles <br >
> whenever a log switch is performed? <br >
> <br >
> Regards, Carel-Jan <br >
> <br >
> === <br >
> If you think education is expensive, try ignorance. (Derek
Bok) <br >
> === <br >
> <br >
> > Thanks. I would not be applying archives to recover a
read only <br >
> > database, since I would not have any. But does archive
log mode add any <br >
> > other value to recovering a read-only db? <br >
> > <br >
> >>>> cjpengel.dbalert@(protected) 3/4/2004 8:37:45 AM
>>> <br >
> > Hi Gene, <br >
> > <br >
> > No, I didn 't mistunderstand your question. However, apparently
I <br >
> > didn 't <br >
> > make my point very clear. What I tried to point out is that,
when an <br >
> > active R/W database can be recovered from an 'open backup ', a
R/O <br >
> > database <br >
> > won 't be a problem. When no log-switches occur, archive log
mode won 't <br >
> > add <br >
> > too much to your recoverability. Which archives do you want to
apply to <br >
> > a <br >
> > R/O database? <br >
> > <br >
> > Regards, Carel-Jan <br >
> > <br >
> > === <br >
> > If you think education is expensive, try ignorance. (Derek
Bok) <br >
> > === <br >
> > <br >
> > <br >
> >> Carel-Jan - Thanks for your email, but I think you
misunderstood my <br >
> >> question :). I would never backup an open read write
database and <br >
> >> assume its good (i.e. w/out altering tbs begin backup,
etc.). <br >
> >> <br >
> >> My question was: I am backing up a open READ ONLY database
(using <br >
> > alter <br >
> >> database open read only, not by tbs) and questioning if
archive log <br >
> > mode <br >
> >> turned on could benefit me? From some
responses, it seems there is <br >
> > no <br >
> >> need to have archive mode turned on for a read only
database. <br >
> > Thanks <br >
> >> for Connor 's link, good stuff. <br >
> >> Gene <br >
> >> <br >
> >>>>> cjpengel.dbalert@(protected) 3/3/2004 4:16:49 PM
>>> <br >
> >> <br >
> >> At 06:18 PM 3/3/2004, you wrote: <br >
> >> Gene - Perhaps someone on the list has directly tried
this. <br >
> >> Yes, I have. It 's a war story with a happy ending. Last
October I <br >
> > was <br >
> >> called in with a custome for one day of consultancy,
discussing a <br >
> >> backup/restore strategy (I prefer to create a
restore/backup <br >
> > strategy) <br >
> >> for a DWH they were going to setup for a customer of
them. <br >
> >> So far, so good. The delivery day was somewhere at the
beginning of <br >
> >> this year, but got postponed to Feb 1st. <br >
> >> <br >
> >> Jan 29th I received a phone call. They accidently dropped a
300 <br >
> > million <br >
> >> row facttable. No worries I said, you have implemented the
backup <br >
> >> strategy we discussed in October, haven 't you?. 'No, we
haven 't, the <br >
> >> system isn 't production yet ' they answered sadly. The only
thing we <br >
> > have <br >
> >> is a tar backup of an open database, created last Sunday.
I <br >
> > discussed <br >
> >> the possibilities to do the restore, but somehow they
didn 't try and <br >
> >> recovered otherwise. <br >
> >> <br >
> >> Wednesday Feb. 18 the phone rang: 'We were testing a
database reorg <br >
> > and <br >
> >> now we 've accidently dropped a multi-multi-GIG tablespace
issuing <br >
> > 'Drop <br >
> >> tablespace <TS> including contents and datafiles; '
After issuing the <br >
> >> command we discovered we were connected to the production
schema ISO <br >
> > the <br >
> >> test schema '. No worries I said, this time you have enabled
your <br >
> >> backup '. He responded: '............. ' (silence). 'OK, that
silence <br >
> >> lasts to long, what do you have '. There was a backup of an
open <br >
> >> database, created at Monday, while the database was
rebuilding <br >
> > indexes. <br >
> >> There were several logswitches whilst the backup bas made.
To mak <br >
> > things <br >
> >> even worse they created the problem at Tuseday and started
fiddling <br >
> >> around with the remains of the database without first
making a proper <br >
> > (I <br >
> >> would suggest physical, i.e. dd-backup). It is all on Sun
Slowaris <br >
> > with <br >
> >> Mirrored DAS. They called me in, and we worked two nights
on the <br >
> >> subject. First night was simulating the whole situation
with backing <br >
> > up <br >
> >> an open index building database, do some more work, and
drop the <br >
> >> tablespace. <br >
> >> <br >
> >> I had some phonecalls with Peter Gram and Johannes Djernaes
from <br >
> >> Miracle. These Miracle-full guys are amazing at this.What
we planned <br >
> > and <br >
> >> did was this: <br >
> >> <br >
> >> Backup everything that was left ot a separate area on disk.
Free up <br >
> >> enough space to hold the SYSTEM, <br >
> >> UNDO, TOOLS and dropped tablespace. <br >
> >> Restore the mentioned tablespaces from the Monday tape with
the open <br >
> >> backup. We were lucky: there was a controlfile more recent
than the <br >
> >> datafiles of these tablespace on the tape Startup mount the
database <br >
> >> ALTER DATABASE DATAFILE # OFFLINE for all unrestored
datafiles <br >
> > RECOVER <br >
> >> DATAFILE # for all restored datafiles ALTER DATABSE OPEN.
This <br >
> > worked, <br >
> >> and now this tablespace was available again. After some
struggling <br >
> > with <br >
> >> constraints/indexes causing the tablespace not to be
selfcontained <br >
> > the <br >
> >> tablespace was exported using <br >
> > the transportable tablespace <br >
> > feautures. <br >
> >> <br >
> >> Next steps were: Backup the transported tablespace to
another disk <br >
> >> Restore all datafiles/controlfiles/redologfiles that were
backupped <br >
> >> during the first step Startup this database Import the
restored <br >
> >> tablespace At this point, theoratically one can start
rebuilding <br >
> >> indexes/re-enabling constraints. <br >
> >> Just to stay on the safe side, an extra tablespace was
created and <br >
> > all <br >
> >> objects in the restored tablespace were moved to this
tablespace. <br >
> >> Transportable tablespaces come with some bugs, and we
wouldn 't risk <br >
> > to <br >
> >> hit anyone of them. After moving all objects (inlcuding
some LOB 's) <br >
> >> indexes were recreated an constraints enabled. <br >
> >> <br >
> >> Everything is fine now. <br >
> >> <br >
> >> Remark: The tablespace that was dropped wasn 't hit by any
objects <br >
> > for <br >
> >> several days before the backup was made. <br >
> >> <br >
> >> This case illustratetes my opinion that, from the view of a
DBA, <br >
> > 'EVERY <br >
> >> DATABASE IS A PRODUCTION DATABASE '. Excepth maybe the
test-thing on <br >
> > your <br >
> >> laptop/desktop. <br >
> >> <br >
> >> The argument, that a database (or DWH in this case) hasn 't
reached <br >
> >> production state yet is stupid. What have the consultants,
setting <br >
> > up <br >
> >> the database for over three months been doing then? Is
development <br >
> > no <br >
> >> production? Lack of time to implement a backup-procedure is
no <br >
> > excuse. <br >
> >> Maybe it is for the DBA, but it isn 't for his
manager. <br >
> >> <br >
> >> They 've learned their lesson. They called in a consultant
to <br >
> > implement <br >
> >> the backup rightaway. <br >
> >> <br >
> >> <br >
> >> Regarding READONLY databases, please read also Connor
McDonalds note <br >
> >> about slow readonly at
<a href= "http://www.oracledba.co.uk/ " eudora= "autourl " >www.oracledba.co.uk </a >,
look under <br >
> > Administration, <br >
> >> the note is from 14/06/2002 <br >
> >> <br >
> >> Regards, Carel-Jan <br >
> >> <br >
> >> === <br >
> >> If you think education is expensive, try ignorance. (Derek
Bok) <br >
> >> === <br >
> >> <br >
> >> <br >
> >> <br >
> >> It is <br >
> >> theoretically possible to get a good backup on a quiet but
open <br >
> >> database <br >
> >> with just a cold backup, but not the sort of thing you want
to bet <br >
> > your <br >
> >> job <br >
> >> on. One idea would be for you to take your backup and
restore it on <br >
> > a <br >
> >> test <br >
> >> system. It is always a good practice to test your database
restore <br >
> >> anyway. <br >
> >> Then you would be assured throughout the year that you do
indeed <br >
> > have <br >
> >> a <br >
> >> valid backup. But I would do it each year since there might
be some <br >
> >> condition that would make the backup succeed 50% of the
time, you <br >
> > would <br >
> >> be <br >
> >> covered all the time. <br >
> >> <br >
> >> <br >
> >> <br >
> >> Dennis Williams <br >
> >> DBA <br >
> >> Lifetouch, Inc. <br >
> >> dwilliams@(protected) <br >
> >> <br >
> >> -- --Original Message-- -- <br >
> >> From: oracle-l-bounce@(protected) <br >
> >>
[ <a href= "mailto:oracle-l-bounce@(protected) " eudora= "autourl " >mailto:oracle-l-bounce@(protected) </a >]On <br >
> >> Behalf Of Gene Sais <br >
> >> Sent: Wednesday, March 03, 2004 10:12 AM <br >
> >> To: oracle-l@(protected); DENNIS WILLIAMS <br >
> >> Subject: RE: Archive Mode On for Read Only DB <br >
> >> <br >
> >> <br >
> >> Dennis - The database is opened in read only mode.
The database <br >
> >> changes <br >
> >> once a yr to be updated w/ new images. At that time,
I put the db <br >
> > in <br >
> >> read <br >
> >> write mode, add the images, then open db in read only and
back it up <br >
> >> while <br >
> >> db is open. It is a web query db that I would like to
minimize down <br >
> >> time. <br >
> >> Is there any benefit to putting this db in archive log
mode? I <br >
> > don 't <br >
> >> see <br >
> >> any, but I may be missing something :). <br >
> >> <br >
> >> Thanks for your help, <br >
> >> Gene <br >
> >> <br >
> >>>>> DWILLIAMS@(protected) 3/3/2004 10:47:26 AM
>>> <br >
> >> <br >
> >> Gene - By read only, do you mean the contents of the
database are <br >
> >> 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 <br >
> > and <br >
> >> 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) [ <br >
> >>
<a href= "mailto:oracle-l-bounce@(protected)%5DOn " eudora= "autourl " >mailto:oracle-l-bounce@(protected)]On </a > <br >
> >>
< <a href= "mailto:oracle-l-bounce@(protected)%5DOn " eudora= "autourl " >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) <br >
> >> while the <br >
> >> db is open. <br >
> >> <br >
> >> Question: Is there any benefit to having this db in archive
log <br >
> > mode? <br >
> >> 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/ " eudora= "autourl " >http://www.orafaq.com </a > <br >
> >>
< <a href= "http://www.orafaq.com/ " eudora= "autourl " >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/ " eudora= "autourl " >http://www.freelists.org/archives/oracle-l/ </a > <br >
> >>
< <a href= "http://www.freelists.org/archives/oracle-l/ " eudora= "autourl " >http://www.freelists.org/archives/oracle-l/ </a >> <br >
> >> FAQ is at
<a href= "http://www.freelists.org/help/fom-serve/cache/1.html " eudora= "autourl " >http://www.freelists.org/help/fom-serve/cache/1.html </a > <br >
> >>
< <a href= "http://www.freelists.org/help/fom-serve/cache/1.html " eudora= "autourl " >http://www.freelists.org/help/fom-serve/cache/1.html </a >> <br >
> >>
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- -- <br >
> >> <br >
> >> <br >
> >>
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------ <br >
> >> Please see the official ORACLE-L FAQ:
<a href= "http://www.orafaq.com/ " eudora= "autourl " >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/ " eudora= "autourl " >http://www.freelists.org/archives/oracle-l/ </a > <br >
> >> FAQ is at
<a href= "http://www.freelists.org/help/fom-serve/cache/1.html " eudora= "autourl " >http://www.freelists.org/help/fom-serve/cache/1.html </a > <br >
> >>
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- -- <br >
> > <br >
> > <br >
> >
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------ <br >
> > Please see the official ORACLE-L FAQ:
<a href= "http://www.orafaq.com/ " eudora= "autourl " >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/ " eudora= "autourl " >http://www.freelists.org/archives/oracle-l/ </a > <br >
> > FAQ is at
<a href= "http://www.freelists.org/help/fom-serve/cache/1.html " eudora= "autourl " >http://www.freelists.org/help/fom-serve/cache/1.html </a > <br >
> >
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- -- <br >
> > <br >
> <br >
>
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------ <br >
> Please see the official ORACLE-L FAQ:
<a href= "http://www.orafaq.com/ " eudora= "autourl " >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/ " eudora= "autourl " >http://www.freelists.org/archives/oracle-l/ </a > <br >
> FAQ is at
<a href= "http://www.freelists.org/help/fom-serve/cache/1.html " eudora= "autourl " >http://www.freelists.org/help/fom-serve/cache/1.html </a > <br >
>
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- -- <br > <br >
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------ <br >
Please see the official ORACLE-L FAQ:
<a href= "http://www.orafaq.com/ " eudora= "autourl " >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/ " eudora= "autourl " >http://www.freelists.org/archives/oracle-l/ </a > <br >
FAQ is at
<a href= "http://www.freelists.org/help/fom-serve/cache/1.html " eudora= "autourl " >http://www.freelists.org/help/fom-serve/cache/1.html </a > <br >
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- -- </font > </blockquote > </body >
</html >
