The difference between offline drop and offline

Offline drop and offlineoffline drop demo in archive mode

Offline demonstration in Archive Mode

You can see that in archive mode, the effect of offline drop is the same as that of offline. Both data files are in recover status. If online is needed, recover will be performed first, and then the data file status will change to fline status. Dba can manually online.

Switch database to non-archive mode

Testing with test03.dbf data files

You can see that offline is not allowed in non-archive mode, and directly test the effect of offline drop in non-archive mode.

You can see that the effect of offline drop in non-archive mode is the same as that of offline drop in archive mode. Both of them put the data file into recover status. If online is needed, recover is performed first, and then the data file status changes to fline status. Dba can manually online.