linux file system to ASM filesystem migration
885970Feb 12 2012 — edited Feb 14 2012Hi Pros,
I am on 11g R2 RAC with user grid and oracle with job role specifications,
and the RAC DB working file
id grid
uid=1100(grid) gid=1000(oinstall) groups=1000(oinstall),1200(asmadmin),1201(asmdba),1202(asmoper),1300(dba)
id oracle
uid=1101(oracle) gid=1000(oinstall) groups=1000(oinstall),1201(asmdba),1300(dba),1301(oper)
Now,
i have installed 11g R2 Non rac Oracle and need to migrate it to RAC database with oracle user in the same ORACLE_BASE location,
to convert my preset DB to RAC i need to migrate my normal file system to ASM,
so doing ASM migration of Non RAC datbase file system with RMAN,
geting an error
------------------------------------------------------------------------------------------------
RMAN> RESTORE CONTROLFILE FROM '/u01/app/oracle/oradata/TEST/control01.ctl';
Starting restore at 12-FEB-2012 20:40:42
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 02/12/2012 20:40:43
ORA-19504: failed to create file "+RACDB_DATA/ctftest.ctl"
ORA-15012: ASM file 'ctftest.ctl' does not exist
ORA-17502: ksfdcre:5 Failed to create file +RACDB_DATA/ctftest.ctl
ORA-15081: failed to submit an I/O operation to a disk
ORA-19600: input file is control file (/u01/app/oracle/oradata/TEST/control01.ctl)
ORA-19601: output file is control file (+RACDB_DATA/ctftest.ctl)
I hope this is related to ASM disk permissions because of role separation of grid and oracle user,
if so please help me to rectify this error.
Regards,
Vara