Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: total backup size (lvl0/lvl1) out of rman catalog
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 DBAReceived on Tue Apr 03 2007 - 10:57:11 CDT