URGENT system datafile corrupt...

[BV1963]

I would try to export schemas that have an application data and then create another database and import data in. Did you try export applicational schemas?

[thanigai]

The system owned tables for OEM!!!
we tried catproc/catalog too...
no use.
Thanks.
Thanigaivasan.

[svk]

Okay, that means you will not loose any application data...

And I'm sure, your application also must be working fine. Isn't it ?

OEM means these must be management server tables. Can you afford to loose it ? If yes, try installing it again.

This time select a different user and tablespace.

[thanigai]

We tried the application schemas export...giving same error.
The dummy schema we exported has only 3 rows and it went well...but the application schemas..no.
What oracle is telling it uses the corrupted index for the export owned by sys which cannot be dropped or rebuild.
funny thing is it did not throw any error in alert log for all these months and it started up all time fine.

Thanks.
Thanigaivasan.

[thanigai]

Svk....
Installing what...OEM???.Which we donot want too..
....oracle asked to update with system datafile copy to them.
awiting finger crossed.
Thanks.
Thanigaivasan.

[thanigai]

I tried as system to export ....user objects...
result...
About to export USER'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 USER's tables via Conventional Path ...
. . exporting table USER_TABLE
EXP-00008: ORACLE error 4045 encountered
ORA-04045: errors during recompilation/revalidation of SYS.DBMS_SQL
ORA-01578: ORACLE data block corrupted (file # 1, block # 1286)
ORA-01110: data file 1: '/db/data/adbd/adbd_system.dbf'
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 16
ORA-06512: at line 1
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting referential integrity constraints
. exporting triggers
. exporting posttables actions
Export terminated successfully with warnings.

I tried to export as user

$exp
Export: Release 7.3.4.5.0 - Production on Fri Jun 14 14:37:19 2002
Copyright (c) Oracle Corporation 1979, 1996. All rights reserved.
Username: USER
Password:

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 USER'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 E2R2's tables via Conventional Path ...
. . exporting table USER_TABLE
EXP-00008: ORACLE error 4045 encountered
ORA-04045: errors during recompilation/revalidation of SYS.DBMS_SQL
ORA-01578: ORACLE data block corrupted (file # 1, block # 1286)
ORA-01110: data file 1: '/db/data/adbd/adbd_system.dbf'
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 16
ORA-06512: at line 1
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting referential integrity constraints
. exporting triggers
. exporting posttables actions
Export terminated successfully with warnings.

What to do????>
Thanks.
Thanigaivasan.

[svk]

Have you tried direct export ?

[thanigai]

Svk,
Yes We did.Still error out???.
Thanks.
Thanigaivasan.

[thanigai]

Just an update...
individual user export...works luckily....!!!!!!!!!!!!!!!okay so far..
One main user (80gig)size is exporting.....so far no errors!!!! .
So planning to copy into multiple tapes ...create the new db and import it.I will keep updating any thing go wrong.
Thanks.
Thanigaivasan.