Re: standby physical couldnot query v$database

that is OK,

but , according to docs, we can directly apply MRP from read only mode.
so, if it is bug, which bug is it?

regards
ujang

On 4/30/07, Padda, Ashok Kumar <ashokp@xxxxxxxxxxxxx> wrote:

Hi Ujang,

After you open the standby in read only mode -> can you try shutdown the
db -> re-mount the db in standby mode and -> turn recovery on?

Something like this for step 2 and 3
-------------------------x-------------------------
alter database managed standby database cancel;
alter database open read only;
select open_mode from v$database;
shutdown immediate;
startup nomount;
alter database managed standby database disconnect from session;
select open_mode from v$database;
-------------------------x-------------------------


+Ashok

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

Other related posts: