Re: hot backup mode question

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Mon, 3 Dec 2001 19:33:16 +1100
Message-ID: <3c0b38bb$0$27198$afc38c87@news.optusnet.com.au>

Absolutely. You cannot copy *any* Oracle file 'hot' without the resulting output file being, internally, an inconsistent mess. The begin backup command enables the subsequent application of redo to data files, which makes them internally consistent again. Without it, you're stuffed.

(There's a fair bit of info about backup and recovery on my site, incidentally. May shorten your learning curve a bit).

Regards
HJR

--
Resources for Oracle: http://www.hjrdba.com
===============================


"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 Mon Dec 03 2001 - 02:33:16 CST