From oracle-l-bounce@freelists.org Fri Oct 7 09:42:40 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j97EgZFx031786 for ; Fri, 7 Oct 2005 09:42:35 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j97EgPvX031669 for ; Fri, 7 Oct 2005 09:42:26 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 215B81F787A; Fri, 7 Oct 2005 09:41:01 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 15435-09; Fri, 7 Oct 2005 09:41:01 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 919CB1F7877; Fri, 7 Oct 2005 09:41:00 -0500 (EST) X-VirusChecked: Checked X-Env-Sender: swhite@lifetouch.com X-Msg-Ref: server-7.tower-109.messagelabs.com!1128695933!28040031!4 X-StarScan-Version: 5.5.4.1; banners=lifetouch.com,-,- X-Originating-IP: [63.71.63.1] Message-ID: <3896E060305BBC40AB9D1CE31DD6731B01919DC9@exchlt1.LIFETOUCH.NET> From: Susan White To: "'Oracle-L@FreeLists.org'" Subject: backup best practices Date: Fri, 7 Oct 2005 09:37:32 -0500 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C5CB4C.A6A45C74" X-archive-position: 26539 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: swhite@lifetouch.com Precedence: normal Reply-To: swhite@lifetouch.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Level: X-Spam-Status: No, hits=-4.7 required=5.0 tests=BAYES_00,HTML_50_60, HTML_MESSAGE autolearn=no version=2.63 ------_=_NextPart_001_01C5CB4C.A6A45C74 Content-Type: text/plain Should off-line backups (RMAN or otherwise) be a part of a standard backup strategy? In the "old" days, cold backups were recommended for consistency - or at least that's how I understood it. Now, it seems that these are not deemed essential. What is the recommended best practice for off-line/on-line backups? Related to this: Should the DB be "bounced" occasionally? In my last oracle class, this was implied, although not stated. Any thoughts Thanks Susan White ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________ ------_=_NextPart_001_01C5CB4C.A6A45C74 Content-Type: text/html Content-Transfer-Encoding: quoted-printable

Should=20off-line=20backups=20(RMAN=20or=20otherwise)=20be=20a=20p= art=20of=20a=20standard backup=20strategy?=20In=20the=20"old"=20days,=20cold=20backups=20= were=20recommended=20for consistency=20-=20or=20at=20least=20that's=20how=20I=20understood=20it.=20= Now,=20it=20seems=20that=20these are=20not=20deemed=20essential.=20What=20is=20the=20recommended=20best=20p= ractice=20for off-line/on-line=20backups?

Related=20to=20this: =20Should=20the=20DB=20be=20“bounc= ed” occasionally? =20In=20my=20last=20oracle=20class,=20this=20was=20impl= ied,=20although=20not stated. =20Any=20thoughts

Thanks

Susan=20White

______________________________________________________________________
= This=20email=20has=20been=20scanned=20by=20the=20MessageLabs=20Email=20Sec= urity=20System.
For=20more=20information=20please=20visit=20http://www.messagelabs.com/ema= il=20
______________________________________________________________________
= ------_=_NextPart_001_01C5CB4C.A6A45C74-- -- http://www.freelists.org/webpage/oracle-l