Can you tell me how to turn on database "read only "?
Based on what I know, ONLY standby database can turn
on as "read only " database.
Thanks.
--- Gene Sais <Gsais@(protected) > wrote:
> 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
>
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
>
>
__ ____ ____ ____ ____ ____ ______
Do you Yahoo!?
Yahoo! Search - Find what you�re looking for faster
http://search.yahoo.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
