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: Oracle standby strange behavior

RE: Oracle standby strange behavior

From: Yuval Arnon <Yuval.Arnon_at_wwfent.com>
Date: Wed, 30 Jan 2002 11:56:26 -0800
Message-ID: <F001.00401051.20020130115252@fatcity.com>

<SPAN
class=134404819-30012002>Vadim,
Thanks
for the input but I already made sure all arc files have been transferred and applied and that an 'alter system switch logfile' was executed prior to that.
<SPAN
class=134404819-30012002> 
<SPAN
class=134404819-30012002>Yuval.

  <FONT face=Tahoma
  size=2>-----Original Message-----From: Vadim Gorbounov   [mailto:vgorbounov_at_simplyengineering.com]Sent: Wednesday, January   30, 2002 2:26 PMTo: Multiple recipients of list   ORACLE-LSubject: RE: Oracle standby strange   behavior
  Hi, Yuval<SPAN
  class=409482219-30012002>.
  Did you make sure, you've got
  latest data transferred and applied?
  I bet, these two tables have
  largest OBJECT_ID in the original DB.
 

  Before you activate standby,
  do

  1. On production
      SQL> alter system
    switch logfile;
     
  2. Transfer all archived logs to standby and make sure they are applied.
     
    Hopefully, no more problem.
     
    Vadim
     

    <FONT face=Tahoma
    size=2>-----Original Message-----From: Yuval Arnon     [mailto:Yuval.Arnon_at_wwfent.com]Sent: Wednesday, January 30, 2002     1:41 PMTo: Multiple recipients of list     ORACLE-LSubject: Oracle standby strange     behavior
    Hi, I ran into a strange behavior of     a standby database. On the primary db I have an     application schema and a query schema. All tables     from the appl schema have public synonyms and a grant select to     public. User query is created with connect and     resource roles. Once I switch over to the standby db     , and put it in read only mode, and then connect to the query user, I can     not perform a select against 2 of the 35 tables. I get object OBJECT_NAME     does not exist.
    I can connect to the system user on the standby database and     I have no problem selecting from all the tables.     Any idea what am I missing??
    Yuval.
    -----Original Message----- From:
    Orr, Steve [<A
    href="mailto:sorr_at_rightnow.com">mailto:sorr_at_rightnow.com]     Sent: Wednesday, January 30, 2002 12:35 PM <FONT     size=2>To: Multiple recipients of list ORACLE-L <FONT     size=2>Subject: RE: Performance Tuning     Rachel IS kind but her words are also true and I think this     was her main focus in this case.  ;-)     

    My Alomari book was for v7 and was good but is now dated...     Is it up to date for 8i/9i?
    -----Original Message----- Sent:
    Wednesday, January 30, 2002 10:11 AM To: Multiple     recipients of list ORACLE-L
    Rachel, Thank you so much for you
    kind words and the very interesting comparison.. <FONT     size=2>:) - Kirti
    -----Original Message----- Sent:
    Wednesday, January 30, 2002 9:50 AM To: Multiple     recipients of list ORACLE-L
    I would perhaps suggest Oracle Performance Tuning 101     instead of Rich's book (if you had to make a     choice).
    the 101 book conforms most closely to Oracle's current     thinking on performance tuning

Received on Wed Jan 30 2002 - 13:56:26 CST

Original text of this message

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