ORA-15025 build DG Environment, restore Controlfile error, indicating that Oracle cannot use ASM storage

Environment Description:

#主库RAC环境

#备库RAC环境, operating system AIX 6.1 database version 11.2.0.3

Error Description:

#主库备份控制文件, transfer to Repository, restore error

This document is divided into two stages: First stage: Error occurred, query related log

Second Stage: Handle the error, try to solve the problem

First Stage: Error occurred, query log stage:

#如下操作:

rman> restore standby controlfile from '/tmp/con.ctl ';

Starting restore at 03-jul-18
Using target database control file instead of recovery catalog
Allocated Channel:ora_disk_1
Channel ora_disk_1:sid=1 instance=rac11g770a 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 07/03/2018 19:36:27
Rman-10038:database session for channel Ora_disk_1 terminated unexpectedly

#查询Alert日志:
Note:mark has subscribed
Ora-15025:could not open Disk "/dev/rhdisk6"
Ora-27041:unable to open File
IBM AIX RISC system/6000 Error:13:permission denied

Second phase, solve the problem:

#报错解决过程, went through three stages: Abc,ab are wrong, if you need to solve the problem quickly, directly to see the last phase of C, modify the group finished

A: Modification process belongs to the main genus Group

Chown oracle.asmadmin $ORACLE _home/bin/oracle

#查询如下: Discover that the Oracle process is oralce. Oinstall Group, query the ASM disk at the operating system level of the OCR disk group
-bash-4.2# Cd/picclife/app/oracle/product/11.2.0/dbhome_1/bin
-bash-4.2# Ls-l Oracle
-rwsr-s--x 1 Oracle oinstall 300820923 Jul 15:42 Oracle

#ASM磁盘操作系统: Group is asmadmin, Oracle does not have this group, Oracle user does not have permission to use ASM disk
-bash-4.2# ls-l/dev/rhdisk2
CRW-RW----1 grid asmadmin, 3 Jul 19:26/dev/rhdisk2

#直接修改Oracle进程, belonging to group Asmadmin
-bash-4.2# chown Oracle:asmadmin Oracle
-bash-4.2# Ls-l Oracle
-rwsr-s--x 1 Oracle asmadmin 300820923 Jul 15:42 Oracle

#使用SQLPLUS Error---Prompt group ID is incorrect
Ora-27140:attach to post/wait facility failed
Ora-27300:os system dependent Operation:invalid_egid failed with status:1
Ora-27301:os Failure Message:not Owner
Ora-27302:failure occurred at:skgpwinit6
ora-27303:additional Information:startup egid = 501 (oinstall), Current Egid = 503 (asmadmin)

#修改Oracle进程权限, restore operations
-bash-4.2# chmod 6755 Oracle
-bash-4.2# Ls-l Oracle
-rwsr-sr-x 1 Oracle asmadmin 300820923 Jul 15:42 Oracle

-bash-4.2# Ls-l Oracle
-rwsrwsr-x 1 Oracle asmadmin 300820923 Jul 15:42 Oracle
-bash-4.2# chown Oracle.oinstall Oracle
#修改进程的属主属组, it is not safe to add the genus Group directly to the Oracle User:

B: Adding asmadmin groups to Oracle users

Chgroup users=oracle Asmadmin

-After this command has been modified, a big pit appears

-bash-4.2# Chgroup users=oracle Asmadmin
-bash-4.2# ID Oracle
uid=501 (Oracle) gid=501 (oinstall) groups=503 (asmadmin), 502 (DBA), 504 (ASMDBA)

#重启库, the use of restore can be found to solve the Oracle user, can use the purpose of ASM storage

rman> restore standby controlfile from '/tmp/con.ctl ';

rac11g770a:/picclife/app/grid$ ID Oracle
uid=501 (Oracle) gid=501 (oinstall) groups=503 (asmadmin), 502 (DBA), 504 (ASMDBA)
rac11g770a:/picclife/app/grid$ ID Grid
uid=502 (GRID) gid=501 (Oinstall) groups=502 (DBA), 504 (ASMDBA), 505 (Asmoper)

