| Project [message #170727] |
Thu, 04 May 2006 23:51  |
prashanthgs
Messages: 89
Registered: May 2005
Location: chennai
|
Member |
|
|
Hi,
I am an Oracle DBA ( junior level ), we are maintaing more than 45 remote database in oracle 8i and 9i on linux.
Actually i would like to do some project to enhance our process in the work at team level.
Can u pls give idea and suggestions to do the same.
-Thanks and Regards,
Velappan.g.s.
|
|
|
|
|
|
| Re: Project [message #170753 is a reply to message #170743] |
Fri, 05 May 2006 01:27  |
prashanthgs
Messages: 89
Registered: May 2005
Location: chennai
|
Member |
|
|
Our senior people created a Url for checking Daily Backup and Analyze monitoring so that v can check whether its failed or not by looking into URL than logging in to particular servers.
As the sameway I too would like to contribute from my side.
Our routine work include:
Checking alert mails - outlook
backup and analyze monitoring - if fails to start again (URL)
User requests
Maintenance etc etc.
Hope I am clear.
|
|
|
|
|
|
|
|
| Re: Project [message #171580 is a reply to message #171345] |
Wed, 10 May 2006 08:12 |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
Then review the task (or tasks) that are performed manually to each of these databases from your central database and look at either having a single process access then all (serially) and give you a single report, or look at using dbms_job to do each of them each day, store the results in this central database, and then run a report against this stored information, again by dbms_job with the summaried output being emailed to an account and any error condition emailed to a special account, or SMSed to a mobile, or to a blackberry.
David
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
