Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Switch database to READ ONLY mode

Switch database to READ ONLY mode

From: Scott <scott_tiger75_at_hotmail.com>
Date: 16 Sep 2001 12:37:03 -0700
Message-ID: <53ad92d4.0109161137.4fdf8e3@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 Received on Sun Sep 16 2001 - 14:37:03 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US