Xref: alice comp.databases.oracle.server:35807 Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!cpk-news-hub1.bbnplanet.com!news.gtei.net!firehose.mindspring.com!not-for-mail From: Ron Denham Newsgroups: comp.databases.oracle.server Subject: Re: Backup/Recovery of RBS datafiles Date: Sat, 12 Dec 1998 20:43:32 -0500 Organization: MindSpring Enterprises Lines: 23 Message-ID: <36731BC4.64B95BF8@mindspring.com> References: <367168c1.20068785@news1.axs2000.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Server-Date: 13 Dec 1998 01:46:40 GMT X-Mailer: Mozilla 4.06 [en] (Win95; I) You just need to think of your RBS tablespace as data and back it up. It is even more important because, if you loose it, your database is toast if you have open transactions. Chuck Hamilton wrote: > Is it really necessary to include rollback segment datafiles in every > backup? We'd save about 8g on our backups if we didn't. Is there any > easy way to rebuild them if we needed to? > > One thought I had was to keep one copy of the RBS datafiles and if we > ever had to recover, we could just restore it from that backup and do > a recovery on it. > > What are your thoughts? > -- > Chuck Hamilton > chuckh@safeaccess.net > > "Therefore the Lord Himself will give you a sign: > Behold, a virgin will be with child, and bear a son, > and she will call His name Immanuel." (Isa 7:14 NASB)