Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

linux file system to ASM filesystem migration

885970Feb 12 2012 — edited Feb 14 2012
Hi 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 13 2012
Added on Feb 12 2012
10 comments
665 views