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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).