Re: Problem doing RMAN backup of Clone?

Use following command to generate new dbid.

dbms_backup_restore.zeroDbid(0)

Read Note:164870.1 on metalink for complete procedure.

HTH
-Shaleen
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Monday, November 25, 2002 7:05 AM

> Unfortunately, this problem is with the DBID, not anything in the
> controlfile. Oracle 9.2 comes with a utility called 'nid' in
> $ORACLE_HOME/bin/, which can change the DBID of a database. AFAIK,
> there is no other way to change the DBID, and you just have to use
> another catalog.
>
> I think nid may work on lower version databases, but I am not sure.
> Check out the docs.
>
> --
> Jeremiah Wilton
> http://www.speakeasy.net/~jwilton
>
> On Mon, 25 Nov 2002, Koivu, Lisa wrote:
>
> > I can't answer the question about rman... but if you recreate the
> > controlfile you will have a new incarnation number of the database.
Have
> > you tried that?
> >
> > > -----Original Message-----
> > > From: Doug C [SMTP: ]
> > >
> > > Someone has just told me you can't do an RMAN backup of a clone
because it
> > > has
> > > the same database id as the original. Is this true or not? If so,
how
> > > to get
> > > around it?
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jeremiah Wilton
> INET: jwilton_at_speakeasy.net
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: orafaq
  INET: shgarg_orafaq_at_hotmail.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).