To preface... Our Senior Oracle DBA has just recently passed away, and I've been taking over. My level of experience is just a junior level. So there is a lot I still don't understand. So I appreciate all the tips I can get, as this is a very frightening position for me.
Our technical issue... My company has just run out of storage space available in the mounted filesystem, and it is preventing us from recording backups any longer.
I have done my due diligence and cleaned up any obsolete data, but it did not help. The sys admin team is suggesting that we reduce the number of days that RMAN retains our backups. Retention Policy is currently set on default 7 days, I have considered changing this to 5, however 7 days just seems simpler as we hardly have any activity running over the weekend.
My question... What are your suggestions on things I can do to help clear up more space? What RMAN configurations should I consider looking through? Please advise with any thoughts...
We are running in archivelog mode, we are also doing incremental backups, (and full DB backups), all of which are failing and not recording backups due to the space issue. So there is currently no way to restore anything. Personally, I believe 7 days is ideal and simpler. Much easier to monitor when backups are recorded every weekend.