RE: Oracle XE Corruption
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxx>
- To: "SUzzell@xxxxxxxxxx" <SUzzell@xxxxxxxxxx>, "'andrew.kerber@xxxxxxxxx'" <andrew.kerber@xxxxxxxxx>, "jepettrey@xxxxxxxxx" <jepettrey@xxxxxxxxx>
- Date: Tue, 24 Aug 2010 13:47:43 -0400
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 | 7
443.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<mailto: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:
