RE: RMAN catalogs

From: Mercadante, Thomas F \(LABOR\) <Thomas.Mercadante_at_labor.state.ny.us>
Date: Wed, 29 Nov 2006 11:46:38 -0500
Message-ID: <ABB9D76E187C5146AB5683F5A07336FFE088D7@EXCNYSM0A1AJ.nysemail.nyenet>

Mike,

We have one Enterprise wide repository database that holds lots of tools schemas. In this database, we have Rman catalogs for 9.2 and 10.2 databases (two schemas). For each database, we use the rman executable with the Oracle home for that database. So all 9.2 databases use 9.2 Rman and all 10.2 databases use 10.2 Rman. Each connects to the correct repository. The Rman catalog are small enough where this is not an issue for us.

The Rman database itself is backed up using a separate Rman catalog that exists in an OID/LDAP database on another server. Optionally, you can simply export the Rman catalogs when no backups are running as a more simple method of protecting that data. But creating another Rman catalog in another database seemed like a better idea to me.

Hope this helps.

Tom

This transmission may contain confidential, proprietary, or privileged information which is intended solely for use by the individual or entity to whom it is addressed. If you are not the intended recipient, you are hereby notified that any disclosure, dissemination, copying or distribution of this transmission or its attachments is strictly prohibited. In addition, unauthorized access to this transmission may violate federal or State law, including the Electronic Communications Privacy Act of 1985. If you have received this transmission in error, please notify the sender immediately by return e-mail and delete the transmission and its attachments.

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Kline.Michael Sent: Wednesday, November 29, 2006 11:32 AM To: oracle-l_at_freelists.org
Subject: [Spam] RMAN catalogs

We're doing some planning for getting RMAN catalogs into a RMAN database, small, fast, and compact so it can be exported frequently.

What "real world" solutions work well for backing that catalog up should the catalog server go down or what ever?

Also, we have a lot of 10.2 and 9.2. Can 10G be used to back EVERYTHING up, and if there are "restrictions" what might they be?

Just looking for a direction. I've ordered Robert's new book, but it will probably be a while.

Thanks.

Michael Kline
Database Administration
SunTrust Banks, Inc.
Mail Code TOC-7505

1030 Wilmer Avenue
Richmond, Va. 23227
Tel: 804.261.9446 Net: 643.9446

Cell: 804.744.1545
michael.kline_at_suntrust.com <mailto:michael.kline_at_suntrust.com>

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

Received on Wed Nov 29 2006 - 10:46:38 CST