standby questions

From: Joan Hsieh <joan.hsieh_at_tufts.edu>
Date: Fri, 26 Sep 2003 13:54:41 -0800
Message-ID: <F001.005D1362.20030926135441@fatcity.com>

Hi Listers,

I have few question regarding standby database. standby database created without any problem and it applied the archive logs. Question 1: I created a test table on target db. insert couple rows. switch the log. On standby db, I checked v$archived_log, the log applied and sequence # is correct. I'd like to see if the test table was created in the standby db. So I issue the alter databaser open read only; However, I can query all_tables, there is test table jj. But when I query dba_tables and select * from jj, it gave me ora-00942: table or view does not exist error.

Questin 2: I changed back from read only to recover managed mode, So I issued "alter database recover managed standby database disconnect from session"; I switched logfile on primary db, this time standby didn't receive any log anymore. Is this normal? How can I resyn the sequence again? From primary db, no rows returned from "select message from v$dataguard_status"

Thanks in advance!

Joan
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Joan Hsieh
  INET: joan.hsieh_at_tufts.edu

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Sep 26 2003 - 16:54:41 CDT