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