EscVector wrote:
> Niall Litchfield wrote:
>> sybrandb wrote:
>>> With 5 instances I would probably still use a catalog database. Do you
>>> want to connect to 5 different instances to retrieve backup
>>> information?
>> That was my position as well. However since moving our rman repository
>> to 10.2 I'm finding that the status of the 10.2 backups in the recovery
>> catalog views is incorrect. Specifically
>>
>> select db_name,operation,status
>> from rc_rman_status
>> where start_time > sysdate -1
>> and operation = 'BACKUP'
>> order by 1,start_time desc;
>>
>> doesn't return the correct status for earlier release databases.
>>
>>
>>
>> --
>> Niall Litchfield
>> Oracle DBA
>> http://www.orawin.info/services
>
>> doesn't return the correct status for earlier release databases.
>
> Do you know if this applies to the controlfile backup views or just the
> catalog?
>
The controlfile views were correct IIRC, but then I'd have to connect to
each database to see them. I'm after one report for backup activity last
night for all our databases so if anyone has any bright suggestions feel
free.
--
Niall Litchfield
Oracle DBA
http://www.orawin.info/services
Received on Wed Jan 10 2007 - 13:52:08 CST