This will work if you haven't lost your controlfiles, but if you've lost= 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 se= t the DBID. Correct me if I'm wrong, but tagging the DBID in the backups won't help = in the event you actually lose your control file either (without a catal= og), because you won't be able to mount the database so you can't access= any information from the controlfile (which is where these tags would r= eside). 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 (whi= ch of course we would), manually tracking the DBID *outside* RMAN is pro= bably a good idea. - John ----- Original Message ----- From: Ruth Gramolini <rgramolini@xxxxxxxxxxxxxxx> To: oracle-l <oracle-l@xxxxxxxxxxxxx>, dnt9000@xxxxxxxxx Sent: Mon, 4 Apr 2005 15:44:55 -0400 Subject: RE: RMAN DBID > The DBID is also kept by the controlfile. You can see this by connect= ing to > rman nocatalog and then connect to your target. Here is what you will= 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 i= n > noncatalog mode. >=20 > HTH, > Ruth > -----Original Message----- > From: oracle-l-bounce@xxxxxxxxxxxxx > [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of David Turner > Sent: Monday, April 04, 2005 3:17 PM > To: oracle-l@xxxxxxxxxxxxx > 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 > -- > //www.freelists.org/webpage/oracle-l >=20 > -- > //www.freelists.org/webpage/oracle-l >=20 -- //www.freelists.org/webpage/oracle-l