var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: ora:01171 datafile %s going offline due to error advancing checkpoint
Would like to know what causes this error message,
ora 01171 : datafile %s going offline due to error advancing checkpoint
ora 01116 : error in opening database file %s
when ever I ran a huge load through SQL Loader in the database this happens. I did try to do Media recovery, the db comes up ok, but then again when I run the load, it gives the same error.
Any solution is highly appreciated.
Are u running your database in AIX enviroment?
IF yes, please disable AIO in initsid.ora and restart your database.
It is an oracle/(or aix?, who knows) bug.
This should help you, though some performance degration,
I am running Oracle on Sun OS.