Hi
Vidya,
The
word "Health" can mean a lot e.g.: Compliant to standards, performing,
functioning, not corrupted, normalized data design, security,
etc.
I
think you are missing something regarding backup, restore and
corruptions:
- Does
DBVerify (dbv) report any problems with the datafiles?
- Can
a FULL export be made to /dev/null?
- When
was the last test of a restore from tape?
-
Duplexed controlfiles on different physical disks?
-
Multiplexed redo logs?
Alert.log:
- Are
there any errors in the alert.log?
- Does
the customer check the alert.log on a daily basis?
The
health of the applications:
- Any
objects with status "INVALID" in DBA_OBJECTS.? Which?
Regards
Jesper
Haure Norrevang
-----Oprindelig meddelelse-----Hi
Fra: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] P� vegne af Vidya Kalyanaraman
Sendt: 8. januar 2004 09:40
Til: Multiple recipients of list ORACLE-L
Emne: Database Health Review
I am supposed to be doing a database health review for one of the customers. They have Oracle database ver9.2.0.3 on HP UX 11i.
Normallly, we do check the following:
� OFA standards
� Purging Strategy
� Archival Strategy
� Database server utilization (shared pool area) - Run Statspack
� Latest certified combination of Oracle Products.
� Transaction Management (RBS, Redo)
� OLTP init.ora parameters
� Optimizer statistics
� Custom Code Management
� NLS Setup
� Server and storage area configuration.
Did I miss out on anything?
Any comments/suggestions/pointers are most welcome.
Thanks and Regards
Vidya
