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: total backup size (lvl0/lvl1) out of rman catalog

Re: total backup size (lvl0/lvl1) out of rman catalog

From: sybrandb <sybrandb_at_gmail.com>
Date: 3 Apr 2007 08:57:11 -0700
Message-ID: <1175615831.295897.223160@l77g2000hsb.googlegroups.com>


On Apr 3, 5:20 pm, NetComrade <netcomradeNS..._at_bookexchange.net> wrote:
> Does anyone has a query, or at least a column that identifies the
> whole backup in catalog views? We need a report of backup sizes, w/o
> having to look at the file system.
>
> Thanks
> .......
> We run Oracle 9iR2,10gR1/2 on RH4/RH3 and Solaris 10 (Sparc)
> remove NSPAM to email

It's not THAT difficult and all the RC views are fully documented. You would need RC_BACKUP, RC_BACKUPSET and RC_BACKUPPIECE.

--
Sybrand Bakker
Senior Oracle DBA
Received on Tue Apr 03 2007 - 10:57:11 CDT

Original text of this message

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