Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Switch database to READ ONLY mode
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
![]() |
![]() |