YZlat
asked on
Control file 'file1' version 'xxx' is inconsistent with file 'file2' version 'xxy' error
I had 3 control files in my database in the same location:
/u01/oradata/DBName/contro l01.ctl, /u01/oradata/DBName/contro l02.ctl, and /u01/oradata/DBName/contro l03.ctl and since it is not a good practice, I have decided to move two of my control files to different locations.
So I modified PFILE CONTROL_FILES parameter to
CONTROL_FILES=('/u01/orada ta/DBName/ control01. ctl', '/u02/oradata/DBName/contr ol02.ctl', '/u03/oradata/DBName/contr ol03.ctl')
Then I copied the files:
cp /u01/oradata/DBName/contro l02.ctl /u02/oradata/DBName/contro l02.ctl
cp /u01/oradata/DBName/contro l03.ctl /u03/oradata/DBName/contro l03.ctl
Then I shutdown and started up my database and got an error:
ORA-00214: control file 'u01/oradata/DBName/contro l01.ctl' version 12659
inconsistent with file '/u02/oradata/DBName/contr ol02.ctl' version 12655
I tried correcting it by modifying my PFILE to reflect only control01.ctl then deleted cotrol02.ctl and control03.ctl and re-created them from a copy of control01.ctl file:
cp /u01/oradata/DBName/contro l01.ctl /u02/oradata/DBName/contro l02.ctl
cp /u01/oradata/DBName/contro l01.ctl /u03/oradata/DBName/contro l03.ctl
and attempted to startup database again but gotten same error.
Can someone tell me why this is happening and how can I fix it?
P.S. Database is in NOARCHIVELOG mode and there is no autobackup of the control file
/u01/oradata/DBName/contro
So I modified PFILE CONTROL_FILES parameter to
CONTROL_FILES=('/u01/orada
Then I copied the files:
cp /u01/oradata/DBName/contro
cp /u01/oradata/DBName/contro
Then I shutdown and started up my database and got an error:
ORA-00214: control file 'u01/oradata/DBName/contro
inconsistent with file '/u02/oradata/DBName/contr
I tried correcting it by modifying my PFILE to reflect only control01.ctl then deleted cotrol02.ctl and control03.ctl and re-created them from a copy of control01.ctl file:
cp /u01/oradata/DBName/contro
cp /u01/oradata/DBName/contro
and attempted to startup database again but gotten same error.
Can someone tell me why this is happening and how can I fix it?
P.S. Database is in NOARCHIVELOG mode and there is no autobackup of the control file
ASKER
It seems to work now but I'd appreciate if you explained why it happened on the first place
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thank you!
Shut down first.
Shut down again, then copy the control files to their new location.