diskgroup is incomplete OR Database Will Not Mount: ORA-15025, ORA-27041, ‘Permission denied’, ORA-15081

RMAN> RESTORE CONTROLFILE FROM ‘/home/oracle/restore/3jrjomjq_1_1.ctl’;

Starting restore at 31-OCT-16
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=7 device type=DISK

channel ORA_DISK_1: restoring control file
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 10/31/2016 17:56:31
ORA-19870: error while restoring backup piece /home/oracle/restore/3jrjomjq_1_1.ctl
ORA-19504: failed to create file “+DATAC1”
ORA-17502: ksfdcre:4 Failed to create file +DATAC1
ORA-15001: diskgroup “DATAC1” does not exist or is not mounted
ORA-15040: diskgroup is incomplete

********alert_db1.log***********************

ALTER DATABASE MOUNT
NOTE: Loaded library: System
ORA-15025: could not open disk ‘/dev/oracleasm/disks/DATA01’
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 9
SUCCESS: diskgroup DATA was mounted
NOTE: dependency between database ORCL and diskgroup resource ora.DATA.dg is established
ORA-15025: could not open disk ‘/dev/oracleasm/disks/FLASH01’
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 9
SUCCESS: diskgroup FLASH was mounted
ORA-00204: error in reading (block 1, # blocks 1) of control file
ORA-00202: control file: ‘+FLASH/orcl/controlfile/current.256.711293457’
ORA-15081: failed to submit an I/O operation to a disk
ORA-00204: error in reading (block 1, # blocks 1) of control file
ORA-00202: control file: ‘+DATA/orcl/controlfile/current.256.711293457’
ORA-15081: failed to submit an I/O operation to a disk
NOTE: dependency between database ORCL and diskgroup resource ora.FLASH.dg is established.
Checker run found 2 new persistent data failures
ORA-205 signalled during: ALTER DATABASE MOUNT…
SUCCESS: diskgroup DATA was dismounted
SUCCESS: diskgroup FLASH was dismounted

********SOLUTION****************************************************

APPLIES TO:Oracle Database – Enterprise Edition – Version 11.2.0.1 and later

To correct the proper group for the Database oracle executable, do:
As the <asm_home sfw owner>:
$ cd <asm_home>/bin
$ ./setasmgidwrap o=<db_home>/bin/oracle

Now check that the primary group for the Database oracle executable is now asmadmin (not oinstall).

If done, restart the database.

Example:
[grid@exarestore bin]$ cd /u01/app/12.1.0.2/grid/bin
[grid@exarestore bin]$ pwd
/u01/app/12.1.0.2/grid/bin
[grid@exarestore bin]$ ./setasmgidwrap o=/u01/app/oracle/product/12.1.0.2/dbhome_1/bin/oracle
grid@exarestore bin]$ ls -lrt /u01/app/oracle/product/12.1.0.2/dbhome_1/bin/oracle
-rwsr-s–x. 1 oracle asmadmin 323762222 Oct 27 16:06 /u01/app/oracle/product/12.1.0.2/dbhome_1/bin/oracle
Now check that the primary group for the Database oracle executable is now asmadmin (not oinstall).

If done, restart the database.

 

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s