RE: archive log question

RE: archive log question

 

  

Sorry, a little correction in my previous message. Please read ARC1 in the begining of message as ARC0 to see the sense in my message.

Gurmohan
www.onlymath.com - The place to learn and teach math.




-----Original Message-----
From: Shergill Gurmohan
[mailto:oracledba-ezmlmshield-x30645837.[Email address protected]
Sent: Friday, October 28, 2005 3:02 PM
To: LazyDBA Discussion
Subject: RE: archive log question


Read it like this. Archive process ARC1 attempted to archive log6 and failed. ARC0 leaves this and move on to archive another log.
ARC1, another archive process picked up the log6 and succeeded in archiving it because the hinderance which had stopped ARC0 from archiving was cleared by then.

I am sure you must have more than 1 archive process or slaves in your system as is indicated by ARC0 and ARC1.

Gurmohan
www.onlymath.com - The place to learn and teach math.





-----Original Message-----
From: Dustin Hayden
[mailto:oracledba-ezmlmshield-x58337135.[Email address protected]
Sent: Friday, October 28, 2005 2:49 PM
To: LazyDBA Discussion
Subject: archive log question


Why does it appear by my archive log process are trying to backup the same
log?

ARC1 says unable to archive log6

And ARC0 completed log six.



Why are both threads trying to archive the same log?









ARC1: Completed archiving log 4 thread 1 sequence 2157

ARC1: Evaluating archive log 6 thread 1 sequence 2158

ARC1: Unable to archive log 6 thread 1 sequence 2158



ARC1: Evaluating archive log 6 thread 1 sequence 2158

ARC1: Unable to archive log 6 thread 1 sequence 2158



Fri Oct 28 00:45:56 2005 archived by another process

ARC0: Completed archiving log 6 thread 1 sequence 2158



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page