Results 1 to 4 of 4
  1. #1
    Join Date
    May 2002
    Location
    Budapest - Hungary
    Posts
    12

    Unanswered: ORA-00604: error occurred at recursive SQL level 1 ORA-01578 etc

    Team,
    We have a critical issue...

    ORA-00604: error occurred at recursive SQL level 1 ORA-01578: ORACLE data block corrupted (file # 1, block # 3871) ORA-01110: data file 1: '/db8901/oradata/budorp89/system/system01.dbf'

    It's on SUN Solaris server...

    Any Idea?

    Thanks,
    Attila

  2. #2
    Join Date
    Oct 2002
    Location
    greenwich.ct.us
    Posts
    279
    You have a corrupt block. Your best bet is to restore and recover...

  3. #3
    Join Date
    May 2002
    Location
    Budapest - Hungary
    Posts
    12
    We have a problem with restore process. The datafiles were not uncompressing properly.

  4. #4
    Join Date
    Apr 2002
    Location
    California, USA
    Posts
    482

    Thumbs up Re: ORA-00604: error occurred at recursive SQL level 1 ORA-01578 etc

    Originally posted by horvata
    Team,
    We have a critical issue...

    ORA-00604: error occurred at recursive SQL level 1 ORA-01578: ORACLE data block corrupted (file # 1, block # 3871) ORA-01110: data file 1: '/db8901/oradata/budorp89/system/system01.dbf'

    It's on SUN Solaris server...

    Any Idea?

    Thanks,
    Attila

    Corruption in the SYSTEM tablespace, could be only corrected with complete restore. Block recovery will not work in this case.


    Hope that helps,

    clio_usa
    OCP - DBA

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •