First, I am very new to Oracle administration so bear with me. I was recently given an Oracle 11g database (on a Windows machine) that has been neglected since Oct 2021. It has so many GB of archivelog files that it's causing a disk space issue, like thousands of files and making more every day.
Some of the archives are missing and can't be recovered. Currently, the database is healthy. So what I want to do is throw out the old backup and its archivelogs and start fresh but I can't seem to clear the old backup because there are so many of them.
When trying to run the command “RMAN> BACKUP AS BACKUPSET DATABASE PLUS ARCHIVELOG;” I get an:
ORA-19809: limit exceeded for recovery files
followed by:
ORA-19804: cannot reclaim 16631175680 bytes disk space from 2147483648 limit continuing other job steps, job failed will not be re-run
Is there a better way to do this?