Re: Can you backup a tablespace when the database is offline

peter_at_nomorenewsspammin.ca said...
> Hi,
>
> Can you backup a tablespace when the database is offline?
> I know you can backup a datafile when the databse is either online or
> offline.
>
> Thanks for your attention
>

Yes, you can backup tablespaces when the database is offline. Of course, we are probably talking about using O/S copy tools here.

Tablespaces are made up of one or more datafiles. So your only concern is making sure you backup ALL of the datafiles that make up the tablespace.

-- 
/Karsten
DBA > retired > DBA