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 -> Need assistance with RMAN reporting

Need assistance with RMAN reporting

From: <i95dblr_at_gmail.com>
Date: 7 Nov 2005 11:26:06 -0800
Message-ID: <1131391566.121524.174430@z14g2000cwz.googlegroups.com>


I'm new to Oracle and RMAN & would appreciate any help with this problem. My boss wants me to extract the following information from the backups that use the recovery catalog database: Client Name
Backup Date
Backup Start time
Elapsed Time
Job Name (Policy Name) if applicable
Number of files
Database Name
Size in Kbs
Schedule Type
Status of Backup

I checked the recovery catalog's rman schema, but I'm unable to come up with the correct tables to query. I have the Oracle9i RMAN Backup & Recovery book but it doesn't go into too much detail abour how to pull information from the recovery cataloge. If anyone could point me in the right direction I would appreciate it. Received on Mon Nov 07 2005 - 13:26:06 CST

Original text of this message

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