| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Archive Mode On for Read Only DB
For 8i at least,
SHUTDOWN IMMEDIATE;
Startup mount
ALTER DATABASE OPEN READ ONLY;
For old version, I think you need to put each tablespace (execpt system) in
read only mode.
Guang
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of dba1 mcc
Sent: Wednesday, March 03, 2004 11:33 AM
To: oracle-l_at_freelists.org
Subject: RE: Archive Mode On for Read Only DB
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_at_co.palm-beach.fl.us> 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_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
> 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/ 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:44:03 CST
 |
 |