DBUA failure - now what?
885842Feb 28 2013 — edited Mar 13 2013Hi, i am in real need of some help....
My first upgrade using DBUA has been some what of a disaster (luckily its just a test db)
I am going from 10.2.0.5 to 11.2.0.3 using aix.
My DBUA upgrade failed due to the following reason : log_archive_dest_1 cannot be parsed. This has now been corrected but what now?
I cant start in 11.2 as i get the following error:
ORA-00204: error in reading (block 419, # blocks 1) of control file
ORA-00202: control file: '/u02/oradata/TST1A/TST1A/control01.ctl'
ORA-27069: attempt to do I/O beyond the range of the file
Additional information: 419
Additional information: 1
Additional information: 335
I can still run my database in 10.2 but what do i do now for upgrading it? I cant use DBUA again as it says 'all the components have already been upgraded' (and from the documentation it shouldnt be run again anyway).
So how can i tell how far the upgrade has gone and where do i continue from?
On a more general note from experienced DBA's what is the feeling regarding DBUA? Its caused me no end of problems even though Oracle recommend it. Is it really the best option?
Kind regards