Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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
--
regards
ujang
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Apr 30 2007 - 01:34:43 CDT
![]() |
![]() |