Re: Hot backup of the RBS tablespace

--0-424238335-962388984=:6004
Content-Type: text/plain; charset=us-ascii

 Yes, you need it to rollback uncomitted transactions at the end of recovery. You might be able to leave it out and manually recreate the datafiles prior to recovery. Same with temp. But I've never tried this and don't know off the top of my head whether it will work or not.   pschauss_at_parker.com wrote:
I am working on a script to do hot backups using the approach:

alter tablespace xxx begin backup;

alter tablespace xxx end backup;

Should I backup the tablespace which contains the rollback segments?

thanks

Peter Schauss
Parker Hannifin Corporation
Smithtown, NY

-- 
Author: 
INET: pschauss_at_parker.com

Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).


---------------------------------
Do You Yahoo!?
Get Yahoo! Mail - Free email you can access from anywhere!
--0-424238335-962388984=:6004
Content-Type: text/html; charset=us-ascii



<P> Yes, you need it to rollback uncomitted transactions at the end of recovery. 

<P>You might be able to leave it out and manually recreate the datafiles prior to recovery. Same with temp. But I've never tried this and don't know off the top of my head whether it will work or not.

<P>&nbsp; <B><I>pschauss_at_parker.com</I></B> wrote: <BR>

<BLOCKQUOTE style="BORDER-LEFT: #1010ff 2px solid; MARGIN-LEFT: 5px; PADDING-LEFT: 5px">I am working on a script to do hot backups using the approach:<BR><BR>alter tablespace xxx begin backup;<BR><BR><COPY datafiles><BR><BR>alter tablespace xxx end backup;<BR><BR>Should I backup the tablespace which contains the rollback segments?<BR><BR>thanks<BR><BR>Peter Schauss<BR>Parker Hannifin Corporation<BR>Smithtown, NY<BR><BR>-- <BR>Author: <BR>INET: pschauss_at_parker.com<BR><BR>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051<BR>San Diego, California -- Public Internet access / Mailing Lists<BR>--------------------------------------------------------------------<BR>To REMOVE yourself from this mailing list, send an E-Mail message<BR>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in<BR>the message BODY, include a line containing: UNSUB ORACLE-L<BR>(or the name of mailing list you want to be removed from). You may<BR>also send the HELP command for other !

information (like subscribing).</BLOCKQUOTE><p><br><hr size=1><b>Do You Yahoo!?</b><br>
Get Yahoo! Mail - Free email you can access from anywhere!