Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> hot backup mode question

hot backup mode question

From: Tom Hoffmann <tom.hoffmann_at_worldnet.att.net>
Date: Mon, 03 Dec 2001 01:00:24 GMT
Message-ID: <Xns916BCB59D583Ftomhoffmannworldneta@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:00:24 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US