This content has been marked as final. Show 2 replies
Withdrawn. Your system does not compare to anything I have to test on. I should have skipped your question.
Would still look at this :
You might be able to do something with V$ARCHIVE_DEST_STATUS.
Sorry about my first bad answer.
Edited by: mseberg on Mar 25, 2013 2:18 PM
Edited by: mseberg on Mar 25, 2013 2:46 PM
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.
20350 NO 25-MAR-13
20351 NO 25-MAR-13