Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
cancel
Showing results for 
Search instead for 
Did you mean: 

oracle upgrade & archiving

VWR Admin
Advisor

oracle upgrade & archiving

after upgrading oracle from 8.1.6.2 to 8.1.7 on a V2500 the archive processes are taking forever and sar shows sys% anywhere from 50% to 90%. writes to the arch logs are going so slow that multiple arch processes start which further burdens the system. after a reboot things run fine for a while but then back into the same long archive processes! Anyone have this before or any ideas? Thanks Tom, tom_erickson@vwrsp.com
no one knows as much as all of us!
2 REPLIES
R. Allan Hicks
Trusted Contributor

Re: oracle upgrade & archiving

Are the archive logs switching more often? If so, why?

Could there be some tablespaces in hot backup causing the redo logs to fill more quickly?

What are the statuses of the tablespaces from V$BACKUP?

I'm at 8.1.6.0 and thinking about going to 8.1.7 so I'm real interested in what this turns out to be.
"Only he who attempts the absurd is capable of achieving the impossible
VWR Admin
Advisor

Re: oracle upgrade & archiving

This occurs during a purge process. We're still switching as many logs ans we we're under 8.1.6. The difference is the archive or multiple archivers slow down as time progresses. Normally the archive offloads a log in 30 seconds, we've seen it take up to 48 minutes in the wrose case situation. The tablespaces are not in backup mode during the purge process.
Go Sixers!!
no one knows as much as all of us!