Re: Switch database to READ ONLY mode

"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.
>

The short answer is yes, you will need to shut it down. The longer answer is: the *reason* why you have to shut it down is that there is no ' startup read only' command. That means the command is issued from the mount state, and if you are already open, there is no way to get the thing to go backwards into the mount state.

Hence, it's a shutdown, followed by a startup mount, followed by an alter database open read only.

And yes, the only way I've found ever to return it to fully read-write is to bounce the entire thing.

Regards
HJR
> Thanks a lot for any advices.
>
> Scott
Received on Sun Sep 16 2001 - 22:11:48 CDT