Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Day to day UNIX support for oracle

SOLVED
Go to solution
f. halili
Trusted Contributor

Day to day UNIX support for oracle

What are the common day to day support needed for a system running oracle? Does oracle have logs that can be backed up to tape & trimmed? How can I identify the "database files" in the system? How can I identify if it is in a raw partition? BIG THANKS!!
8 REPLIES
Jean-Luc Oudart
Honored Contributor

Re: Day to day UNIX support for oracle

The question is quite general.

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
fiat lux
Yogeeraj_1
Honored Contributor

Re: Day to day UNIX support for oracle

hi,

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Jean-Luc Oudart
Honored Contributor

Re: Day to day UNIX support for oracle

Database files :

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
fiat lux
Julio Yamawaki
Esteemed Contributor

Re: Day to day UNIX support for oracle

Hi,

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,
TwoProc
Honored Contributor

Re: Day to day UNIX support for oracle

Add one more - read your audit files and connection files to see who's logging in and from where ... Look in $ORACLE_HOME/network/admin/{instance_name}.log , also look in $ORACLE_HOME/rdbms/audit. These need to be scanned for connections that don't make sense. Get familiar with what's in there so you konw what's supposed to be in there.

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.

We are the people our parents warned us about --Jimmy Buffett
Indira Aramandla
Honored Contributor
Solution

Re: Day to day UNIX support for oracle

Hi Halili,

Day 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
Never give up, Keep Trying
Ranjith_5
Honored Contributor

Re: Day to day UNIX support for oracle

Hi Halili,

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
f. halili
Trusted Contributor

Re: Day to day UNIX support for oracle

thanks for all the tips. these will help me more as unix sa to support the oracle team.