Re: Standby db Real Time Apply (10gR2)



Hi,

Have you actually created the standby logs with the same size as the
primary's online redo logs? Oracle won't return an error if you
haven't, but it will silently throw the exception you noted.

If you have created them, I would make sure the standby is actually
caught up. One view (among others like v$dataguard_stats) you can use
is v$standby_apply_snapshot. Assuming you are using maximum
performance mode on the primary, then if that view is not yet
populated (or the time is not relatively current, less than a minute
behind or so), you may not yet have the transaction on the standby.
Wait until you see it "caught up" and you should see the transaction.

HTH,

Steve
.



Relevant Pages

  • Re: Put Oracle 8i standby in managed recovery
    ... And for NET8 how to manage network or standby failures in the time. ... I'm afraid of the stop of the production database if Oracle can not archive ... Do a manual recover per day is so terrible or impossible? ...
    (comp.databases.oracle.server)
  • Re: Standby 8i and Message ORA-279
    ... I transfer the archived redo from the production to the standby by script.. ... Everytime Oracle execute my script and apply the redo, ...
    (comp.databases.oracle.server)
  • Re: Archive log transport after Physical Standby bounce
    ... Oracle 10.2.0.3, AIX 5.3 TL05. ... Example of the standby bounce: ... alter database recover managed standby database disconnect; ... processes to send the missing archive logs and resync, ...
    (comp.databases.oracle.server)
  • Dataguard recovery - corrupted log files
    ... We have a case open with Oracle ... Oracle 9.2.0.7 Primary and Standby in Maximum performance mode ... The last archive log did not ... Is zero data loss unrealistic with the distance we are transferring? ...
    (comp.databases.oracle.server)
  • Re: Oracle 10g, standby creation
    ... I would like to create a physical standby with Oracle 10g. ... Do I need to copy the backup of the production online redologs to my ... Oracle recommends you add standby redo log ...
    (comp.databases.oracle.server)