oracle error 1171

[yls177]

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?

[mdash]

check the other errors message associated with this error in the alert log

[reydp]

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.

[Axr2]

See Note 1062177.6.

I assume you weren't trying that!

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

[reydp]

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.

[yls177]

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