Home » Server Options » RAC & Failsafe » RAC Maintenance ((Oracle RAC 11g (11.2.0) three node RAC, RHEL 5.7))
RAC Maintenance [message #539038] Tue, 10 January 2012 23:48 Go to next message
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 #539172 is a reply to message #539038] Wed, 11 January 2012 21:47 Go to previous messageGo to next message
Modaya
Messages: 10
Registered: September 2008
Location: Colombo
Junior Member
hi..can anyone help me on this please...
Re: RAC Maintenance [message #539453 is a reply to message #539172] Mon, 16 January 2012 02:08 Go to previous messageGo to next message
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

Re: RAC Maintenance [message #539538 is a reply to message #539453] Mon, 16 January 2012 22:15 Go to previous message
Modaya
Messages: 10
Registered: September 2008
Location: Colombo
Junior Member
Thanks a lot... Smile
Previous Topic: Impossible to install Oracle Grid Infrastructure
Next Topic: Database Time Spent Waiting Warning
Goto Forum:
  


Current Time: Thu Mar 28 13:07:06 CDT 2024