-
Hi anyone give us some idea....how to go about it...
Database version 7.3.4.5.. Os..SunOs Version 5.7..We checked by restoring even two months old datafiles from backup all reports corrupt...it is a production db.
SUMMARY:
========
-corruption was found during migration to 8.1.7
-Restore/recovery was performed and corruption still exists.
-Dbverify ran for all datafiles and 2 system and one temp datafile are corrupted.
-used veritas netbackup to do backups.
-restored to another machine.The database starts fine but dbverify reports and Export also gives errors
-There is no backup that does not have these errors - we have restored several.
-resized the system datafile and made it bigger. But when restored the backup, it is not using the resize database, we are using the database from the restore, therefore the resized system datafile do not come into play here.
-corruption was on a index system datafile (I_CCOL1), which cannot be dropped and rebuilt because in version 7.3.4. this is part of the bootstrap.
Plesae help.
Thanks.
Thanigaivasan.
-
just an update...
Export errors out.. and ...
User Table has a long raw column. Therefore, inserting into a table in another database using database link as well as sqlplus copy command doesnot work.
any other ideas, is worth a try at this point.
Please help.
Thanks.
Thanigaivasan.
-
Hello Gurus any update....
Please Help!!!!!!!!!!!!!!!!!!!!!!!!!!!
Thanks.
Thanigaivasan.
-
Please give us some clue....
Thanks.
-
First thing to do is get in touch with your Oracle Support.
They will probably say that 7.3.4 is not supported now, but talking to them will give you some good input.
Is the database functioning otherwise ?
Have you though @ running catproc/catlog again ?
Is export of a schema (other than SYSTEM,SYS) working ?
-
Also, how big is you database ?
Is it small enough so that you can restore it somewhere else other than where the prod db resides ?
-
First let me Thank you SVK.
Yes..We are in touch with oracle support...with seviority 1.
The database is huge..but we have restored in another server
and trying...all the options.
Oracle asked to not to shut down any cost...yes we did.it is up.
we tried one Dummy user to export his table we got no error..(Table has 3 rows only)...That we could not understand.
All the time database started up nicely without error.
Thanks.
Thanigaivasan.
-
How big is your db ? How big is the SYSTEM tablespace ?
Can you post actual error messages you get while running dbverify and exp ?
And I'm a little confused if your answer was YES to running catproc/catalog...
-
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.
-
What are these EVT_ tables ? By any chance are they application tables ? May be I don't know some part of Oracle that owns these tables....
-
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?
-
The system owned tables for OEM!!!
we tried catproc/catalog too...
no use.
Thanks.
Thanigaivasan.
-
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.
-
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.
-
Svk....
Installing what...OEM???.Which we donot want too..
....oracle asked to update with system datafile copy to them.
awiting finger crossed.
Thanks.
Thanigaivasan.
-
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.
-
Have you tried direct export ?
-
Svk,
Yes We did.Still error out???.
Thanks.
Thanigaivasan.
-
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.
