July, 2010 | DB Dummy

CRS-2640: Required resource ‘ora.ARC2_DG.dg’ is missing.

PRCR-1079 : Failed to start resource ora.mydb.db

CRS-2640: Required resource ‘ora.ARC2_DG.dg’ is missing.

How to remove the ASM resource from CRS start/stop dependency?

Applies to:

Oracle 11gR2 RAC

Scenario:

(2 node RAC with 11gR2 in RHEL 5.3 x86_64)

I was having 2 ASM diskgroup (ARC1_DG & ARC2_DG) assigned for archive logs and standby Dataguard when first RAC .

Due to some reason that management want to merge these 2 diskgroups into one (ARC1_DG).

I confimed that ARC2_DG was not contain any file and diskgroup ARC2_DG dropped successfully.

Posted by helloworld in Database General, Oracle Database

Scenario:

TEMPSPACE “npts_tmpdbs3” is getting fill up.

We would like to check what is kept in this TEMPSPACE.

$ onstat -d | grep tmpdbs

8426c198 4 2001 4 1 N T informix npts_tmpdbs1

8426c258 5 2001 5 1 N T informix npts_tmpdbs2

8426c318 6 2001 6 1 N T informix npts_tmpdbs3

8426c3d8 7 2001 7 1 N T informix npts_tmpdbs4

83764f30 4 4 0 512000 509333 PO- /dev/infdev/npts_tmpdbs1.1

83765038 5 5 0 512000 312458 PO- /dev/infdev/npts_tmpdbs2.1

83765140 6 6 0 512000 9675 PO- /dev/infdev/npts_tmpdbs3.1

83765248 7 7 0 512000 509421 PO- /dev/infdev/npts_tmpdbs4.1

Steps:

(1) Get TBLspace partnum using DBspace number.

Posted by helloworld in Database General, Informix Database