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

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

standby physical couldnot query v$database

From: Ujang Jaenudin <ujang.jaenudin_at_gmail.com>
Date: Mon, 30 Apr 2007 13:34:43 +0700
Message-ID: <3edcb66e0704292334x51e83363o8d6921ca6cd6d96e@mail.gmail.com>


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

--

regards
ujang

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Apr 30 2007 - 01:34:43 CDT

Original text of this message

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