OraFAQ Forum: Server Administration » Check list for oracle administration

Home » RDBMS Server » Server Administration » Check list for oracle administration

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Check list for oracle administration [message #201407]

Sat, 04 November 2006 02:07

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.

Report message to a moderator

Re: Check list for oracle administration [message #201415 is a reply to message #201407]

Sat, 04 November 2006 02:25

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

Report message to a moderator

Re: Check list for oracle administration [message #201424 is a reply to message #201415]

Sat, 04 November 2006 02:56

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......

Report message to a moderator

Re: Check list for oracle administration [message #201427 is a reply to message #201424]

Sat, 04 November 2006 03:02

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

Report message to a moderator

Re: Check list for oracle administration [message #201500 is a reply to message #201407]

Sun, 05 November 2006 02:36

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

Report message to a moderator

Previous Topic:	Conflicting database timestamp
Next Topic:	mimeheader_encode

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 05:29:06 CDT 2024