RE: RMAN catalog question
- From: Michael Schmitt <mschmitt@xxxxxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 19 Jul 2012 18:49:41 +0000
Hello,
So one thing that I just noticed while looking into this. The RMAN catalog
schema(tables/procedures/etc) seems to get created based on the version of the
target that executed the "create catalog" command, and not the version of the
database that is hosting the catalog.
I checked this by comparing the schemas that were created by different versions
of oracle. If it was dependent on the version of oracle that hosted the
catalogs, they would all be the same. Ours differ by the version of oracle
that was used when executing the "create catalog" command.
Thanks
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Michael Dinh
Sent: Thursday, July 19, 2012 11:58 AM
To: Michael Schmitt
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: RMAN catalog question
RMAN Compatibility Matrix [ID 73431.1] provides a little more details.
RMAN executeable <= target database (when backup 9i database, use 9i RMAN)
Catalog schema >= RMAN executeable Catalog database >=10.2.0.3 (note 1)
Based on the information, I would create the RMAN database and catalog using
the latest and greatest release to ensure compatibilty.
-Michael
mdinh.wordpress.com
On Thu, Jul 19, 2012 at 8:04 AM, Michael Schmitt <mschmitt@xxxxxxxxxxxx>wrote:
> Hello,
>
> For our RMAN configuration, we run a single database to store
> individual catalogs for each of our databases. We create a new users
> in this central database and dedicate each user for the catalog of
> each database in our environment. That way we have a 1 to 1
> relationship between schemas(which store a catalog) and the databases we are
> backing up.
>
> Do we have to be concerned about what version of Oracle this central
> database that stores all the individual catalogs is running? Does it
> always have to be running the highest version of Oracle that we run in
> our environment?
>
> http://docs.oracle.com/cd/B28359_01/backup.111/b28273/compat003.htm#i6
> 34479
>
> The matrix in the above link is not exactly clear to me. Does the
> version of the recovery catalog schema come from the RMAN client
> version used to execute the create catalog command, or the version of
> the database that is used to store the catalog?
>
> Does anyone have any guidance on this?
>
> Thanks in advance for your help.
>
>
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
