-
Archive process
Hi
I have aproduction database version 8.1.7.4, when i start the database it is started with 1 archive process. From alert log, it start 2nd and 3rd archive process ie
ARC0: Completed archiving log# 3 seq# 67397
ARC0: STARTING ARCH PROCESSES
ARC1 started with pid=125
ARC1: Archival started
Tue Sep 2 12:00:24 2003
when it ARC1 starts to archive log say #67399
ARCO also attempts to start but fails, so on with say 3rd process. Finally ARC1 is completed.
My question is , is this normal behaviour.? Do these extra process started 2, 3 etc shut down itself, which i think is NOT, they are shut down only when database is shut down.
ARC1: Beginning to archive log# 4 seq# 67399
Tue Sep 2 12:00:35 2003
Thread 1 advanced to log sequence 67401
Current log# 2 seq# 67401 mem# 0: /u04/oradata/ntw/redo02.log
Tue Sep 2 12:00:39 2003
ARC0: Completed archiving log# 1 seq# 67398
ARC0: STARTING ARCH PROCESSES
ARC2 started with pid=126
Tue Sep 2 12:00:39 2003
ARC2: Archival started
Tue Sep 2 12:00:39 2003
ARC0: STARTING ARCH PROCESSES COMPLETE
Tue Sep 2 12:00:39 2003
ARC0: Beginning to archive log# 4 seq# 67399
ARC0: Failed to archive log# 4 seq# 67399
ARC0: Beginning to archive log# 5 seq# 67400
Tue Sep 2 12:00:41 2003
ARC1: Completed archiving log# 4 seq# 67399
thanks
Satish
-
You can ignore those messages.
The messages are there when more than one proces tries to archive the same file and one fails but the other archives it successfully.
HTH
Sanjay G.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|