Re: What are the top 10 daily tasks in proactively administrating an Oracle database?

Hi,

our situation is like this:

in comparision we have a small db with about 4 GB of tablespqaces. Tablespaces and tables have been created to keep estimated data for the next three years without any need to extend. Every night we bring down the db (there is no traffic between midnight and 4 a.m.) and make an OS-backup of al db-related files: datafiles, archived logs, control files, full-export-dump, dumped controlfile. Archived logs and full-export-dump are also copied to another independant HD of the db-server.

What I do in the morning:

1. Check log-file of full-export which will tell you incosistencies in your db
2. Check the OS-Backup if not succesfull save at least full-export-dump to another server when there is no more time to run OS-backup again.
3. Check Alert-log for errors (Search string "ora-")
4. We use NT therefore I check the event-log
5. After OS-backup db should be restarted, so I check if db is up or start it up
6. Once in a while I check for fragmantation
7. Check license highwater mark in Alert-log to check that you don't commit license violations

-- 
Regards

M.Gresz    :-)