Re: Importing AWR data and changing DBID

From: kyle Hailey <kylelf_at_gmail.com>
Date: Tue, 10 May 2011 15:48:37 -0700
Message-ID: <BANLkTimkQVPereJFk+J1dMPg61BkU+BOzA_at_mail.gmail.com>

Clones are Delphix clones (see http://dboptimizer.com/delphix/ <http://dboptimizer.com/delphix/%20>) , ie virtual databases, so the virtual databases will have the same DBID, but if I'm importing the virtual database's AWR data into shared repository I can change the DBID at time of importing the data.

• Kyle http://dboptimizer.com

On Tue, May 10, 2011 at 12:00 PM, <Mayen.Shah_at_lazard.com> wrote:

> I was going to suggest that....
> If you use RMAN cloning, it will automatically assign new DBID as a cloning
> process.
>
> Thanks
> Mayen
>
>
>
> From: "Jorgensen, Finn" <Finn.Jorgensen_at_constellation.com>
> To: "'kylelf_at_gmail.com'" <kylelf_at_gmail.com>, "'ORACLE-L' " <
> Oracle-L_at_freelists.org>
> Date: 05/10/2011 02:55 PM
> Subject: RE: Importing AWR data and changing DBID
> Sent by: oracle-l-bounce_at_freelists.org
> ------------------------------
>
>
>
> This is a little backwards, but why don’t you assign a new DBID as part of
> the cloning process? That would take care of this problem as well as any
> RMAN central repository issues.
>
> Thanks,
> Finn
>
> *From:* oracle-l-bounce_at_freelists.org [
> mailto:oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org>] *On
> Behalf Of *kyle Hailey*
> Sent:* Tuesday, May 10, 2011 2:47 PM*
> To:* ORACLE-L*
> Subject:* Importing AWR data and changing DBID
>
>
> Just to avoid re-inventing the wheel ...
> has anyone written something to change the DBID of AWR data when importing
> into a shared repository?
> SInce many of my databases are clones they all have the same DBID, thus in
> order to distinguish the different database statistics in a shared AWR
> repository, I want to change the DBIDs.
>
> - Kyle*
> **http://dboptimizer.com* <http://dboptimizer.com/>
>
> >>> This e-mail and any attachments are confidential, may contain legal,
> professional or other privileged information, and are intended solely for
> the
> addressee. If you are not the intended recipient, do not use the
> information
> in this e-mail in any way, delete this e-mail and notify the sender.
> CEG-IP2
>
>

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

Received on Tue May 10 2011 - 17:48:37 CDT