Re: Changing DBID

From: joel garry <>
Date: Wed, 9 Jul 2008 13:05:53 -0700 (PDT)
Message-ID: <>

On Jul 9, 8:28 am, Chuck <> wrote:
> Mark D Powell wrote:
> > On Jul 8, 4:59 pm, Chuck <> wrote:
> >> Tim Arnold wrote:
> >>> see Metalink note Note:224266.1
> >> So how do you specify a value to change it to? That's really what I'm
> >> after. I don't want to change it to whatever random value Oracle picks.
> >> I want to reset it to it's original value.
> > The DBID should be unique in your shop.  Why do you want it to be the
> > same as the primary database from which the copy was made?
> > -- Mark D Powell --
> Not the same as the source of the copy, but I want the destination of
> the copy to have the same DBID after the duplication as it had before.

That is a strange want, as you are saying you want to restore backups that cannot apply. If you are duping from another db, why do you think you should be able to use backups from before the dupe? Recovery is based on transactions. The transactional chain is broken as far as those backups are concerned.


-- is bogus.
What's in your database?
Received on Wed Jul 09 2008 - 15:05:53 CDT

Original text of this message