From oracle-l-bounce@freelists.org Mon Apr 4 16:11:19 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j34LBHET011146 for ; Mon, 4 Apr 2005 16:11:17 -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 j34LBGem011134 for ; Mon, 4 Apr 2005 16:11:16 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9A0C49069F; Mon, 4 Apr 2005 15:09:14 -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 24505-03; Mon, 4 Apr 2005 15:09:14 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 159F09067E; Mon, 4 Apr 2005 15:09:14 -0500 (EST) Message-ID: <20050404160724.774f8a54@centroidsys.com> From: John Clarke To: rgramolini@tax.state.vt.us, oracle-l , dnt9000@yahoo.com Subject: RE: RMAN DBID Date: Mon, 4 Apr 2005 16:07:24 -0400 In-Reply-To: <20050404155755.2ba70fc7@centroidsys.com> MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit X-archive-position: 18016 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: jclarke@centroidsys.com Precedence: normal Reply-To: jclarke@centroidsys.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Checker-Version: SpamAssassin 2.60 (1.212-2003-09-23-exp) on air891.startdedicated.com X-Spam-Status: No, hits=1.0 required=5.0 tests=AWL,MAILTO_TO_SPAM_ADDR, SUBJ_ALL_CAPS autolearn=no version=2.60 X-Spam-Level: * One more thing to add ... If you configure autobackups of your controlfile, I believe the DBID is = embedded in the backup controlfile name by default. At least that's wha= t I see on 9206, Redhat Linux. So that may help ... ----- Original Message ----- From: John Clarke To: rgramolini@tax.state.vt.us, oracle-l , dnt90= 00@yahoo.com Sent: Mon, 4 Apr 2005 15:57:55 -0400 Subject: RE: RMAN DBID > This will work if you haven't lost your controlfiles, but if you've lo= st your > controlfiles you can't mount, and without mounting the controlfile you= don't see > the DBID. And to restore the controlfile, you need to set the DBID. >=20 > Correct me if I'm wrong, but tagging the DBID in the backups won't hel= p in the > event you actually lose your control file either (without a catalog), = because > you won't be able to mount the database so you can't access any inform= ation from > the controlfile (which is where these tags would reside). >=20 > I wouldn't be surprised if I'm wrong here, but I think that if you don= 't use a > catalog and you wish to protect against loss of controlfiles (which of= course we > would), manually tracking the DBID *outside* RMAN is probably a good i= dea. >=20 > - John >=20 > ----- Original Message ----- > From: Ruth Gramolini > To: oracle-l , dnt9000@yahoo.com > Sent: Mon, 4 Apr 2005 15:44:55 -0400 > Subject: RE: RMAN DBID >=20 >=20 > > The DBID is also kept by the controlfile. You can see this by conne= cting to > > rman nocatalog and then connect to your target. Here is what you wi= ll get: > > $ rman nocatalog > >=20 > > Recovery Manager: Release 9.2.0.4.0 - 64bit Production > >=20 > > Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved. > >=20 > > RMAN> connect target > >=20 > > connected to target database: REF3DEV (DBID=3D2000332275) > > using target database controlfile instead of recovery catalog > >=20 > > RMAN> > >=20 > > You can see that the DBID is returned when you connect to the target= in > > noncatalog mode. > >=20 > > HTH, > > Ruth > > -----Original Message----- > > From: oracle-l-bounce@freelists.org > > [mailto:oracle-l-bounce@freelists.org]On Behalf Of David Turner > > Sent: Monday, April 04, 2005 3:17 PM > > To: oracle-l@freelists.org > > Subject: RMAN DBID > >=20 > >=20 > > I'm finally replacing the backup scripts we use for > > our databases with RMAN and am looking for any tips > > from people that have been using it for a while. > >=20 > > First off, if you're not using a recovery catalog > > where should you store the DBID. I hate to think I > > wouldn't be able to restore a DB because I forgot to > > update a spreadsheet. I'm also looking at including it > > in the backup tag, but wanted to get some info from > > the list before setting anything in stone. > >=20 > > Thx, Dave > >=20 > > =5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F= =5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F= =5F=5F=5F=5F > > Do You Yahoo!=3F > > Tired of spam=3F Yahoo! Mail has the best spam protection around > > http://mail.yahoo.com > > -- > > http://www.freelists.org/webpage/oracle-l > >=20 > > -- > > http://www.freelists.org/webpage/oracle-l > >=20 >=20 -- http://www.freelists.org/webpage/oracle-l