#重启库后, found that the cluster status is not very

Grid:asmcmd--Connection found Asmcmd not available, Sqlplus/as sysasm--No permissions!!!!!!!!!!

[Email protected] ~]$. Oraenv

Oracle_sid = [+ASM1]?

The Oracle base remains unchanged with value/u01/app/oracle

[[email protected" ~]$ asmcmd
Connected to an Idle instance.
asmcmd> ls
asmcmd-8102:no connection to ASM, command requires ASM to run

#查询集群状态:
-bash-4.2# while true; Do/picclife/app/11.2.0/grid/bin/crsctl stat res-t-init; Sleep 1; Done

Ora.asm
1 ONLINE OFFLINE
Ora.cluster_interconnect.haip
1 Online Online rac11g770a
Ora.crf
1 Online Online rac11g770a
Ora.crsd
1 ONLINE OFFLINE
Ora.cssd
1 Online Online rac11g770a
Ora.cssdmonitor
1 Online Online rac11g770a
Ora.ctssd
1 Online Online rac11g770a OBSERVER
Ora.diskmon
1 OFFLINE OFFLINE
Ora.drivers.acfs
1 Online Online rac11g770a
Ora.evmd
1 ONLINE Intermediate rac11g770a---Very abnormal, ASM CRSD service is not started!!!!

#对集群进行启动, stop, try, query the cluster of various logs, are to get the obvious ora error

C: Modify the user group: Use the command usermod

# # #中午睡了一觉, after the status OK, query users, found a surprising feature: almost thought dazzled!!!

Grid: Operating system user, genus group Asmadmin group disappeared!!!!!!!

-bash-4.2# ID Grid
uid=502 (GRID) gid=501 (Oinstall) groups=502 (DBA), 504 (ASMDBA), 505 (Asmoper)

-bash-4.2# ID Oracle
uid=501 (Oracle) gid=501 (oinstall) groups=502 (DBA), 503 (Asmadmin), 504 (ASMDBA)

#对Grid用户的属组进行添加

-bash-4.2# usermod-g asmadmin Grid--For this command-G requires all groups to be added
-bash-4.2# ID Grid
uid=502 (GRID) gid=501 (Oinstall) groups=503 (asmadmin)
-bash-4.2# ID Oracle
uid=501 (Oracle) gid=501 (oinstall) groups=502 (DBA), 504 (ASMDBA)

-bash-4.2# usermod-g dba,asmdba,asmoper,asmadmin Grid
-bash-4.2# usermod-g Dba,asmdba,asmoper,asmadmin Oracle

#对集群进行重启:
rac11g770a:/picclife/app/11.2.0/grid/bin$./crsctl Stop Has-f
#rac11g770a:/picclife/app/11.2.0/grid/bin$./crsctl Stop Crs-f
rac11g770a:/picclife/app/11.2.0/grid/bin$ Crsctl Start has
rac11g770a:/picclife/app/11.2.0/grid/bin$ Crsctl Start CRS
rac11g770a:/picclife/app/11.2.0/grid/bin$ CRSCTL Check CRS
Crs-4638:oracle High Availability Services is online
Crs-4537:cluster Ready Services are online
Crs-4529:cluster Synchronization Services is online
Crs-4533:event Manager is online

#查询用户
-bash-4.2# ID Oracle
uid=501 (Oracle) gid=501 (oinstall) groups=503 (asmadmin), 502 (DBA), 504 (ASMDBA), 505 (Asmoper)
-bash-4.2# ID Grid
uid=502 (GRID) gid=501 (Oinstall) groups=503 (asmadmin), 502 (DBA), 504 (ASMDBA), 505 (Asmoper)

Ok!!!!!

ORA-15025 build DG Environment, restore Controlfile error, indicating that Oracle cannot use ASM storage