Re: Need some ideas to recover object - ORA-00600: internal error code, arguments: [ktspScanInit-d], [58759497], [], [], [], [], [], []
From: Jared Still <jkstill_at_gmail.com>
Date: Thu, 28 Feb 2013 12:46:26 -0800
Message-ID: <CAORjz=O_OM+Vp2kt1ufwnHiDVZV+nFLoc7z5Z33jSRDDmi0HNQ_at_mail.gmail.com>
On Tue, Feb 26, 2013 at 7:40 AM, <Christopher.Taylor2_at_parallon.net> wrote:
> Env: 10.2.0.4 64bit 3 node RAC on RH Linux 5.6
> I know I can restore the production database to a copy on another server
> but other than that what are my options here? Can I recover just the
> tablespace or will that regenerate the same problem once the tablespace is
> recovered?
>
Date: Thu, 28 Feb 2013 12:46:26 -0800
Message-ID: <CAORjz=O_OM+Vp2kt1ufwnHiDVZV+nFLoc7z5Z33jSRDDmi0HNQ_at_mail.gmail.com>
On Tue, Feb 26, 2013 at 7:40 AM, <Christopher.Taylor2_at_parallon.net> wrote:
> Env: 10.2.0.4 64bit 3 node RAC on RH Linux 5.6
> I know I can restore the production database to a copy on another server
> but other than that what are my options here? Can I recover just the
> tablespace or will that regenerate the same problem once the tablespace is
> recovered?
>
Is the table per chance enabled for flashback?
Probably too late for that by now.
Restoring just the necessary tablespace to a new database may be the solution.
Have you resolved this by now? If so, what did you do?
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Oracle Blog: http://jkstill.blogspot.com
Home Page: http://jaredstill.com
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Feb 28 2013 - 21:46:26 CET