RE: RMAN DBID

[John Clarke <jclarke@xxxxxxxxxxxxxxx>]

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
> --
> http://www.freelists.org/webpage/oracle-l
>=20
> --
> http://www.freelists.org/webpage/oracle-l
>=20

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

• Follow-Ups:
  • RE: RMAN DBID
    • From: John Clarke

• References:
  • RE: RMAN DBID
    • From: Ruth Gramolini

Other related posts:

RMAN DBID

RE: RMAN DBID

RE: RMAN DBID

RE: RMAN DBID

RE: RMAN DBID