Re: RMAN Log Analyzer

On Sep 11, 7:19 am, Kake...._at_gmail.com wrote:
> > Please refer to v$backupset (non catalogued backups) and rc_backupset
> > (catalogued backups).
> > A few sql scripts would suffice.
>
> > --
> > Sybrand Bakker
> > Senior Oracle DBA
>
> Well the annoying thing is that I can access the database.

Why is database access annoying? Or did you mean you CAN'T access the database? In that case, yes, it would be rather inconvenient when trying to extract data.

> I run a
> Backup on an another system. The Oracle uses my Filebackup system, my
> file server and my tape devices. Problem is that the Oracle backup has
> started to mess my Filebackup because the backup time has extended too
> much.

And what do you expect the DBA to do? Reschedule the database backups? Why can't you reschedule your backups to avoid conflict?

> Also it has started to fill my disk space.

Request additional space, disk is cheap. And I'm certain management won't want to lose any of the backups, database or otherwise, due to available space.

> Now I want to prove
> in statistically that the Oracle people need to do something, or I
> need to get better Backup System. When I show up with the data, they
> can't ignore me anymore.

You have sufficient data to show your current backup system is either good or bad for this enterprise, without slogging through the database, if that's what you're trying to prove. If you're trying to prove the Oracle people are at fault because of the volume of data the enterprise processes on a daily/weekly/monthly basis I think you need another activity.

David Fitzjarrell Received on Tue Sep 11 2007 - 11:48:49 CDT