Thursday, September 20, 2012

ORA-01503, ORA-01200 and ORA-01110

I was deleting some old E-mails and found this from 2008 so it probably came from an Oracle 9 database. I changed the filename before displaying it below:

ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01200: actual file size of 172304 is smaller than correct size of 384000 blocks
ORA-01110: data file 38: '/database/andrew/undo_04.dbf'

This can happen if you are cloning a database and the disk holding the target database’s datafiles fills up. One or more of those datafiles will then be smaller than they should be. If you fail to spot this and go on to try to recreate the control file, Oracle WILL notice and display the errors you can see above. You cannot do anything about this, you just need to make the target file system bigger and copy the corrupted files again.

No comments:

Post a Comment