RMAN Duplicate to ASM Failing With ORA-19870 ORA-19504 ORA-15012 ORA-17502 OR...

刘泽宇

当RMAN恢复到ASM时报ORA-19870、ORA-19504、ORA-15012、ORA-17502等错误

RMAN duplicate to ASM is failing with these errors:

  channel D1: reading from backup piece /mnt/ora_ab12345678_a12_a1
  ORA-19870: error reading backup piece /mnt/ora_ab12345678_a12_a1
  ORA-19504: failed to create file "+DISK1/mydatafile01.dbf"
  ORA-15012: ASM file 'mydatafile01.dbf' does not exist
  ORA-17502: ksfdcre:5 Failed to create file +DISK1/mydatafile01.dbf
  ORA-15080: synchronous I/O operation to a disk failed

And you might see these errors too:

  RMAN-00571: ================================================
  RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===
  RMAN-00571: ================================================
  RMAN-03002: failure of Duplicate Db command at 02/22/2007 10:01:36
  RMAN-03015: error occurred in stored script Memory Script
  RMAN-06026: some targets not found - aborting restore
  RMAN-06023: no backup or copy of datafile 411 found to restore

The alert log shows these errors:

  Errors in file /mydb/udump/mydb/trace_864352.trc:
  ORA-27091: unable to queue I/O
  ORA-27041: unable to open file
  IBM AIX RISC System/6000 Error: 13: Permission denied
  Additional information: 3

原因是操作系统中存在权限问题

Incorrect operating system permissions.  
The operating system owner of the $ORACLE_HOME for the TARGET database is different
from the operating system owner of the $ORACLE_HOME for ASM instance.
.
The file permissions show 744 for the ASM disks.
Both the owner of the $ORACLE_HOME for ASM instance and the one for the TARGET instance
have a group of DBA, but file permissions of 744 only allow for "read" access to the DBA group.

Cause justified by trace file showing errors:

ORA-27091: unable to queue I/O
ORA-27041: unable to open file
SVR4 Error: 13: Permission denied
Additional information: 3

解决方法：

For the ASM disks seen at the operating system prompt, change the permissions for the group (usually DBA)
to allow at least read and write by the group.

Set the owner:group for the 'TARGET' database home to the same as the 'ASM' home.