nbu还原集群数据库异常问题

集群数据库软件均已安装完毕,现在想从NBU上还原数据库,但在还原控制文件报错

[oracle@oracle-db1 ~]$ rman target /

Recovery Manager: Release 11.2.0.3.0 - Production on Tue Mar 13 22:25:50 2018

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: MIDDB (not mounted)

RMAN> run{
 allocate channel ch00 type 'SBT_TAPE';
 send 'nb_ora_serv=nbumaster01';
 send 'nb_ora_client=oracleb';
 restore controlfile from 'cntrl_3215_1_970681472';
 release channel ch00;
}2> 3> 4> 5> 6> 7>

using target database control file instead of recovery catalog
allocated channel: ch00
channel ch00: SID=265 instance=middb1 device type=SBT_TAPE
channel ch00: Veritas NetBackup for Oracle - Release 8.0 (2016110921)

sent command to channel: ch00

sent command to channel: ch00

Starting restore at 13-MAR-18

channel ch00: restoring control file
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 03/13/2018 22:26:46
RMAN-10038: database session for channel ch00 terminated unexpectedly

起初在网上查了很多,都没有给出明确的方向,但是将参数文件的路劲由asm改为本地的话就可以了,这时问题应该出现在存储上

查看alert日志显示

Dwn-cvts replayed, VALBLKs dubious
 All grantable enqueues granted
 Post SMON to start 1st pass IR
 Submitted all GCS remote-cache requests
 Post SMON to start 1st pass IR
 Fix write in gcs resources
Reconfiguration complete
Tue Mar 13 23:08:27 2018
LCK0 started with pid=42, OS id=53384
Starting background process RSMN
Tue Mar 13 23:08:28 2018
RSMN started with pid=43, OS id=53386
ORACLE_BASE from environment = /home/u01/app/oracle
Tue Mar 13 23:08:28 2018
alter database mount
This instance was first to mount
NOTE: Loaded library: System
ORA-15025: could not open disk "/dev/mapper/DATA1"
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 9
ORA-15025: could not open disk "/dev/mapper/DATA3"
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 9
SUCCESS: diskgroup DATA was mounted
ORA-15025: could not open disk "/dev/mapper/DATA2"
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 9
ORA-15025: could not open disk "/dev/mapper/DATA4"
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 9
SUCCESS: diskgroup FRA was mounted
ORA-00210: cannot open the specified control file
ORA-00202: control file: '+FRA/middb/controlfile/current.260.970678321'
ORA-17503: ksfdopn:2 Failed to open file +FRA/middb/controlfile/current.260.970678321
ORA-15012: ASM file '+FRA/middb/controlfile/current.260.970678321' does not exist
ORA-00210: cannot open the specified control file
ORA-00202: control file: '+DATA/middb/controlfile/cu

后台日志一大堆报错,这时很明显是权限问题了。

上网搜寻一下总结的原因如下:

Cause:

经研究发现,这跟$ORACLE_HOME/bin/oracle这个文件的属性有关系:

在安装oracle soft之后:

$ORACLE_HOME/bin/oracle文件属性权限为oracle:oninstall 751(-rwxr-x--x)

在用安装ASM建库(DBCA)时:

此文件属性会自动被修改为oracle:asmadmin 6751(-rwsr-s--x)

--在PSU apply之后:

--此文件属性又被自动被修改为oracle:oinstall751(-rwxr-x--x)

 

Solution:

chown oracle:asmadmin $ORACLE_HOME/bin/oracle

chmod 6751 $ORACLE_HOME/bin/oracle

原文地址:https://www.cnblogs.com/guipeng/p/8564192.html