-
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 ?
svk
-
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 ?
svk
-
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...
svk
-
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....
svk
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
|