Category: GI and RAC

Increase Voting Diskgroup Size

Here is an example of how to increase GI voting disk group size.

  1. Add a new disk with bigger size into current voting disk group.
  2. Drop the old small size disk.
SQL> select NAME, STATE,VOTING_FILES,total_mb, free_mb 
     from v$asm_diskgroup
     where NAME='VOTE_OCR";

NAME     STATE  VOTING_FILES TOTAL_MB FREE_MB
VOTE_OCR MOUNTED Y              51196    6352

SQL> alter diskgroup VOTE_OCR add disk '/dev/ASM/VOTE_OCR_002' NAME VOTE_OCR_002;

Diskgroup altered.
SQL> select NAME, STATE,VOTING_FILES,total_mb, free_mb 
     from v$asm_diskgroup
     where NAME='VOTE_OCR";

NAME     STATE  VOTING_FILES TOTAL_MB FREE_MB
VOTE_OCR MOUNTED Y           153592   108736 
SQL> alter diskgroup VOTE_OCR drop disk 'VOTE_OCR_001';

Diskgroup altered.

PRCA-1000 : ASM Disk Group DSGRP123 does not exist

Trying to start up a database, and got the following error messages:

$ srvctl start database -d testdb
PRCR-1079 : Failed to start resource ora.testdb.db
CRS-2640: Required resource 'ora.DSGRP123.dg' is missing.
$srvctl config database -d TESTDB
...
..
.
PRCD-1012 : Failed to retrieve disk group list for database TESTDB.
PRCR-1035 : Failed to look up CRS resource ora.DSGRP123.dg for TESTDB
PRCA-1000 : ASM Disk Group DSGRP123 does not exist

SOLUTION

$ srvctl modify database -d TESTDB -a "+DATA1,FRA"
$ srvctl start database -d TESTDB

ORA-15041: diskgroup “FRA” space exhausted

The following errors occur in Oracle database alert log :

...
..
.
Unable to create archive log file '+FRA'
Errors in file /u01/app/oracle/diag/rdbms/testdb/TESTDB1/trace/TESTDB1_arc1_12300.trc:
ORA-19816: WARNING: Files may exist in db_recovery_file_dest that are not known to database.
ORA-17502: ksfdcre:4 Failed to create file +FRA
ORA-15041: diskgroup "FRA" space exhausted

CAUSE

Diskgroup FRA had been overallocated, the sum of db_recovery_file_dest_size of all the databases is more than the size of diskgroup FRA.

SQL> select NAME,TOTAL_MB,FREE_MB from v$asm_diskgroup
;

NAME                             TOTAL_MB    FREE_MB
------------------------------ ---------- ----------
...
..
.
FRA                               1024142       120

RESOLUTION

Decrease ‘db_recovery_file_dest_size” for some or all databases, and make sure the diskgroup FRA is not overallocated.

CRS-2878: Failed to restart resource ‘ora.net1.network’ CRS-2769: Unable to failover resource ‘ora.net1.network’

The following messages appear in alert.log:

...
..
.
2021-10-26 6:34:11.701 [CRSD(56455)]CRS-2878: Failed to restart resource 'ora.net1.network'
2021-10-26 6:34:11.705 [CRSD(56455)]CRS-2769: Unable to failover resource 'ora.net1.network'.
2021-10-26 6:34:11.807 [CRSD(56455)]CRS-2878: Failed to restart resource 'ora.net1.network'
2021-10-26 6:34:11.880 [CRSD(56455)]CRS-2769: Unable to failover resource 'ora.net1.network'.
...
..
.

In the mean time, there are other resources failure from scan listeners, VIPs and local listeners, etc.

Subscribe to get access

Read more of this content when you subscribe today.

Subscribe

ExaCC : Can We Change Oracle and Grid User Password?

In ExaCC environment, you should not change any default setting for default users.

So changing password of grid infrastructure user ( gird ) and Oracle RAC database user ( oracle) is not allowed in ExaCC environment.