Solved

oracle 11g database maintenance

Posted on 2015-01-13
10
344 Views
Last Modified: 2015-01-21
Other than weekly backups and etc. what are good maintenance scripts, or jobs to help performance, and functionality of the oracle database.

Cleanup, compact, defrag, etc.

I am new to oracle, and etc.

The oracle database is for an application that runs on windows server 2008r2.

to do stuff on oracle db, I usually connect via powershell
0
Comment
Question by:Indyrb
  • 5
  • 4
10 Comments
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 40546919
Weekly backups?  Doesn't it change that often?  Must not be a production database or at least not an important one.

As for what you need to do:
Hard to say.  Every database and DBA is different.  What is important to one, may not be important to another.

As long as you have disk space, memory and CPU available, you should be good.  Anything else is database/DBA specific.
0
 
LVL 22

Expert Comment

by:Steve Wales
ID: 40546929
If you have a production database you're probably going to want a much more frequent backup cycle than weekly.

How much data can you stand to lose in the event of a failure ?

You may want to consider something more like an incremental level 0 backup once or twice a week, incremental level 1's on the other days and frequent archive log backups (hourly, half hourly or more frequently depending upon how critical your data is.

There are lots of logs and trace files routinely generated by an Oracle database.

I rename my alert logs weekly and keep the last several weeks on disk, just in case I need to review them, I also do the same with my listener.log.

Under your diag destination (usually %ORACLE_BASE%/diag)  you'll want to clean up trace files (*.trc & &.trm) older than some number of days (15, 30, 60, depending on your needs) and also there are XML versions of the alert log and listener log files that need cleanup as well.

All of this can be scripted with Windows CMD scripting (I'm not familiar with Powershell in detail but I'm sure it can do the same).
0
 

Author Comment

by:Indyrb
ID: 40547240
This will be the third time I try to reply to this, as I keep getting A Sync re1quired errors....

So I will copy and paste this time, and hope I put in all previous statemnets on other responces.

I was just curious if there was anything other than regular backups or updates.

On backups, it could run daily, or more.. incremental then full weekly... I am not sure.. it runs on a solaris server, I don't administer.  However I connect via powershell or command propmpt with the sqlplus command.

So I was curious is there oracle commands or scripts that would make my database more optimal per say.
defarg, compact, cleanup, or etc.

On the windows 2008 R2 server runs that application that has an oracle client _instant client installed.
The application uses java, and gerinimo web... along with proprietary software.

Just curious on what all I can do from the database side to make sure it runs the best way possible.
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 40547294
I'm guessing you are wanting more from an application performance check not really a DBA check.

>>I am not sure.. it runs on a solaris server, I don't administer.

Then you shouldn't be worried about backups and such.  If you are, then you need to talk to your DBAs to see what/how they are doing it.

Backup up the OS isn't good enough for Oracle.

>>Just curious on what all I can do from the database side to make sure it runs the best way possible.

Hire a good DBA.

Many of them have scripts they have kept with them for many years for many different things.

Most of the things you would need to be concerned with from a performance aspect is also in the DBA realm.

If you are licensed for it the Performance Pack has a LOT of useful stats and reports of things you can check.  Look around for AWR and ADDM.  They also have tuning 'Advisors' that will make suggestions based on available statistics like index creation, data movement, etc...

If you are not licensed for it, I believe StatsPack is still around.

I will warn  you now that the outputs from those tools are more for DBAs not application folks.

They will tell you things like 'bad' performing SQL and a few things that may help from an application developer perspective.
0
 

Author Comment

by:Indyrb
ID: 40551466
well. id be interested in these orable scripts that people hold on or evolve from time... I believe these could help me please... ideas thoughts. thanks in advance. and thanks for your replies
0
What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 40551487
Most scripts are already out there.

Figure out what you want to look at and Google around.

There are also sites that have a LOT of them in one place.

For example:
http://oracle-base.com/dba/scripts.php
http://www.dbatoolz.com/sql-scripts


Since you aren't the DBA you will likely be very limited in what views you have access to.
0
 

Author Comment

by:Indyrb
ID: 40551927
I have own on my database? but not on the server or whole oracle dabases. just mine
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 40551931
>>I have own on my database? but not on the server or whole oracle dabases. just mine

I do not understand what this is trying to tell me.
0
 

Author Comment

by:Indyrb
ID: 40552134
The database my application uses, I have an account that has ownership of the database... But only this database.
Not the whole Oracle Server or other objects, only the ones in my database -- ownership... Sorry, Didn't know if this was relevant or worth saying.
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 40552146
What permissions you have on what database will limit your ability to 'monitor' certain things.

For example:
If the scripts you find query the DBA level views, you'll need access to those views.
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

This article will show, step by step, how to integrate R code into a R Sweave document
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now