alter tablespace offline和alter datafile offline的区别
There is a big difference between:
Taking the tablespace offline and Taking the datafiles offline
ALTER TABLESPACE ... OFFLINE
Does a checkpoint on the datafiles
Takes the datafiles offline
ALTER DATABASE DATAFILE ... OFFLINE
Does not perform a checkpoint,
So that if the database is open, you may need to perform media recovery when bringing it online.
That is the reason why:
You cannot do 'alter database datafile ... offline' if you are in noarchivelog (but tablespace offline works)
You cannot do 'alter tablespace ... offline' if database is read-only (but datafile offline works)