Keeping 9i Oracle Database in Sync mode

SQL>
SQL> shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
SQL> startup mount force
ORACLE instance started.
Total System Global Area 6347169792 bytes
Fixed Size                  2240016 bytes
Variable Size            2550137328 bytes
Database Buffers         3758096384 bytes
Redo Buffers               36696064 bytes
Database mounted.
SQL>
SQL> flashback database to restore point before_open_standby;
Flashback complete.
SQL>
SQL> alter database convert to physical standby;
Database altered.
SQL>
SQL> shut immediate
ORA-01507: database not mounted

ORACLE instance shut down.
SQL>
SQL> startup mount force
ORACLE instance started.
Total System Global Area 6347169792 bytes
Fixed Size                  2240016 bytes
Variable Size            2550137328 bytes
Database Buffers         3758096384 bytes
Redo Buffers               36696064 bytes
Database mounted.
SQL>
SQL> drop restore point before_open_standby;
Restore point dropped.
SQL>
SQL> shut immediate
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.
SQL>
SQL> startup nomount
ORACLE instance started.
Total System Global Area 6347169792 bytes
Fixed Size                  2240016 bytes
Variable Size            2550137328 bytes
Database Buffers         3758096384 bytes
Redo Buffers               36696064 bytes
SQL>
SQL> alter database mount standby database;
Database altered.
SQL>
SQL> alter database recover managed standby database disconnect from
SQL> session;
Database altered.
SQL>
SQL> select name,open_mode from v$database;
NAME      OPEN_MODE
--------- --------------------
TEST      MOUNTED
SQL>
SQL> @enable_test.sql
Error accessing PRODUCT_USER_PROFILE
Warning:  Product user profile information not loaded!
You may need to run PUPBLD.SQL as SYSTEM Connected.
System altered.

System altered.

System altered.

System altered.

System altered.

System altered.
SQL>
SQL> exit