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 17:44:32 +0000
Message-ID: <45A52600.9020707@dial.pipex.com>


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
Received on Wed Jan 10 2007 - 11:44:32 CST

Original text of this message

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