Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> hot backup mode question
I am an SA by trade who must now learn the trade of DBA. In reading the
Oracle documentation on 'hot backup' mode, it states that tablespaces
must be placed in 'hot backup' mode with a:
alter tablespace <tablespacename> begin backup;
statement before being backed up. But is this the case for all tablespaces? It seems obvious [to me] that the data and index tablespaces should be, it is not so obvious that the tools, temp, rbs, and user tablespaces must be. Must I execute an 'alter tablespace ...' on these tablespaces also before backing them up in 'hot backup' mode? Received on Sun Dec 02 2001 - 19:00:24 CST