From oracle-l-bounce@freelists.org Wed May 25 21:45:19 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j4Q2jJqB022622 for ; Wed, 25 May 2005 21:45:19 -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 j4Q2jJNi022618 for ; Wed, 25 May 2005 21:45:19 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7A6701B2098; Wed, 25 May 2005 20:42:21 -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 15228-02; Wed, 25 May 2005 20:42:21 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id ED34D1B1F8C; Wed, 25 May 2005 20:42:20 -0500 (EST) X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-type: text/plain Subject: RE: FW: backing up rman catalog for disaster recovery Date: Wed, 25 May 2005 21:38:04 -0400 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: FW: backing up rman catalog for disaster recovery Thread-Index: AcVhd0JquO8tgZbxTluyJGdNwCql9AAHEz6e From: "Marquez, Chris" To: , Cc: "oracle-l" Content-Transfer-Encoding: 8bit X-archive-position: 20296 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: cmarquez@collegeboard.org Precedence: normal Reply-To: cmarquez@collegeboard.org X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=0.0 required=5.0 tests=AWL autolearn=ham version=2.63 >>I just cheated and backed up the control file separately "Cheat" nothing this is just smart...or reality :o| >> run {allocate channel c4 type disk; copy current controlfile to... >> in my shell script *every* time and AT THE END OF EACH BACKUP >> NOT an RMAN *backup* of my controlfile (totally useless), >> but rather a *COPY* of my controlfile. >> Meaning it can be used without RMAN; As I said in an earlier post, RMAN backup controlfile (IMHO) is rather useless. It is the classic "chicken and egg". You have a controlfile in the RMAN backup, but you need a current controlfile to get to the backup! (in the absence of a recover catalog). If I have a current controlfile then why do I need the one *in* the backup? Oracle should update the RMAN documentation it indicate thsi mental puzzle. Seems everyone learns this the hard way during testing...or the really hard way during a disaster. Anyone want to guess... What would be of some use when all current controlfiles and datafiles are lost and you have >1 good RMAN backups? (A worst case senario). Chris Marquez Oracle DBA -----Original Message----- From: oracle-l-bounce@freelists.org on behalf of Dennis Williams Sent: Wed 5/25/2005 6:15 PM To: rgramolini@tax.state.vt.us Cc: oracle-l Subject: Re: FW: backing up rman catalog for disaster recovery Actually, RMAN always writes to the control file before it updates the catalog. So even if you do an RMAN backup using a catalog, you can still recover the database using only the controlfile. Now, in Oracle8i I had problems recovering the control file from the RMAN backup, so I just cheated and backed up the control file separately after the RMAN backup completed, and made sure the control file backup was on the same tape as the RMAN backup. I have performed many recoveries using this method. Dennis Williams On 5/25/05, Ruth Gramolini wrote: >=20 >=20 > One very easy way is to do an rman backup with the nocatalog option. Thi= s > will use controlfile info for restores and recoveries. You can use all t= he > options of rman, just no catalog. That is what we do. >=20 > Just my $0.02, > Ruth >=20 > -----Original Message----- > From: Paula_Stankus@doh.state.fl.us > [mailto:Paula_Stankus@doh.state.fl.us] > Sent: Wednesday, May 25, 2005 4:49 AM > To: Paula_Stankus@doh.state.fl.us; rgramolini@tax.state.vt.us; > all_about_oracle@hotpop.com; oracle-l@freelists.org > Subject: RE: backing up rman catalog for disaster recovery >=20 >=20 > I am setting up a disaster recovery site and I was thinking about the > best way to do this. >=20 > My theory is that I would like to not just use another recovery catalog > on the DR site to backup my primary catalog but to somehow keep these > catalogs constantly in-synch so when I do need to do complete recovery > and only have the secondary rman catalog available - I wouldn't have to > recover the catalog as all of the previous backups would be found there. >=20 > So....should I do this using Oracle Data Guard on my disaster recovery > site catalog or backup rman then restore as my first procedure? Any > advice? >=20 > -- > http://www.freelists.org/webpage/oracle-l > -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l