Re: Query to find DB Version on Rman Catalog

From: Bradd Piontek <piontekdd_at_gmail.com>
Date: Thu, 26 Mar 2009 07:46:25 -0500
Message-ID: <e9569ef30903260546i3f58c02bhe540e90aa58f4e90_at_mail.gmail.com>

Nagaraj, I am not sure you are going to be able to satisfy that requirement, unless Oracle is hiding the version somewhere in one of the catalog databases. RC_DATABASE and RC_DATABASE_INCARNATION don't store this type of information. My guess is due to redundancy (you have to connect to a target to do backups, so why store it twice and have to worry about keeping it in sync between patching and upgrades) oracle doesn't store that type of information. Three solutions I can think of of the top of my head 1. create your own table on the catalog database to store this information. In past lives, I've used this to store database version, host-name, and various other information. The downside is you have to remember to keep this updated.
2. Create database links from the Catalog database to your rman targets so you can join v$version or v$instance
3. Connect to both the catalog and target similar to how RMAN would.

Bradd Piontek
  "Next to doing a good job yourself,

        the greatest joy is in having someone
        else do a first-class job under your
        direction."

• William Feather

On Thu, Mar 26, 2009 at 1:52 AM, Nagaraj S <nagaraj.chk_at_gmail.com> wrote:

> Hello Ram Srinivasan,
>
>
>
> My requirement is to query in RMAN CATALOG Database to find what are the db
> version has been registered to rman catalog database
>
>
>
> Regards,
>
> Naga
>
> On Tue, Mar 24, 2009 at 2:03 AM, Ram Srinivasan <
> srinivasanram2004_at_gmail.com> wrote:
>
>> Nagaraj:
>> $rman target /
>>
>>
>> Recovery Manager: Release 10.1.0.5.0 - 64bit Production
>>
>> Copyright (c) 1995, 2004, Oracle. All rights reserved.
>>
>> connected to target database: XXCSER (DBID=3818643774)
>>
>> RMAN> exit
>>
>> Now you knwo what the target database is:
>>
>> Set your ORACLE_SID as export ORACLE_SID=XXCSER
>>
>> and login to the database as sysdba using sqlplus. Then you can query the
>> v$version table. You cal also query the registry$history table or
>> dba_registry_history table to get the latest patches applied.
>>
>>
>>
>> Ram Srinivasan
>>
>>
>>
>>
>> On 3/20/09, Nagaraj S <nagaraj.chk_at_gmail.com> wrote:
>>>
>>> Hi Gurus,
>>>
>>>
>>> I have different oracle database versions registered to my RMAN CATALOG
>>> DATBASE. Is there any query to find What is the version of the database
>>> registered to my RMAN CATALOG DATABASE?
>>>
>>>
>>>
>>> Regards,
>>>
>>> Naga
>>>
>>
>>
>>
>> --
>> Sincerely
>> Ram Srinivasan
>
>
>

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

Received on Thu Mar 26 2009 - 07:46:25 CDT