Monday, September 7, 2009

ORA-01031: RMAN Duplicate Fails for ASM file system


ORA-01031: RMAN Duplicate Fails for ASM file system


Example


channel ORA_AUX_DISK_1: reading from backup piece K:\BACKUP\DAILY\27KN1ASE_1_1
ORA-19870: error reading backup piece K:\BACKUP\DAILY\27KN1ASE_1_1
ORA-19504: failed to create file "+DATA/ora_index/lineind_7.dbf"
ORA-17502: ksfdcre:3 Failed to create file +DATA/ora_index/lineind_7.dbf
ORA-15001: diskgroup "DATA" does not exist or is not mounted
ORA-15055: Message 15055 not found; No message file for product=RDBMS, facility=
ORA-01031: insufficient privilege


Detail



 


RMAN> DUPLICATE TARGET DATABASE FOR STANDBY NOFILENAMECHECK;


RMAN duplicate fails with ORA-01031 on 10G Windows Platform with ASM



Solution

sqlnet.ora parameter

SQLNET.AUTHENTICATION_SERVICES = (NTS)  needs to be unset


Also check that OS user you are logged in as is a member of the ora_dba group:


    net localgroup ora_dba oracle /add


No comments: