Oracle 'SYSTEM01.DBF' error - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 3 FirstFirst 123 LastLast
Results 11 to 20 of 23

Thread: Oracle 'SYSTEM01.DBF' error

  1. #11
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    Mount the database and recover system datafile.

    SQL> alter database recover datafile 1;

    As Dave said, if there is any mess-up with redo log files then you will screwed else you will be fine.

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  2. #12
    Join Date
    Jan 2009
    Posts
    10
    Actually in the beginning I was receiving below error msg when executed 'startup;'

    startup;
    ORACLE instance started.
    Total System Global Area 571547208 bytes
    Fixed Size 454216 bytes
    Variable Size 243269632 bytes
    Database Buffers 327155712 bytes
    Redo Buffers 667648 bytes
    Database mounted.
    ORA-00368: checksum error in redo log block
    ORA-00353: log corruption near block 95218 change 63039931 time 12/19/2008 19:51:05
    ORA-00312: online log 3 thread 1: 'C:\ORACLE\ECC\REDO03.LOG'

    The original log file is REDO03.LOG. I thought renaming to REDO033.LOG might help, then afterwards when I executed 'startup mount;' command, the database got mounted successfully. But on trying 'alter database open resetlogs;' I started receiving below error:

    SQL> alter database open resetlogs;
    alter database open resetlogs
    *
    ERROR at line 1:
    ORA-01194: file 1 needs more recovery to be consistent
    ORA-01110: data file 1: 'C:\ORACLE\ECC\SYSTEM01.DBF'

    Due to this reason I had to rename the log file back to REDO03.LOG.....

  3. #13
    Join Date
    Jan 2009
    Posts
    10
    SQL> alter database recover datafile 1;
    alter database recover datafile 1
    *
    ERROR at line 1:
    ORA-00283: recovery session canceled due to errors
    ORA-01610: recovery using the BACKUP CONTROLFILE option must be done

  4. #14
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    you need to do a recovery - unless you ultiplex your redo logs

  5. #15
    Join Date
    Jan 2009
    Posts
    10
    How? Can you please help?

  6. #16
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    Dave -

    Do you mean complete database recovery?

    I am sure he doesn't multiplex redo log files.

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  7. #17
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    call oracle support - they will talk you through it

  8. #18
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    Dave -

    Calling oracle support is the last option for all the DBAs on the earth after putting every attempt from there side. Thanks for your suggestion.

    As per the error posted, I understood that one of the redo logs had a block corruption. He didn't mention whether that redo log is current or inactive. He renamed the corrupted log with other name (not sure how far renaming on the same physical location works). So, the work around i suggest is ...

    1. Recover until cancel
    2. Open resetlogs.

    Appreciate comments on this.

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  9. #19
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    Quote Originally Posted by vnktummala View Post
    Dave -

    Calling oracle support is the last option for all the DBAs on the earth after putting every attempt from there side. Thanks for your suggestion.
    WHAT? if you have no clue - oracle support is the first call, thats what you pay them for!



    As per the error posted, I understood that one of the redo logs had a block corruption. He didn't mention whether that redo log is current or inactive. He renamed the corrupted log with other name (not sure how far renaming on the same physical location works). So, the work around i suggest is ...

    1. Recover until cancel
    2. Open resetlogs.

    Appreciate comments on this.

    Thanks,
    if it wasnt the online log then no recovery would be needed would it?

    if you are going to say dangerous advice, keep it to yourself!

  10. #20
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    There you go ... you gave the clue. No need to contact oracle support now

    Thanks Dave.
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

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