Aug 13, 2008

Taking tablespaces offline

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;

No comments:

Post a Comment

Popular Posts