Standby database restarts as READ ONLY

[Arjen Visser]

Question
Our oracle server is scheduled to reboot every weekend and after the reboot the database changes to read only mode so the updates don't get applied.

Is there a reason the database changes to read only mode after the server reboot ? Any setting needs to be done to avoid this ?

Answer
The answer is because the normal Oracle supplied startup procedures do not account for starting up a standby database and startup the standby database as a normal database. Starting a standby database as a normal database results in the standby database being opened in READ ONLY.
Use the Dbvisit supplied tools to start the database as boot time. The command is:
dbv_oraStartStop start DDC

Where DDC is your database name.