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:

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: '/cisdpt/nbadpt1/nba_tables2/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.



You can read more about this in the book advertised above. I have attached an excerpt from it below, which is on the same subject. As usual, click on the image to enlarge it and bring it into focus:


No comments: