Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: standby physical couldnot query v$database

Re: standby physical couldnot query v$database

From: Ujang Jaenudin <ujang.jaenudin_at_gmail.com>
Date: Mon, 30 Apr 2007 14:47:50 +0700
Message-ID: <3edcb66e0704300047ga6572fchd24641f556926b73@mail.gmail.com>


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-l
Received on Mon Apr 30 2007 - 02:47:50 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US