- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- how to backup database (oracle) and performance tu...
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
тАО03-21-2001 07:11 AM
тАО03-21-2001 07:11 AM
how to backup database (oracle) and performance tuning
I have two questions:
1) Our hp box ( 10.20 - 9000/800) is running oracle 8.0.6. From what I can see in the cron job setup the database isn't being backed up on tape, just the data. Correct if I'm wrong but isn't it possible to also backup the database? For some reason the previous sys. admin. had told people here that the database on the unix box can't be backed up.
2) Also, we are considering hiring an oracle consultant to come here and do performance tuning on the unix box and the oracle database.
That box runs very slow even with just a little job sent to it.
From what i've been told no one has ever done any tuning on that machine.
What opinions or suggestions do you have the performance tuning being done?
Is it better to get an oracle consultant to do this or maybe someone from HP? The oracle database has Lawson running on it as well....the company here is VERY dependant on the Lawson application running smoothly.
thank you so much for any help or advice,
Oskar
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-21-2001 07:30 AM
тАО03-21-2001 07:30 AM
Re: how to backup database (oracle) and performance tuning
Cold backups are by far the most reliable especially for an ORACLE novice but they require the database to be down for the duration of the backup. Hot backups work quite well but the recoveries can be very tricky.
An alternative that I might suggest is a snapshot backup using Online JFS.
Under this scheme you:
1) Shutdown the database.
2) 'Snapshot' mount the database fiulesystem(s)
using mount -F vxfs -o snapof= ....
3) Startup the database
4) Backup the snapshots.
5) Unmount the snapshot(s).
The database downtime will be at most 5 minutes
and probably much less. You can then backup
the snapshots at leisure.
In any event you need to implement some method.
You could probably acquire all the knowledge you need for cold (or snapshot) backups from ORACLE books but I suggest that if you must do hot backups that you find a DBA. At this point compared to the importance of backups any database tuning needs are trivial.
One other suggestion is that you install a test oracle instance to test any backup scheme before moving to production.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-21-2001 07:40 AM
тАО03-21-2001 07:40 AM
Re: how to backup database (oracle) and performance tuning
1. "the database on the unix box can't be backed up."
Be glad that he is the 'previous' sysadmin and not the current one ;) Of course the database can be backed up : shutdown & filesystem backup, Oracle export, ...
2. if Oracle is the major application I would certainly recommend an Oracle consultant. Benefits of database tuning 'normally' outweigh operating system tuning. The ultimate choice would be however an Oracle consultant with major HP-UX knowledge,
(like me
good luck
Thierry.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-21-2001 11:45 PM
тАО03-21-2001 11:45 PM
Re: how to backup database (oracle) and performance tuning
I'm running 8.0.6 and using Oracles Recovery Manager (RMAN) to run backups.
This allows you to backup online (hot) databases and also backup and remove archived redologs, so that you don't end up with an full archive filesystem, as the database then will stop.
RMAN is included in the Oracle software and can be set up to run standalone or using a recovery database (recomended).
To setup a Recovery solution like this might be quite advanced but once you got it up running you have a nice tool on your hands.
On setup of RMAN I recomend Oracle Metalink Note:109223.1 and 106432.1
As of performance tuning, the main topics that has to be checked and possibly adjusted is:
-database file placement
spread tablespaces over multiple drives, keep applikation/user objects out of the system tablespace
-redolog file size and number
Allow for the archiver to finish before redolog has to be reused, and aviod frequent log switches (generates checkpoint activity)
-rollback segment size and number
4-10 transactions pr segment(OLTP), 1 transaction pr segment for batch systems.
-latches
as well as a big enough SGA:
-DB_BLOCK_BUFFERS
-SHARED_POOL_SIZE
-LOG_BUFFER
Be advised not to overdo the size of the SGA, if you define the size bigger than the size available in your physical memory, Oracle will begin to swap the SGA out to disk and then you'r in trouble.
In the end I might add that tuning the application (SQL statements, indexes etc) has a far greater effect on performance than tuning the database itself. Oracle installations tend to be quite OK setup when installed out of the box.
Good luck!
regards
Andreas
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-22-2001 05:49 AM
тАО03-22-2001 05:49 AM
Re: how to backup database (oracle) and performance tuning
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-22-2001 07:31 AM
тАО03-22-2001 07:31 AM