Home » Server Options » Streams & AQ » EM showing creation of same Archivelog twice (Oracle 10g 10.2.0.3.0 on linux 64 bit)
EM showing creation of same Archivelog twice [message #349220] Fri, 19 September 2008 06:26 Go to next message
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
Senior Member
Hi,
I am working on Oracle 10g 10.2.0.3.0 on linux 64 bit, since i started stream replication, sometimes Oracle creates archive log of same sequence number and name twice at different time (difference in seconds), physical archive log has only one file. What can be the reason, is it due to log miner.

Is it harmful?

Report message to a moderator

Re: EM showing creation of same Archivelog twice [message #349286 is a reply to message #349220] Fri, 19 September 2008 12:09 Go to previous messageGo to next message
varunvir
Messages: 389
Registered: November 2007
Senior Member
Creation of archivelogs by oracle never deped upon replication.Generally It depends upon you backup policies.Streaming just use the archivelogs to for log mining.
Regards,
Varun Punj,

Report message to a moderator

Re: EM showing creation of same Archivelog twice [message #349548 is a reply to message #349286] Mon, 22 September 2008 03:19 Go to previous message
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
Senior Member
What can be the reason of showing creation of archive log of same sequence number and name twice in Enterprise manager and it is happening sometimes.

Report message to a moderator

Previous Topic: Stopping failed DBMS_STREAMS_ADM.MAINTAIN_SCHEMAS
Next Topic: Queue message not moving from Head To tail [Oracle Queues]
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jan 29 18:24:21 CST 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.