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

This error seems to be linked with creating control files and not performing a media recovery...

Metalink suggests:

1. Recreate the controlfile again
2. Perform media recovery RECOVER DATABASE (if create controlfile was NORESETLOGS) or RECOVER DATABASE USING BACKUP CONTROLFILE (if using RESETLOGS)

      If using the BACKUP CONTROLFILE option you may need to supply the
      names of the ONLINE logs to complete the recovery.

3. Open the database
           ALTER DATABASE OPEN;
        or ALTER DATABASE OPEN RESETLOGS

If there are still problems contact Oracle Support Services.

Andy

"Axel Klos" <axk_at_fernbach.com> wrote in message news:3Wnq7.29$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
>
>
Received on Fri Sep 21 2001 - 03:27:05 CDT