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 <jclarke_at_centroidsys.com>
To: rgramolini_at_tax.state.vt.us, oracle-l <oracle-l_at_freelists.org>, dnt90=
00_at_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 <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
>=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_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
>=20
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Apr 04 2005 - 16:11:19 CDT