-
Slow Archiving
Hi,
I have O9i Prod & stdby DB. On Prod DB I have 9 Redo Log groups with 1 member each with 50MB each. The Stdby DB is config for Max Performance mode. Whenever there is a heavy lod on the DB than the Archiving process becomes very slow. At that time if I chk the alert log file, I see the following msg:
"ARC1: Unable to archive log 4 thread 1 sequence 9587
Log actively being archived by another process"
Following para are set on the prod DB:
-->log_archive_max_processes = 4
--> archive_lag_target = 3600
- log_archive_dest_2 service="(DESCRIPTION=(ADDRESS
_LIST = (ADDRESS=(PROTOCOL=tcp
)(HOST=xxx.xxx.x.xx)(PORT=1521
)))(CONNECT_DATA=(SID=xx)(OR
ACLE_HOME=/oracle/ora9/OraHome
)(SERVER=DEDICATED)))", ARCH S
YNC NOAFFIRM delay=180 OPTIONA
L max_failure=0 reopen=300
Please advice.
Alet pls let me know that in the max perf mode for stby db:
1) does Arch process creates the Arch log files 1st on the Prim & then on the Stdby & after that it creates the next Archive log
or
2)does the Arch process creates the Arch log files simultaneously on both DB & after that it creates the next Archive log
or
3) 1st Arch process creates the Arch log files the Prim & then creates the next Archive log on Prim independent of the Archive log copy on the Stdby
Thank You.
-
The reason for
ARC1: Unable to archive log 4 thread 1 sequence 9587
Log actively being archived by another process
is there are more than one archive process trying to write the log file.
There are so many reasons behind slow archiving.To get some idea about stand by especially in max performance mode check the following document which clarify some of ur doubts.
http://64.233.183.104/search?q=cache...nce+mode&hl=en
-
Increase size of the redo log file.
-
Slow Archiving
Dear Friend,
as u said that the reason for
ARC1: Unable to archive log 4 thread 1 sequence 9587
Log actively being archived by another process
is there are more than one archive process trying to write the log file, so do I need to change the para "log_archive_max_processes", ie, do I need to increase or decrease it.
Thank You.
-
Re: Slow Archiving
Originally posted by sadiq
ARC1: Unable to archive log 4 thread 1 sequence 9587
Log actively being archived by another process
is there are more than one archive process trying to write the log file, so do I need to change the para "log_archive_max_processes", ie, do I need to increase or decrease it.
This is not a problem - you will see a success message following it - I wouldn't change anything because of this.
Are you seeing any other warning/error messages in the alrt.log? (e.g. Check point not complete.)
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
|