Oracle 9i activating read only standby database
Oracle version -- Oracle 9i Below are the steps to open a read-only standby BCV database as a production ready (read-write) in oracle 9i. SQL> alter database mount standby database; Database altered. SQL> alter database open read only; Database altered. SQL> SQL> ALTER DATABASE ACTIVATE STANDBY DATABASE; Database altered. SQL> SQL> alter database mount; Database altered. SQL> alter database open; Database altered. SQL> select name, open_mode, log_mode from v$database; NAME OPEN_MODE LOG_MODE --------- ---------- ------------ FXBPADM READ WRITE ARCHIVELOG SQL>