- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Day to day UNIX support for oracle
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
тАО01-13-2005 12:17 AM
тАО01-13-2005 12:17 AM
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-13-2005 12:28 AM
тАО01-13-2005 12:28 AM
Re: Day to day UNIX support for oracle
Among other tasks
- space/storage monitoring
- performance monitoring
- backup (and restore)
Scripts can complete or help most of these tasks.
You will have to manage the archive logs (script too).
Regards
Jean-Luc
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-13-2005 12:34 AM
тАО01-13-2005 12:34 AM
Re: Day to day UNIX support for oracle
First of all, you must read this document from start to end:
http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76965/toc.htm
Each of your question is explained there and much more information is available there.
if you still have queries, please let us know.
regards
Yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-13-2005 12:34 AM
тАО01-13-2005 12:34 AM
Re: Day to day UNIX support for oracle
sqlplus session :
dictionary =>
select * from dba_data_files
control files =>
select * from v$datafile
select * from v$datafile_header
no information on raw on non-raw as far as I recall (the name would not be enough).
Regards
Jean-Luc
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-13-2005 03:37 AM
тАО01-13-2005 03:37 AM
Re: Day to day UNIX support for oracle
There are a couple of things that a Oracle Dba has to do every day, and these can be automated:
1. On-line backup of database
2. Backup of archivelog and trimmimg of these files
3. Verify alert.ora log file to see any database errors
4. Performance issues: this can be done with scripts, Oracle Enterprise Manager and some tools from CA and other vendors
5. Check datafile for data, to see if these area near full and extend these before
6. Check dump files in bdump and udump directories, to see any errors
7. See this thread for good scripts for Oracle: http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=76776
Regards,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-13-2005 04:06 AM
тАО01-13-2005 04:06 AM
Re: Day to day UNIX support for oracle
But, more basic advice for learning would be: a) find out where your local Oracle User Group is, join, attend the seminars and learn. Become active in the group. You'll build alliances for support that will become invaluable to you.
b) Read the Oracle 8i/9i or 10G Concepts Guide from Oracle. Join http://otn.oracle.com - sign up and get your account. All books and documentation are there for download including the one I just mentioned. This guide is very good, and will tell you the hows and whys of the components of the database.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-13-2005 08:03 PM
тАО01-13-2005 08:03 PM
SolutionDay to day UNIX support for oracle.
Storage Space Management
- Make sure there is enough space for the tablespace (datafile) growth.
- Regular triming of the archive logs
- Regular triming of aler log and user dump logs
- Regular maintenace of audit logs
Backup & Recovery
- Backup of the database and archivelogs
- Restore of the database from the tape or backup directory
- Regular cleaning of the old logical export dmp files
Jobs Schedules
- Cron jobs
- Any other scheduled jobs
- Regular clean up of the output logs / reports
Users and Privileges
- Oracle user and any other OS authenticated users.
- Check that the users are not locked or password expired.
- Access privileges in the respective directories.
- FTP if required to send reprots to other server in the network
Performance Monitoring
Rerely, when new installations execute root.sh for the DBA.
Indira A
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-13-2005 08:58 PM
тАО01-13-2005 08:58 PM
Re: Day to day UNIX support for oracle
ORACLE database files are with extension DBF.
See oracle concepts here
http://www.adp-gmbh.ch/ora/concepts/
I am explaining here the procedures which we are following at our place. We have our ERP running on Oracle with more than 100 servers in the same site.I think that the info will be useful for you.
We create raw partitions only if RAC is required on servers and at the same time there is no licence purchased for cluster file system.
So if you have RAC there may be a chance of raw partitions in those servers.
You can see those using #lvdisplay command as you normally do. But these raw volumes wont be mounted anywhere,for the use of RAC.
Common Procedures follows on Oracle Servers at my place are:
=============================================================
I. Managing Space constraints
II BACKUPS;-
==============
1. Archive log management, which includes a scheduled backup of archive logs and manual deletion of archive logs. We have configured sendmail for this purpose to show , if any volume size exceeds 90%. So we get the notification by email.
2. We start applying the archive logs in the DR site with in 24hrs after the backup.
3. We take archive log backups every 6 hrs. ie; 4 times a day.
4. We take weekly cold backup and the same will be restored with in 24hrs after the backup at the DR site.
5. We take online backup of oracle using rman. Obviously all of you may be doing the same thing. Nothing special here.
III.
======
Process management changing priorities of running jobs according to the DBAs.
IV.
===
Performance Checklist ... We use HP Open View Performance manager for this.
Also it is very good to keep your production system in a secured way. Make atrusted system and enable auditing on your sevrer. Regularly monitor log files.
HTH-
Syam
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-18-2005 01:34 AM
тАО01-18-2005 01:34 AM