As i know :
alter tablespace ... offline;
has to write to this tablespace :
1) all uncommited transactions
2) checkpoint number in datafile header block for each file in the tablespace.

in this situation this command can't solve this problem.

>>> alter database datafile 'missing XXXXXX' offline drop

may solve this problem in noachivelog mode only if no one oracle objects or espesially
part of object like tables, indexes ... no place in this datafile.but in any way in archivelog
mode oracle will ignore drop clause.

If i wrong - correct me.