Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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_at_corp.untd.com> 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-lReceived on Mon Apr 30 2007 - 02:47:50 CDT
![]() |
![]() |