RE: Archive Mode On for Read Only DB
- From: "Guang Mei" <gmei@xxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 3 Mar 2004 11:40:42 -0500
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of dba1 mcc
Sent: Wednesday, March 03, 2004 11:33 AM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxx 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@xxxxxxxxxxxxx
>
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On
> Behalf Of Gene Sais
> Sent: Wednesday, March 03, 2004 9:04 AM
> To: oracle-l@xxxxxxxxxxxxx
> 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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at
> //www.freelists.org/archives/oracle-l/
> FAQ is at
> //www.freelists.org/help/fom-serve/cache/1.html
>
-----------------------------------------------------------------
>
>
__________________________________
Do you Yahoo!?
Yahoo! Search - Find what youre 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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
