Help : Database verification error

From: Tom Lewis <telewis_at_my-dejanews.com>
Date: Tue, 18 May 1999 17:48:13 GMT
Message-ID: <7hs94s$i0d$1@nnrp1.deja.com>

While installing tables for the Oracle Data Mart Suite onto an Oracle 8.0.5 development server, I noticed that the system tablespace had grown very large (4GB). As the original tablespace size was 200Mb, I removed the new tables, set the default tablespace object size to 512Kb and reinstalled - no obvious problems and the tablespace was back down to c100Mb.

Later in the day, developers reported that other tables in their schemas "disappeared" and Oracle returned an "object no longer exists" error. Users were asked to log off and the database was shutdown
(immediate) and restarted. The following error was received:

Oracle Server Manager Release 3.0.5.0.0 - Production

Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production PL/SQL Release 8.0.5.0.0 - Production

SVRMGR> connect internal_at_londw01
Password:
Connected.
SVRMGR> startup
ORACLE instance started.

Total System Global Area                        109518848 bytes
Fixed Size                                          49152 bytes
Variable Size                                    27377664 bytes
Database Buffers                                 81920000 bytes
Redo Buffers                                       172032 bytes

Database mounted.

ORA-01122: database file 1 failed verification check
ORA-01110: data file 1: 'D:\ORADATA\LONDW01\SYS1DW01_01.ORA'
ORA-01200: actual file size of 918216 is smaller than correct size of

1043205 blocks
SVRMGR> The datafile refered to is in the system tablespace. The database is in noarchivelog mode. I have an operating system backup, but it is 2 weeks old (oops).

Any ideas?

--
Tom Lewis

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Tue May 18 1999 - 12:48:13 CDT