Re: standby physical couldnot query v$database

this is 9.2.0.6 on solaris 64bit

i found in alert log, that when back to apply MRP, the archivelog is applied normally.
but the problem is I could not query v$database.

regards
ujang

On 4/30/07, Juan Miranda <j.miranda_at_sermatica.es> wrote:
>
> HI
>
> In 10g we meet a bug that force us to shutdown and restart after we put db
> in read-only mode.
> Do you look at alert.log ?
>
>
>
>
> -----Mensaje original-----
> De: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] En
> nombre de Ujang Jaenudin
> Enviado el: lunes, 30 de abril de 2007 8:35
> Para: oracle-l_at_freelists.org
> Asunto: standby physical couldnot query v$database
>
> all,
>
> I have a physical standby database, but a little error comes when open read
> only and again MRP apply.
>
> startup nomount;
> alter database mount standby database;
> alter database managed standby database disconnect from session; select
> open_mode from v$database;
> -- yield mount
>
> alter database managed standby database cancel; alter database open read
> only; select open_mode from v$database;
> -- yield read only
>
> -- back activate MRP
> alter database managed standby database disconnect from session; select
> open_mode from v$database;
> -- yield error, that v$database could not query
> -- but i can still query other v$ views, such as v$instance, v$datafile ,
> etc

--
http://www.freelists.org/webpage/oracle-l