oracle error 1171
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: oracle error 1171

  1. #1
    Join Date
    Oct 2002
    Posts
    391

    oracle error 1171

    Hi.

    I search the forum for this oracle error but only got 3 hits. Anyway, I checked this in my alert file as follows

    ORA-01171: datafile 57 going offline due to error advancing checkpoint



    01171, 00000, "datafile %s going offline due to error advancing checkpoint"
    // *Cause: The checkpoint in the file header could not be advanced. See
    // accompanying errors for the reason. The datafile will be taken
    // offline the same as for a write error of a data block.
    // *Action: See accompanying errors for details. Restore access to the file,
    // do media recovery, and bring it back online.



    The only reason that i can think of is that the log writer is in the same file header?

  2. #2
    Join Date
    Jan 2003
    Location
    Delhi
    Posts
    63
    check the other errors message associated with this error in the alert log

  3. #3
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    I might as well check if all the datafiles was in-sync before I started my db, otherwise I might need some kind of database recovery here.
    ---------------

  4. #4
    Join Date
    Oct 2002
    Posts
    807
    See Note 1062177.6.

    I assume you weren't trying that!

    PS : Recovery is probably the way to go as has already been suggested

  5. #5
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    Originally posted by Axr2

    I assume you weren't trying that!
    Right, I am expecting what could be yls177's next activities. Just like you do.
    ---------------

  6. #6
    Join Date
    Oct 2002
    Posts
    391
    Originally posted by reydp
    Right, I am expecting what could be yls177's next activities. Just like you do.
    Hi.

    My next activity will be to read 1062177.6

    Thanks for all your helps.

    Cheers

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