- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle backup consumig excessive CPU time
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-24-2003 07:17 AM
тАО04-24-2003 07:17 AM
The backup includes copying tablespace datafiles to a backup area on our RAID. Then the data is written to tape. It is the first part of writing to the backup area that loads the CPU excessively. Once the write to tape step begin, we see CPU loading reduced and returned to normal upon completion.
We've tried using 'nice' for process prioritization, but that hasn't helped much.
System Info:
HP-UX 10.20
HP K420
Oracle 7.3.2.2
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-24-2003 07:45 AM
тАО04-24-2003 07:45 AM
SolutionI think the problem could be the disks with high utilization during backup. Have you monitored the disks with "sar -d" or glance?
If the utilization are very high, will be necessary to divide the lod between many disks, maybe using disk stripe.
regards
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-24-2003 07:52 AM
тАО04-24-2003 07:52 AM
Re: Oracle backup consumig excessive CPU time
Instead of a copy for each backup why not mirror the backup area to the data and then split it away at backup time and merge back in when finished.
Ps the database may need to be stopped/synced during the split away to ensure file integrity.
Paula
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-24-2003 08:16 AM
тАО04-24-2003 08:16 AM
Re: Oracle backup consumig excessive CPU time
Check for bottlenecks during this window and attach:
sar -u 5 5
sar -d 5 5
vmstat 5 5
sar -v 5 5
swapinfo -tam
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-24-2003 10:47 AM
тАО04-24-2003 10:47 AM
Re: Oracle backup consumig excessive CPU time
Could you elaborate on breaking a mirrored pair of drives? Can the primary mirrored drive still stay active while we work with the second drive to backup data? And, what would be the performance cost in reestablishing the mirrored pair?
Thanks all for your assistance.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-24-2003 11:02 AM
тАО04-24-2003 11:02 AM
Re: Oracle backup consumig excessive CPU time
When breaking a mirror it depends upon your data being stored, as if active there is a possiblity of an incomplete record write.
Most databases have a lock command which will hold the database during the mirror split (this should take less than a second.)
Then as soon the split has occured then it can be unlocked - most users would be unaware that a split had occured.
On my database I have a triple mirror which I split away one to backup whilst live.
It is a very safe way on a database that must be available 25/7/365.
The best way is to script the split and restore into your backup routine echoing time and date into a log file :-
echo " Start time" > /tmp/mirror.log
date > /tmp/mirror.log
"database hold command"
lvsplit "lvol"
fbackup command
lvmerge "lvol"
echo " End time" > /tmp/mirror.log
date > /tmp/mirror.log.
Test it fully on a sandbox (Play) server.
Paula
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-24-2003 03:08 PM
тАО04-24-2003 03:08 PM
Re: Oracle backup consumig excessive CPU time
I agree with Paula.That's how we backup our database which are mirrored.This are the step that we take :
1) stop the database
2) split the mirror
3) bring up database without mirror
4) backup the mirror
5) after finish backup,mirror back the database.
regards
mB
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-24-2003 05:05 PM
тАО04-24-2003 05:05 PM
Re: Oracle backup consumig excessive CPU time
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-24-2003 05:28 PM
тАО04-24-2003 05:28 PM
Re: Oracle backup consumig excessive CPU time
Could you attach or check your lvdisplay please. Is the value of mirror 0, 1, 2?
Are there BCV's involved on this disk array? Hot backups with a BCV don't include an LVM mirror split.
How are splitting mirrors going to remove a CPU bottleneck which is defined as 0% CPU idle + higher then usual process level + more than one job waiting in the run queue?
I apologize if I've missed something but I think we've taken a wrong turn somewhere.
And I renew my request to evaluate your system with the 'sar' commands attached above.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-25-2003 02:57 AM
тАО04-25-2003 02:57 AM
Re: Oracle backup consumig excessive CPU time
My logic is that trying to backup a live database will cause problems as the disks will be very busy with the backup routine and the users both trying to access files, so it you split away a seperate area that only the backup routine is using then the load generated by this heavy disk usage will be reduced.
BTW the log commads should use >> and not >
Paula