|
-
I am sorry...the yes is for the contact with oracle support.
We did not try catproc/catalog...
and sizes...
SQL> select sum(bytes/1024/1024) from dba_data_files where tablespace_name like 'SYSTEM';
SUM(BYTES/1024/1024)
--------------------
270
SQL> select sum(bytes/1024/1024) from dba_data_files;
SUM(BYTES/1024/1024)
--------------------
106241
errors...
DBVERIFY
DBVERIFY: Release 7.3.4.5.0 - Production on Thu Jun 13 10:48:25 2002
Copyright (c) Oracle Corporation 1979, 1996. All rights reserved.
DBVERIFY - Verification starting : FILE = /db/data/adbd/adbd_system2.dbf
kdbchk: row locked by non-existent transaction
table=0 slot=0
lockid=195 ktbbhitc=1
Page 203 failed with check code 1
kdbchk: row locked by non-existent transaction
THis datafile is also totally corrupt.
EXPORT LOG EXCERPT
======================
$exp system file=adbd_system_0613.dmp log=adbd_system_0613.log full=n owner=system direct=n
Connected to: Oracle7 Server Release 7.3.4.5.0 - Production
With the distributed and replication options
PL/SQL Release 2.3.4.5.0 - Production
Export done in US7ASCII character set
About to export specified users ...
About to export SYSTEM's objects ...
. exporting snapshots
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export SYSTEM's tables via Conventional Path ...
. . exporting table DEF$_CALL 0 rows exported
. . exporting table DEF$_CALLDEST 0 rows exported
. . exporting table DEF$_DEFAULTDEST 0 rows exported
. . exporting table DEF$_DESTINATION 0 rows exported
. . exporting table DEF$_ERROR 0 rows exported
. . exporting table DESI4 199 rows exported
. . exporting table EVT_CARRIER_CONFIGURATION 0 rows exported
EXP-00008: ORACLE error 1578 encountered
ORA-01578: ORACLE data block corrupted (file # 1, block # 8200)
ORA-01110: data file 1: '/db/data/adbd/adbd_system.dbf'
. . exporting table EVT_DEST_PROFILE 0 rows exported
. . exporting table EVT_HISTORY 0 rows exported
. . exporting table EVT_INSTANCE 0 rows exported
. . exporting table EVT_MAIL_CONFIGURATION 0 rows exported
. . exporting table EVT_MONITOR_NODE 0 rows exported
EXP-00008: ORACLE error 1578 encountered
ORA-01578: ORACLE data block corrupted (file # 1, block # 8200)
ORA-01110: data file 1: '/db/data/adbd/adbd_system.dbf'
. . exporting table EVT_NOTIFY_STATUS
Thanks.
Thanigaivasan.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|