Re: ORA-600

Hi,

ORA-600 is not necessarily a corruption problem. In your case, it's a pga problem. Of course, you have to contact the Oracle support.

The second point, just apply you backup method.

Dias

"Olaf Musch" <Olaf.Musch_at_computer.org> wrote in message news:<c66096$8dui0$1_at_ID-168133.news.uni-berlin.de>...
> Hi all,
>
> on one of our databases (9.2.0.4, W2K server, english)
> we've just received an
>
> ORA-00600 internal error [733] [pga heap]
>
> error.
>
> Besides of calling Oracle support (which we'll
> do in a few minutes I think) and checking
> hardware (which is currently running),
> has anyone any further suggestions on possible
> reasons and methods to get it up running again?
>
> Our current ideas:
> - As the machine boots up fine, we'll back up all
> datafiles, archive logs, trace files, control files
> and scripts.
> Maybe during copy, one of these files shows up to
> be corrupt
>
> - Depending on what the support says, we'll try to
> save at least the main tablespace of the db
> Any suggestions on how to achieve this?
>
> Best regards
>
> Olaf
Received on Wed Apr 21 2004 - 15:25:31 CDT