Re: Importing AWR data and changing DBID

From: Jeremiah Wilton <jwilton_at_bluegecko.net>
Date: Tue, 10 May 2011 16:36:40 -0700
Message-ID: <BANLkTinnZu-NEHvJL02YhUyb=3D9pH+O1Q_at_mail.gmail.com>

Kyle, the AWR importer in dbms_workload_replay does this.

Jeremiah
On May 10, 2011 3:52 PM, "kyle Hailey" <kylelf_at_gmail.com> wrote:
> 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 - 18:36:40 CDT