-
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?
-
check the other errors message associated with this error in the alert log
-
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.
---------------
-
See Note 1062177.6.
I assume you weren't trying that!
PS : Recovery is probably the way to go as has already been suggested
-
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.
---------------
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|