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_at_tax.state.vt.us>
To: oracle-l <oracle-l_at_freelists.org>, dnt9000_at_yahoo.com
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_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of David Turner
> Sent: Monday, April 04, 2005 3:17 PM
> To: oracle-l_at_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
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Apr 04 2005 - 16:01:51 CDT