Home » RDBMS Server » Performance Tuning » Slow Archiving
Slow Archiving [message #65814] Mon, 03 January 2005 21:55 Go to next message
sadiq
Messages: 3
Registered: December 2003
Junior Member
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.

Also 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.
Re: Slow Archiving [message #65816 is a reply to message #65814] Tue, 04 January 2005 03:00 Go to previous messageGo to next message
Alan
Messages: 68
Registered: October 1999
Member
hello
after the error do you get a message saying

completed archiving

if you do then everything is okay

cheers
Re: Slow Archiving [message #65821 is a reply to message #65816] Tue, 04 January 2005 20:54 Go to previous message
sadiq
Messages: 3
Registered: December 2003
Junior Member
Hi Alan,

No I dont get the message "completed archiving".

Thank You.
Previous Topic: Column Level Locking?
Next Topic: Oracle 8/9/10 performance problem
Goto Forum:
  


Current Time: Wed Sep 23 14:44:40 CDT 2020