FreeLists / oracle-l / RE: RMAN DBID

["Ruth Gramolini" <rgramolini@xxxxxxxxxxxxxxx>]

The if you to autobackup and your autobackup format is set to
/_complete_path/%F then the controlfile autobackup is name
c-dbid-yyyymmdd-nn where nn is the sequences of the backup controlfile for
that date.

HTH,
Ruth

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of John Clarke
Sent: Monday, April 04, 2005 4:07 PM
To: rgramolini@xxxxxxxxxxxxxxx; oracle-l; dnt9000@xxxxxxxxx
Subject: RE: RMAN DBID


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@xxxxxxxxxxxxxxx>
To: rgramolini@xxxxxxxxxxxxxxx, oracle-l <oracle-l@xxxxxxxxxxxxx>, dnt90=
00@xxxxxxxxx
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@xxxxxxxxxxxxxxx>
> To: oracle-l <oracle-l@xxxxxxxxxxxxx>, dnt9000@xxxxxxxxx
> 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@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
> > --
> > http://www.freelists.org/webpage/oracle-l
> >=20
> > --
> > http://www.freelists.org/webpage/oracle-l
> >=20
>=20

--
http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l