How to Take Tablesspaces offline in Oracle Database

Taking tablespaces offline

To perform a "hot backup", each tablespace needs to put offline, and backed up using OS commands.

/* prepare for offline tablespace backup */

ALTER SYSTEM ARCHIVE LOG CURRENT;


/* take tablespace offline */

ALTER TABLESPACE users OFFLINE NORMAL;

/* run backup for datafiles */

/* bring tablespace online */

ALTER TABLESPACE users ONLINE;