Xref: alice comp.databases.oracle.misc:52380 Path: alice!news-feed.fnsi.net!newsfeed.direct.ca!remarQ70!remarQ.com!supernews.com!remarQ69!WReNclone!WReNphoon4.POSTED!WReN!not-for-mail X-Originating-Host: 198.186.239.148 Organization: http://www.remarq.com: The World's Usenet/Discussions Start Here Subject: Re: backup and recovery in data warehouse Lines: 13 From: MohammedB Newsgroups: comp.databases.oracle.misc Message-ID: <1734e708.a38de3e3@usw-ex0103-019.remarq.com> References: <877o0p$7kl$1@nnrp1.deja.com> <389839D7.D4D79E80@edcmail.cr.usgs.gov> Bytes: 474 X-Wren-Trace: eHFUfH1kI2kiPGpxdTx9fWdgQX11cTMpe295Mik8MH8vL2c+LWI9MSwkLQ== Date: Wed, 02 Feb 2000 11:52:53 -0800 X-Complaints-To: wrenabuse@remarq.com X-Trace: WReNphoon4 949521083 10.0.2.19 (Wed, 02 Feb 2000 11:51:23 PST) NNTP-Posting-Date: Wed, 02 Feb 2000 11:51:23 PST I'd have thought that once you place a tablespace in read only mode and then back it up, you're done with it i.e. you don't have to back it up again unless you change the mode to read/write. In which case, I'd go with hot backup only on the tablespaces that are read/write plus exports as Brian suggested. mkb * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!