Re: dataguard connection question

I did, the error is the value is not sync with spfile and the broker. I don't know how to fix it. and I am not sure where is the LogXptMode (ARCH SYNC AFFIRM) came from. 

Joan

QL> select * from v$logfile;

    GROUP# STATUS                TYPE
---------- --------------------- ---------------------
MEMBER
--------------------------------------------------------------------------------
IS_RECOVE
---------
         3                       ONLINE
/opt/XYTHT/redo1/XYTHT1/redo03.log
NO

         3                       ONLINE
/opt/XYTHT/redo2/XYTHT1/redo03.log
NO

         2                       ONLINE
/opt/XYTHT/redo1/XYTHT1/redo02.log
NO

         2                       ONLINE
/opt/XYTHT/redo2/XYTHT1/redo02.log
NO

         1                       ONLINE
/opt/XYTHT/redo1/XYTHT1/redo01.log
NO

         1                       ONLINE
/opt/XYTHT/redo2/XYTHT1/redo01.log
NO

         4                       STANDBY
/opt/XYTHT/redo1/XYTHT1/stby_redo4.log
NO

         5                       STANDBY
/opt/XYTHT/redo2/XYTHT1/stby_redo4.log
NO

         6                       STANDBY
/opt/XYTHT/redo1/XYTHT1/stby_redo5.log
NO

         7                       STANDBY
/opt/XYTHT/redo2/XYTHT1/stby_redo5.log
NO

         8                       STANDBY
/opt/XYTHT/redo1/XYTHT1/stby_redo6.log
NO

         9                       STANDBY
/opt/XYTHT/redo2/XYTHT1/stby_redo6.log
NO

        10                       STANDBY
/opt/XYTHT/redo1/XYTHT1/stby_redo7.log
NO

        11                       STANDBY
/opt/XYTHT/redo2/XYTHT1/stby_redo7.log
NO


14 rows selected.


Mathias Zarick wrote:


Hi Joan,
i guess you forgot to create standby redo logs on XYTHT1 ? 
They are needed when you switch to XYTHT2 to get properly running.
A proper configuration is prerequisite for next switchover / switchback.
HTH Mathias ________________________________ 

Von: Joan Hsieh [mailto:joan.hsieh@xxxxxxxxx]
Gesendet: Mi 6/10/2009 20:57
An: Mathias Zarick
Cc: oracle_l
Betreff: [SPAM] Re: dataguard connection question



Thank you Mathias,

Looks like I got it fixed. Our client can connect to the new service.

However, I got a new problem. I tried to switchover again in order to
test it. Swichover failed with ora-16725, 16809, 16629 errors ,

I checked the log and did the following command in broker. I got the
following results. I also did create pfile from spfile in order to check
the value; I am not sure why the memory value show it is ARCH SYNC. It
really puzzled me. The xytht1 (standby) the log_archive_dest_2 is null.

please see the following value;

*.log_archive_dest_2='service="XYTHT1"',' LGWR SYNC AFFIRM delay=0
OPTIONAL compression=DISABLE max_failure=0 max_connec
tions=1 reopen=300 db_unique_name="XYTHT1" net_timeout=30
valid_for=(online_logfile,primary_role)'
*.log_archive_dest_state_1='ENABLE'


DGMGRL> show database 'XYTHT2' InconsistentLogXptProps
INCONSISTENT LOG TRANSPORT PROPERTIES
INSTANCE_NAME STANDBY_NAME PROPERTY_NAME MEMORY_VALUE BROKER_VALUE
XYTHT2 XYTHT1 LogXptMode (ARCH SYNC AFFIRM) SYNC (= LGWR SYNC AFFIRM)



Thanks,

Joan





My Oracle Support (the new MetaLink)   Bookmarks   Admin   Profile
Feedback   Sign Out   Help

Copyright © 2005, Oracle. All rights reserved.  Legal Notices  and Terms
of Use | Privacy Statement




Thanks,

Joan








--
http://www.freelists.org/webpage/oracle-l

Other related posts: