RE: Change RMAN repository

From: Ruth Gramolini <rgramolini_at_tax.state.vt.us>
Date: Fri, 16 Jul 2004 09:06:11 -0400
Message-ID: <002a01c46b35$aafe7ca0$8459699f@vttaxnet.tax.state.vt.us>

The repository/catalog is just a group of oracle tables, views, etc. You could duplicate the repository database into a new database and then drop (remove) the databases which won't use the new catalog. Then just assign the ones that will to the new catalog. Of you could use exp/imp and only export the records you want to move and then assign the new catalog to the databases you want to be in the new repository/catalog.

HTH,
Ruth

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Kline.Michael Sent: Thursday, July 15, 2004 3:48 PM
To: oracle-l_at_freelists.org
Subject: RE: Change RMAN repository

They want to move the records to the new repository. I suspect they are going to split a group of servers and want the new group to use a new repository.

I think I may have opted for a phase in/phase out approach.

Michael Kline
Database Administration
Outside 804.261.9446
Cell 804.744.1545
3-9446

> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org

[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Ruth
> Gramolini
> Sent: Thursday, July 15, 2004 3:23 PM
> To: oracle-l_at_freelists.org
> Subject: RE: Change RMAN repository
>
> Do you want to just start a new set of records or move the records
from the
> old repository to the new? Either way you should be able to do this.
>
> Ruth
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Kline.Michael
> Sent: Thursday, July 15, 2004 3:09 PM
> To: oracle-l_at_freelists.org
> Subject: Change RMAN repository
>
>
> We have a need to move about 5-10 databases from one RMAN repository
to
> another.
>
>
> Is this possible?
>
>
>
> HP-UX and Oracle 9 repository.
>
>
>
> Can't find anything in metalink.
>
>
>
> Thanks.
>
>
>
> Michael Kline
> Database Administration
> SunTrust Technology Center
> 1030 Wilmer Avenue
> Richmond, Virginia 23227
> Outside 804.261.9446
> STNet 643.9446
>
> Cell 804.744.1545
> <mailto:michael.kline_at_suntrust.com> michael.kline_at_suntrust.com
> ************************************************
> The information transmitted is intended solely
> for the individual or entity to which it is
> addressed and may contain confidential and/or
> privileged material. Any review, retransmission,
> dissemination or other use of or taking action
> in reliance upon this information by persons or
> entities other than the intended recipient is
> prohibited. If you have received this email in
> error please contact the sender and delete the
> material from any computer.
> ************************************************
>
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------

The information transmitted is intended solely for the individual or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you have received this email in error please contact the sender and delete the material from any computer.

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

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Fri Jul 16 2004 - 08:03:04 CDT