Please find the basic monitoring setup required for Oracle database.
1.Tablespace monitoring
2.File system monitoring
3.alert log monitoring
4.pmon status
5.Listener status
6.database block corruption
Backup monitoring
------------------------
1.backup start/completion status monitoring
2.in case of RMAN backup ,monitor sync status with catalog database.
3.Incase of hot backup ,check Db datafiles whether it come out of begin backup once backup completes.
Data gaurd Monitoring
------------------------
1.check both Primary & standby SYnced always
2.check on standby MRP process
ASM monitoring
------------------
1.check the free_MB of each Disk
2.check the Disk status
RAC monitoring
--------------------
1.check the CRS,CSSD,EVMD and alert if its down
2.check the cluster status
Golden gate monitoring
-----------------------
1.check the extract/replicat/manager/datapump process
2.check the record count on both source & Target tables
performance tuning Monitoring
--------------------------------
1.check if the server CPU goes beyond certain threshold level
2.check if any SQL has multiple hash value
3.check periodic stats on Database
4.check periodic defragmentation happening on application objects
5.check if any DML locks occuring on database
1.Tablespace monitoring
2.File system monitoring
3.alert log monitoring
4.pmon status
5.Listener status
6.database block corruption
Backup monitoring
------------------------
1.backup start/completion status monitoring
2.in case of RMAN backup ,monitor sync status with catalog database.
3.Incase of hot backup ,check Db datafiles whether it come out of begin backup once backup completes.
Data gaurd Monitoring
------------------------
1.check both Primary & standby SYnced always
2.check on standby MRP process
ASM monitoring
------------------
1.check the free_MB of each Disk
2.check the Disk status
RAC monitoring
--------------------
1.check the CRS,CSSD,EVMD and alert if its down
2.check the cluster status
Golden gate monitoring
-----------------------
1.check the extract/replicat/manager/datapump process
2.check the record count on both source & Target tables
performance tuning Monitoring
--------------------------------
1.check if the server CPU goes beyond certain threshold level
2.check if any SQL has multiple hash value
3.check periodic stats on Database
4.check periodic defragmentation happening on application objects
5.check if any DML locks occuring on database
No comments:
Post a Comment