Re: SOS - ORA 600 and no backup :-(((

"Axel Klos" <axk_at_fernbach.com> wrote in message news:4Wnq7.30$5k5.1419_at_nreader2.kpnqwest.net...
> Hi,
>
> i migrate an 7.3.4 database to 8.1.7.
> Following steps are:
>
> - mig check_only=true
> - mig
> - switch to new 8.1.7 environment
> - delete old controlfiles
> - startup nomunt and alter database convert
> - alter database open resetlogs ---> crashes (false entry for rollback
> segments)
>
> I open and Oracle Call and they said: try to create new controlfiles:
>
> - startup mount
> - alter database backup controlfile to trace
> - shutdown and delete the controlfiles
> - customize the trace file (delete the line with recover clause)
> - the new controlfiles was created and when the skript
> make open database open resetlogs i receive:
>
> ORA-00600: internal error code, arguments: [3668], [1], [2], [3], [3],
> [2052], [
> ], []
> ORA-600 signalled during: alter database open ...
>
> The problem is thats the backup is not ok :-((((
> Can anyone an undocumented parameter for this or an another way for solve
> this problem?
>
> You can also phone me because its an Production problem for me and my
> company
>
> I hope for fast anwers and that can anyone help me..
>
> Axel Klos
> Fernbach Software SA
> Luxembourg: +352 40 2244 501
>
>
>

Do you want the bad news or the bad news?

Your only hope is your boss has enough money to have Oracle Support bring in Oracle DUL (Data Unloader) to rescue your database.

Ora-600 means "Call support"
600's are internal untrapped errors which normally shouldn't surface. Now there is of course also the vexing question who decided not to check those backups, and to overwrite those controlfiles instead of copying them to a safe location before putting them on the electric chair. Sorry to say this, but you should always prepare for dr. Murphy. He doesn't sleep and once he strikes.

I also don't think you can migrate a database directly from 7.3.4 to 8.1.7 in the first place, you need to use export/import.

Regards,

Sybrand Bakker, Senior Oracle DBA Received on Thu Sep 20 2001 - 13:56:25 CDT