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@xxxxxxxxxxxx> 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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] En
nombre de Ujang Jaenudin
Enviado el: lunes, 30 de abril de 2007 8:35
Para: oracle-l@xxxxxxxxxxxxx
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

Other related posts: