Yes, you need to do this before you backup each tablespace. Also remember
to take them out of backup mode once you have backed one up. Preferred
method is to do each tablespace one at a time.
Jim
"Tom Hoffmann" <tom.hoffmann_at_worldnet.att.net> wrote in message
news:Xns916BCB59D583Ftomhoffmannworldneta_at_204.127.36.1...
> 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:17:46 CST
