RE: Importing AWR data and changing DBID

From: Jorgensen, Finn <Finn.Jorgensen_at_constellation.com>
Date: Tue, 10 May 2011 14:52:46 -0400
Message-ID: <9CE162BC5ED2C643956B526A7EDE46FF021F6A9E55A9_at_EXM-OMF-04.Ceg.Corp.Net>

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] 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

>>> 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 - 13:52:46 CDT