Let's assume that you're invited to my organisation to look into my platform, which has thousands of databases if not less, and you are requested to check various aspects of these databases to tell me where I am going wrong w.r.t administration, health checks, backups, etc.
What would be the points that you'd cover during such an excercise?
E.g., how the backups are being taken? What parameters to monitor day by day? Script(s) to identify bad queries? Etc ..
Some suggestions in this regard would be really helpful.
Probably the easiest way to approach a health check is to follow this note from MOS:
https://support.oracle.com/epmos/faces/ ... d=122669.1
It's got most of the major steps you should consider.
The backups are a little more tricky to advise on because it is so dependent on the system. You have to consider DB size, performance, mean time to recovery etc. It's something you need to discuss on a per-database basis.
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Who is online
Users browsing this forum: No registered users and 15 guests