DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 19

Thread: URGENT system datafile corrupt...

Hybrid View

  1. #1
    Join Date
    Oct 2000
    Location
    Charlotte, USA
    Posts
    330

    Red face

    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.

  2. #2
    Join Date
    Oct 2000
    Location
    Charlotte, USA
    Posts
    330
    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.


  3. #3
    Join Date
    Oct 2000
    Location
    Charlotte, USA
    Posts
    330
    Hello Gurus any update....
    Please Help!!!!!!!!!!!!!!!!!!!!!!!!!!!
    Thanks.
    Thanigaivasan.

  4. #4
    Join Date
    Oct 2000
    Location
    Charlotte, USA
    Posts
    330
    Please give us some clue....
    Thanks.

  5. #5
    Join Date
    Jul 2000
    Posts
    521
    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

  6. #6
    Join Date
    Jul 2000
    Posts
    521
    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

  7. #7
    Join Date
    Oct 2000
    Location
    Charlotte, USA
    Posts
    330
    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.

  8. #8
    Join Date
    Jul 2000
    Posts
    521
    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

  9. #9
    Join Date
    Oct 2000
    Location
    Charlotte, USA
    Posts
    330
    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.



  10. #10
    Join Date
    Jul 2000
    Posts
    521
    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
  •  


Click Here to Expand Forum to Full Width