| Slow Archiving [message #65814] |
Mon, 03 January 2005 21:55  |
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  |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
