While checking my OCR backup I wondered why Oracle keep creating
OCR backup without deleting the old ones. Should I delete them by my own?.. it
sounds unkind!!.
I start searching on Google and metaling.. Guess what??? It’s a
BUG.
That simply means, if you have dozens of OCR backups you may
facing the same bug. Since the OCR backups should consist of 7 files as follow:
#ls -ltr u02/app/11.2.0/grid/cdata/feco-cluster/day* week*
backup0*
-rw------- 1 root system
7028736 May 22 2011 backup02.ocr
-rw------- 1 root system
7028736 May 22 2011 backup01.ocr
-rw------- 1 root system
7028736 May 22 2011 backup00.ocr
-rw------- 1 root system
6979584 May 22 2011 week.ocr
-rw------- 1 root system
7028736 May 22 2011 day_.ocr
-rw------- 1 root system
7028736 May 22 2011 day.ocr
presenting the result of :
# ./ocrconfig -showbackup auto
feco04 2014/05/24 12:31:09
/u02/app/11.2.0/grid/cdata/feco-cluster/backup00.ocr
feco04 2014/05/24 08:31:07
/u02/app/11.2.0/grid/cdata/feco-cluster/backup01.ocr
feco04 2014/05/24 04:31:06
/u02/app/11.2.0/grid/cdata/feco-cluster/backup02.ocr
feco04 2014/05/23 04:31:00 /u02/app/11.2.0/grid/cdata/feco-cluster/day.ocr
feco04 2014/05/14 04:29:51
/u02/app/11.2.0/grid/cdata/feco-cluster/week.ocr
My current ocr backup look like:
-rw------- 1 root system
7221248 Jun 24 2013 13458777.ocr
-rw------- 1 root system
7221248 Jun 24 2013 14872007.ocr
-rw------- 1 root system
7221248 Jun 24 2013 28713517.ocr
-rw------- 1 root system
7221248 Jun 25 2013 39937824.ocr
-rw------- 1 root system
7221248 Jun 25 2013 56169871.ocr
-rw------- 1 root system
7221248 Jun 25 2013 58569011.ocr
:
:
-rw------- 1 root system
7221248 Jun 27 2013 21069301.ocr
-rw------- 1 root system
7221248 Jun 27 2013 11741111.ocr
-rw------- 1 root system
7221248 Jun 27 2013 29616835.ocr
-rw------- 1 root system
7221248 Jun 27 2013 19887106.ocr
-rw------- 1 root system
7221248 Jun 28 2013 27246017.ocr
And crsd.log showing this error:
OCRSRV][9521]Failure in renaming file [/u02/app/11.2.0/grid/cdata/feco-cluster/25677603.ocr]
to [/u02/app/11.2.0/grid/cdata/feco-cluster/backup00.ocr]
How to solve that???
According to (Doc ID 1191067.1) "change all 7 automatic backup files to be owned by
root:root with permission "-rw-------""
The current privilege of the 7 files are:
-rw-r--r-- 1 grid oinstall
7028736 May 22 2011 backup02.ocr
-rw-r--r-- 1 grid oinstall
7028736 May 22 2011 backup01.ocr
-rw-r--r-- 1 grid oinstall
7028736 May 22 2011 backup00.ocr
-rw-r--r-- 1 grid oinstall
6979584 May 22 2011 week.ocr
-rw-r--r-- 1 grid oinstall
7028736 May 22 2011 day_.ocr
-rw-r--r-- 1 grid oinstall
7028736 May 22 2011 day.ocr
Just change them to:
chown root:system week*
chown root:system day*
chown root:system backup0*
chmod 600 week*
chmod 600 day*
chmod 600 backup0*
:-)
Note:
My database version is : 11.2.0.2.0
Reference:
Automatic OCR Backup Filling Up
<CRS_HOME>/cdata/<clustername> Directory (Doc ID 1191067.1)
No comments:
Post a Comment