This discussion is archived
2 Replies Latest reply: Mar 25, 2013 11:55 AM by 999040 RSS

Which instance in DG network shipped the log?

999040 Newbie
Currently Being Moderated
Hi,

I am wondering if there is a Oracle view that can tell me what is the source instance that has shipped a given archive log

Details:

I have primary PR and four physical standby databases PS1, PS2, PS3 and PS4. There is no RAC involved. They are all configured and working fine. They are all configured to receive logs from PR or each other. In the event there is a network issue between PR and PS4, PS4 can still receive its logs from PS1 or PS2 or PS3.

My question is, on PS4 for a given log how to tell where the log has been shipped from? I am looking for a Oracle view. I create an SR but no help (the usual look-here look-there cryptic response).

By the way, I looked at v$archived_log where there is DEST_ID but I don't think it is the right answer...

I truly appreciate your help in this regard. I am running 11g. (actaully 11.1.0.7)

Thanks

Edited by: 996037 on Mar 25, 2013 10:20 AM
  • 1. Re: Which instance in DG network shipped the log?
    mseberg Guru
    Currently Being Moderated
    Withdrawn. Your system does not compare to anything I have to test on. I should have skipped your question.

    Would still look at this :

    http://www.oracle-ckpt.com/?s=transport&op.x=0&op.y=0

    You might be able to do something with V$ARCHIVE_DEST_STATUS.

    Sorry about my first bad answer.

    Best Regards

    mseberg

    Edited by: mseberg on Mar 25, 2013 2:18 PM

    Edited by: mseberg on Mar 25, 2013 2:46 PM
  • 2. Re: Which instance in DG network shipped the log?
    999040 Newbie
    Currently Being Moderated
    Mseberg,

    Can you tell me what you mean by "Otherwise the NAME relates to DEST_ID ( Run from source of Archive )" ?

    I ran the select in my stand by database where I wanted to see where the logs are coming from (SELECT NAME AS STANDBY, SEQUENCE#, APPLIED, COMPLETION_TIME FROM V$ARCHIVED_LOG WHERE DEST_ID = 2 AND NEXT_TIME > SYSDATE -1 ORDER BY SEQUENCE#;)

    The NAME in the the output is fully qualified name of the archive log on the standby database. It has no indication anywhere in the name that it is coming from primary database or another standby. The source of archive is not in the NAME at all no matter whether it is coming from primary or another standby.

    Example output:

    /u99/arch/macpsb02/macprd02_1_20350_786340900.dbf
    20350 NO 25-MAR-13

    /u99/arch/macpsb02/macprd02_1_20351_786340900.dbf
    20351 NO 25-MAR-13

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points