Re: Switch database to READ ONLY mode

hehe - the justice departements in belgium are also still running on 7.2.3 - however, they're thinking
about consolidating and using 9i RAC.
BTW Sybrand, there's still room at our offices in the Netherlands ;-)

Cheers,
Koert

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:tqcb195kuatf2f_at_news.demon.nl...
>
> "Howard J. Rogers" <howardjr_at_www.com> wrote in message
> news:3ba569bc$1_at_news.iprimus.com.au...
> >
> > "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
> > news:tqa353jfm0ukf1_at_news.demon.nl...
> > >
> > > "Scott" <scott_tiger75_at_hotmail.com> wrote in message
> > > news:53ad92d4.0109161137.4fdf8e3_at_posting.google.com...
> > > > Greetings to all DBAs,
> > > >
> > > > I need to replace an Oracle 8.1.6 production server (server A) with
> > > > another one (server B).
> > > >
> > > > Here's what I plan to do to achieve it :
> > > > 1- switch server A database to READ ONLY mode to prevent any
writing.
> > > > 2- perform a full export of server A database
> > > > 3- import the dump file into server B database
> > > > 4- check server B is working fine and prepare it to replace server A
> > > > 5- shutdown server A database and disconnect the machine
> > > > 6- connect server B
> > > >
> > > > Do i need to shutdown the server A database to re-open it in READ
ONLY
> > > > mode with "ALTER DATABASE OPEN READ ONLY" ? Same question if I would
> > > > like to switch my database to READ WRITE.
> > > >
> > > > Thanks a lot for any advices.
> > > >
> > > > Scott
> > >
> > > There is no such thing as read only mode, or you must want to switch
all
> > > individual tablespaces to read only.
> >
> > Come on Sybrand! This particular feature has been around since 8i was
> first
> > released, and was one of its exciting new features. Of course you can
> open
> > a database read only. How do you think the Standby can be used as a
> > reporting database if you couldn't?
> >
> > > There is however, a restricted session mode during which only users
with
> > the
> > > dba role can connect. Assuming not everyone has the dba role, I would
> set
> > > the the database in restricted session mode.
> > > Alter system enable_restricted_session = true
> > >
> > > will accomplish this.
> > >
> >
> > Just to re-iterate: read only is unrestricted, but no DML. Restricted
> > session is 'only restricted session privlege owners need apply', but
once
> > they're on, they can do everything they're used to being able to do.
Two
> > very different scenarios.
> >
> > Sybrand: are you having an Oracle 7 day or something??!
> >
> > Regards
> > HJR
> >
> >
> >
> >
> > > Hth,
> > >
> > > Sybrand Bakker, Senior Oracle DBA
> > >
> > >
> > >
> >
> >
>
> Complaints to my employer, a Dutch consultancy firm, who still force me to
> work with desupported crap for more than 80 percent of my hours. How I
will
> ever get to use 9i is a mystery for me.
> Many Dutch firms refuse to upgrade. Our DoD is still on 7.3.2 (or was it
> 7.2.3) and they refuse to upgrade. Of course these databases are supported
> by Oracle Netherlands.
> I can't help it, I still haven't used 8i for a period longer than a few
> weeks.
> I have Personal Oracle 8i at home, but for obvious reasons I need to
reserve
> spare time for other things.
>
> Can you give me any good convincing reasons, which will force my firm to
> drop support for Oracle 7?
>
> Regards,
>
> Sybrand Bakker, Senior Oracle DBA
>
>
>
>
Received on Wed Sep 19 2001 - 13:43:24 CDT