集群数据库软件均已安装完毕,现在想从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