Re: Switch database to READ ONLY mode

On 16 Sep 2001 12:37:03 -0700, scott_tiger75_at_hotmail.com (Scott) wrote:

>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

You could create a standby database on B and put it in recovery mode. Then shutdown A and start it in restricted mode to switch logfiles, trafer them to B and complete the recovery. After that you just have to open B for normal use.

Yours Hans Erik Busk
tbf_at_cn.stam.dk Received on Mon Sep 17 2001 - 07:16:33 CDT