Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Newbie RMAN question: recovery catalogue

Re: Newbie RMAN question: recovery catalogue

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Wed, 10 Jan 2007 19:52:08 +0000
Message-ID: <45A543E8.4040708@dial.pipex.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US