Re: Oracle XE Corruption

The ''smon_scn_time_tim_idx' index is found in the "smon_scn_time" table.

Since it appears I will be required to rebuild the index offline, does
anybody have any idea how long this might take? I guess it depends on how
large the table/index is, it would be helpful to be able to give end users
some sort of an expectation before shutting down the database if at all
possible.

I appreciate everybody's willingness to help, this is a great forum.

-Evan

On Tue, Aug 24, 2010 at 1:47 PM, Bobak, Mark <Mark.Bobak@xxxxxxxxxxxx>wrote:

>  I’m not sure the new tablespace would be required either, but I’m pretty
> sure ‘online’ option is out of the question, as that’s an Enterprise Edition
> only option, if I’m not mistaken.
>
>
>
> -Mark
>
>
>
> *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Uzzell, Stephan
> *Sent:* Tuesday, August 24, 2010 1:44 PM
> *To:* 'andrew.kerber@xxxxxxxxx'; jepettrey@xxxxxxxxx
>
> *Cc:* Oracle-L@xxxxxxxxxxxxx
> *Subject:* RE: Oracle XE Corruption
>
>
>
> Wouldn’t just a simple rebuild online suffice? Why move it to a new
> tablespace if it is an object owned by SYS?
>
>
>
> *
> _____________________________________________________________________________
> *
>
> *Stephan Uzzell |** **MICROS Systems, Inc.** *
>
>
>
> Database Administrator - OPERA Global Technical Services
>
> 7031 Columbia Gateway Dr,  Columbia, MD  21046 | ( 443.285.8000x2760 | 
> 7443.285.6505
>
>
>
> *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Andrew Kerber
> *Sent:* Tuesday, 24 August, 2010 13:38
> *To:* jepettrey@xxxxxxxxx
> *Cc:* Oracle-L@xxxxxxxxxxxxx
> *Subject:* Re: Oracle XE Corruption
>
>
>
> Create a new tablespace (datafile), and try this command:
>
> alter index SMON_SCN_TIME_TIM_IDX rebuild tablespace new_tablespace;
>
> On Tue, Aug 24, 2010 at 12:31 PM, Evan Pettrey <jepettrey@xxxxxxxxx>
> wrote:
>
> Hello all,
>
>
>
> I’ve just taken a job as a sys admin with a company who uses an Oracle XE
> database on one of their production machines and it is exceptionally
> important for me to limit downtime.
>
>
>
> Immediately upon taking the position I setup backups and an alerting
> system. Well yesterday I started getting an alert that their Oracle DB
> server was running out of space. After further investigation I learned that
> one of their bdump trace files was growing at a rate of nearly 1GB a day. At
> this rate, the hard drive will run out of space sometime in the next few
> days.
>
>
>
> As such, I began poking around to see why this trace log was growing so
> fast and so large. By looking through the log I was able to determine that
> the error was with Object ID 576 and has existed since at least January
> (I’ve only been here a few weeks).
>
>
>
> I checked to see what object 576 was and determined that it is:
>
>
>
> SQL> select object_name, object_type from dba_objects where object_id =
> 576;
>
> OBJECT_NAME
>  ------------------------------
>
> OBJECT_TYPE
>  ------------------------------
>
> SMON_SCN_TIME_TIM_IDX
> INDEX
>
>
>
>
>
> Since the corruption has been around since at least January, restoring the
> database from a backup really isn’t option...this object index needs to be
> rebuilt.
>
>
>
> I know I can rebuild the object by running:
>
>
>
> alter index smon_scn_time_tim_idx rebuild;
>
>
>
> However I’m not sure that this will actually resolve the issue fully and I
> can’t afford to create other problems in the process, leading to the
> database not being functional after working on it. The database apparently
> takes around 30 minutes to bring back up after it has been shutdown so I
> don’t want to have to do this more than once.
>
>
>
> I’m not a DBA and am a little lost at this point in time. A previous
> co-worker of mine suggested this would be a good place to see help since
> Oracle XE isn’t supported by Oracle and I don’t have a metalink account. If
> anybody could help me out I would greatly appreciate it.
>
>
>
>
>
> Thanks in advance.
>
>
>
>
>
> Regards,
>
> Evan
>
>
>
>
> --
> Andrew W. Kerber
>
> 'If at first you dont succeed, dont take up skydiving.'
>

Other related posts: