Home » RDBMS Server » Server Administration » Check list for oracle administration
Check list for oracle administration [message #201407] Sat, 04 November 2006 02:07 Go to next message
amena
Messages: 14
Registered: August 2005
Location: pak
Junior Member
can some one plz provide me a check list for oracle adminstration as
i m supposed to look after a database server.
Re: Check list for oracle administration [message #201415 is a reply to message #201407] Sat, 04 November 2006 02:25 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi
Sorry but i am not getting ur point.
anyway i think you want to talking about "doc".
Link is below.
http://www.oracle.com/pls/db102/portal.portal_db?selected=2


Hope this helps
Mohammad Taj
Re: Check list for oracle administration [message #201424 is a reply to message #201415] Sat, 04 November 2006 02:56 Go to previous messageGo to next message
amena
Messages: 14
Registered: August 2005
Location: pak
Junior Member
thank for quick reply

i am going to take ovet a oracle 9i database server from another
DBA , as i am new to database and due to some reason i am suppose to do the job , for that i need a check list for data base administration......
Re: Check list for oracle administration [message #201427 is a reply to message #201424] Sat, 04 November 2006 03:02 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

It is better to ask ur DBA.
or What you know about ur database like ...
1.size
2.backup and recovery procedure.
3.database type OLTP or DSS
4.how many users.

If you'r new to oracle administration then first go through doc. and create test database for ur production database and testing on test database.

Create Test db from production.
simple used import or export utilities if database size is small.
or
use rman
or
user managed bkp.


and play with ur test db. or if any problem you face plz. concern with us.

Hope this Helps
Mohammad Taj
Re: Check list for oracle administration [message #201500 is a reply to message #201407] Sun, 05 November 2006 02:36 Go to previous message
Shamsher
Messages: 18
Registered: September 2006
Junior Member
As Starting you can go for this things.

Alert Monitoring( Its very important as most of the dba skip this you will really find what really happing in your database there)
I/O monitoring
mem usage
tablespace management
backup status

these are few things you can monitor initallay for most of the things you will be getting a lot of ready made scripts on web just give a search on google.

Regards
Shamsheer
Previous Topic: Conflicting database timestamp
Next Topic: mimeheader_encode
Goto Forum:
  


Current Time: Sun Dec 11 04:10:33 CST 2016

Total time taken to generate the page: 0.09316 seconds