| RAC Maintenance [message #539038] |
Tue, 10 January 2012 23:48  |
Modaya
Messages: 10
Registered: September 2008
Location: Colombo
|
Junior Member |
|
|
Dear all,
Every morning as a practice I'm checking Alert_log , Data file space, Archive log space..
I need an advice as a good practice to maintain and Manage RAC environment , what else should I check every morning ... ( any log files , locations, memory , etc .....)
|
|
|
|
|
|
| Re: RAC Maintenance [message #539453 is a reply to message #539172] |
Mon, 16 January 2012 02:08  |
 |
himabija
Messages: 33
Registered: December 2011
Location: San Francisco
|
Member |
|
|
To maintain the RAC ,you need to understand the concept of all clusterware component and background services.Here I'm proving you some tips to monitor clustered database. But keep in mind this not complete set of monitoring instruction.You might need to take additional care for your environment specific things.
1.monitor the alert.log of the database instances
2.monitor the alert.log of the ASM instances
3.monitor the alert of the CRS, crsd.log and ocssd.log files.
a.Check the integrity ocr
b.check online status of voting disk
4.monitor the space usage on ASM diskgroups or in Your cluster file system
5.You should verify if there is services/resources down also need to check overall cluster status
./crsstat -t (for oracle 10grun this from crs_home/bin)
./crsctl status resource -t (for oracle 11gR2 run this from crs_home/bin)
6.monitor the performance and contentions in Your instances.
7.verify if backups of Your databases are been executed
8.backup the Vote disk using dd
9.copy to tape the OCR's backups
10.Also monitor realtime alert from instances using OEM or any other monitoring tool[Updated on: Mon, 16 January 2012 02:21] Report message to a moderator |
|
|
|
|
|
] 
Search
Help
Members
Register
Login
Home
