open read only standby database

hello,

i have a problem when a switch from a recover standby to open read only.

if i made :

SQL> conn sys/syspass as sysdba
--> OK

SQL> startup nomount
pfile='D:\standby\product\admin\orcl\pfile\init.ora'
--> OK

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT;
--> OK

SQL> alter database recover managed standby database cancel;
--> OK

SQL> alter database open read only;
--> OK

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT;
--> OK

SQL> alter database recover managed standby database cancel;
--> OK

SQL> alter database open read only;
--> ORA-01092: ORACLE instance terminated. Disconnection forced

Why the 2nd time it fails ??? Received on Mon May 30 2005 - 09:50:09 CDT