orawin.info

Niall's Oracle Pages – Oracle Opinion since 2004

Archive for the ‘recovery’ tag

Always Check Your Backups

without comments

So this is a 2 node RAC cluster on RHEL that was recently upgraded from 10.2.0.2 to 10.2.0.4. Since then clusterware restarts crs every few hours (8 in fact). A little research suggests that this can indicate problems with the automated OCR backup.  The first thing therefore is to check the state of the backups.

[server] $ORA_CRS_HOME/bin/ocrconfig -showbackup
server 2006/10/25 11:21:23 /u01/crs/oracle/product/10.2/crs01/cdata/cluster_name
server 2006/10/25 07:21:22 /u01/crs/oracle/product/10.2/crs01/cdata/cluster_name
server 2006/10/25 03:21:20 /u01/crs/oracle/product/10.2/crs01/cdata/cluster_name
server 2006/10/24 03:21:13 /u01/crs/oracle/product/10.2/crs01/cdata/cluster_name
server 2006/10/17 21:44:24 /u01/crs/oracle/product/10.2/crs01/cdata/cluster_name

yes that’s right nearly 3 1/2 years since a successful ocr backup. When did you last check yours.

Possibly Related Posts:

  • No Related Posts found

Written by Niall Litchfield

March 10th, 2010 at 1:40 pm

Posted in Uncategorized

Tagged with ,